Filter By
     
SELECT * FROM ipa_wp_posts LEFT JOIN ipa_wp_postmeta AS pm ON( ipa_wp_posts.ID = pm.post_id AND pm.meta_key = 'pet_listings_listing_type' ) LEFT JOIN ipa_wp_postmeta AS pm1 ON( ipa_wp_posts.ID = pm1.post_id AND pm1.meta_key = 'pet_listings_date_lost_found' ) LEFT JOIN ipa_wp_postmeta AS pm2 ON( ipa_wp_posts.ID = pm2.post_id AND pm2.meta_key = 'pet_listings_listing_status' ) LEFT JOIN ipa_wp_postmeta AS pm3 ON( ipa_wp_posts.ID = pm3.post_id AND pm3.meta_key = 'pet_listings_shelterid' ) WHERE ipa_wp_posts.post_status = 'publish' AND ipa_wp_posts.post_type = 'pet_listings' AND (pm.meta_value = 'lost' ) AND pm2.meta_value = 'Active' AND (pm3.meta_value IS NULL or (pm3.meta_value IS NOT NULL AND pm1.meta_value>='1435363200')) ORDER BY pm1.meta_value DESC, post_date DESC
Urbandale
Lost: 7/3/2015
ID: 904
Name: Zeus
Type: Dog
Color: Black and White
Breed: Siberian Husky
Gender: Male
Fixed: Neutered
Age: Young
He has 3 legs
Des Moines - South
Lost: 7/2/2015
ID: 899
Name: Rocco
Type: Dog
Color: Black with grey spots
Breed: Dachshund
Gender: Male
Fixed: Unknown
Age: Adult
Valdosta trailer court
Ankeny
Lost: 7/1/2015
ID: 900
Name: Jack
Type: Cat
Color: Black
Breed: Dachshund
Gender: Male
Fixed: Neutered
Age: Adult
Jack got out 7/1 and has not been seen since. He is all black with some very small white patches under his armpits and on his chest. He will likely run from people who try to approach. He has a blue and black Kong brand collar with a red rabies tag and green licence tag. Last seen in Ankeny Iowa. He is around 11 lbs but with a slender build and tall.
Maxwell
Lost: 7/1/2015
ID: 898
Name: Zoey
Type: Dog
Color: Black with other under belly
Breed: Labrador Retriever
Gender: Female
Fixed: Neutered
Age: Adult
Last seen running in Maxwell. Very friendly.
Ankeny
Lost: 7/1/2015
ID: 896
Name: Storm
Type: Cat
Color: Grey
Breed: American Shorthair
Gender: Male
Fixed: Neutered
Age: Young
Declawed. Lost in Briarwood South neighborhood.
Des Moines - East
Lost: 7/1/2015
ID: 891
Name: gizzie
Type: Dog
Color: black with some white around nose and mouth
Breed: American Shorthair
Gender: Male
Fixed: Not Neutered
Age: Senior
hes half pomerainon,half poodle hes got on a black tshirt with lil paw prints on the back
Des Moines - East
Lost: 7/1/2015
ID: 890
Name: gizzie
Type: Dog
Color: black with some white around nose and mouth
Breed: Pomeranian
Gender: Male
Fixed: Not Neutered
Age: Senior
hes half pomerainon,half poodle hes got on a black tshirt with lil paw prints on the back
Des Moines - Central
Lost: 7/1/2015
ID: 887
Name: Penny
Type: Dog
Color: Brown with some white
Breed: Australian Shepherd
Gender: Female
Fixed: Neutered
Age: Adult
Last seen in Beaverdale
Bondurant
Lost: 6/30/2015
ID: 897
Name: Pretty
Type: Cat
Color: Calaco
Breed: Australian Shepherd
Gender: Female
Fixed: Neutered
Age: Adult
Des Moines - East
Lost: 6/29/2015
ID: 865
Name: Zoey
Type: Dog
Color: white and brown
Breed: Jack Russell Terrier
Gender: Male
Fixed: Not Applicable
Age: Senior
Last seen headed to 14th and dean.she is verry friendly we have had her for 13 years she is afraid of loud noises.