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>='1495411200')) ORDER BY pm1.meta_value DESC, post_date DESC
Des Moines - East
Lost: 5/27/2017
ID: 5699
Name: Wrigley
Type: Dog
Color: White/ black/grey
Breed: Havanese
Gender: Male
Fixed: Neutered
Age: Young
Des Moines - South
Lost: 5/27/2017
ID: 5698
Name: Kaiser
Type: Dog
Color: black & tan
Breed: Dachshund-Miniature
Gender: Male
Fixed: Not Neutered
Age: Adult
Just brought him home from southern Illinois. Just got to Des Moines and he slipped collar and took off running. He has no idea where he is.
Des Moines - North
Lost: 5/27/2017
ID: 5697
Name: Emeli
Type: Dog
Color: White/tan
Breed: American Bulldog
Gender: Male
Fixed: Not Neutered
Age: Young
Clive
Lost: 5/27/2017
ID: 5690
Name: Millie
Type: Dog
Color: White
Breed: German Shepherd/Purebred
Gender: Female
Fixed: Neutered
Age: Young
Clive around 105th St
Berwick
Lost: 5/26/2017
ID: 5694
Name: Dbo
Type: Cat
Color: Black grey brown
Breed: Maine Coon
Gender: Male
Fixed: Neutered
Age: Adult
Berwick
Lost: 5/26/2017
ID: 5693
Name: D-Bo
Type: Cat
Color: Black brown
Breed: Maine Coon
Gender: Male
Fixed: Neutered
Age: Adult
Urbandale
Lost: 5/26/2017
ID: 5692
Name: Bogey
Type: Dog
Color: White
Breed: Bull Terrier
Gender: Male
Fixed: Neutered
Age: Adult
Des Moines - East
Lost: 5/26/2017
ID: 5688
Name: Capone
Type: Dog
Color: Brindle
Breed: American Bulldog
Gender: Male
Fixed: Not Neutered
Age: Senior
He doesn't like other dogs! Lost close to E 13th & University Ave, Des Moines IA
Ankeny
Lost: 5/25/2017
ID: 5689
Name: Muffin
Type: Cat
Color: White/Gray
Breed: Persian
Gender: Male
Fixed: Neutered
Age: Adult
Last saw him the night of May 25th in Ankeny - Pine View/Boulder Point area. New development. He's shy but very friendly. Had very long hair that's White with grey on his feet and face. He responds to the name Muffin.
Ankeny
Lost: 5/25/2017
ID: 5687
Name: Cyrus
Type: Cat
Color: Gray & White long hair
Breed: Persian
Gender: Male
Fixed: Neutered
Age: Adult
Se Delaware area, Prairie Glen/Meadow Ridge townhomes. Friendly but shy, has been a stray previously.