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' or pm.meta_value = 'found' or pm.meta_value = 'Spotted') AND pm2.meta_value = 'Active' AND (pm3.meta_value IS NULL or (pm3.meta_value IS NOT NULL AND pm1.meta_value>='1558051200')) ORDER BY pm1.meta_value DESC, post_date DESC
Ankeny
Found: 5/23/2019
Animal ID: 172537
Clare
Lost: 5/22/2019
ID: 11399
Name: Luna
Type: Dog
Color: White with brown dpots
Breed: Chihuahua
Gender: Female
Fixed: Not Neutered
Age: Young
8 miles west of Clare.
North Liberty
Lost: 5/22/2019
ID: 11398
Name: Gus
Type: Dog
Color: Liver
Breed: German Wirehaired Pointer
Gender: Male
Fixed: Neutered
Age: Adult
Last seen headed Southwest of the Penn and 965 area
Des Moines - South
Lost: 5/22/2019
ID: 11397
Name: Walter
Type: Cat
Color: Gray
Breed: German Wirehaired Pointer
Gender: Male
Fixed: Neutered
Age: Adult
Last seen on our security camera escaping the house because the Mid American Energy meter men did not close our door after they entered our house.
Ankeny
Found: 5/22/2019
Animal ID: 172503
Des Moines - Central
Found: 5/22/2019
Animal ID: 172482
Des Moines - Central
Found: 5/22/2019
Animal ID: 172499
Des Moines - Central
Found: 5/22/2019
Animal ID: 172489
Des Moines - Central
Found: 5/22/2019
Animal ID: 172490
Des Moines - Central
Found: 5/22/2019
Animal ID: 172488
Des Moines - Central
Found: 5/22/2019
Animal ID: 172504
Des Moines - Central
Found: 5/22/2019
Animal ID: 172507
Altoona
Found: 5/22/2019
Animal ID: 172497
Altoona
Found: 5/22/2019
Animal ID: 172494
Des Moines - North
Lost: 5/22/2019
ID: 11393
Name: Midnight
Type: Cat
Color: Black
Breed: German Wirehaired Pointer
Gender: Male
Fixed: Not Neutered
Age: Young
He lives in the north high school area hes not an outside cat
Des Moines - Central
Found: 5/21/2019
Animal ID: 172451
Des Moines - Central
Found: 5/21/2019
Animal ID: 172437
West Des Moines
Found: 5/21/2019
ID: 11392
Name:
Type: Rabbit
Color: Brown and Tan
Breed: Himalayan
Gender: Male
Fixed: Unknown
Age: Adult
West Des Moines area.
Des Moines - South
Lost: 5/21/2019
ID: 11391
Name: Miley
Type: Cat
Color: Dark Grey
Breed: Domestic Short Hair
Gender: Female
Fixed: Not Neutered
Age: Adult
Miley was last seen at SW 12th Pl and Thornton Ave. We last saw her on 4/8/19. We miss her so much and just want her to come back home! Please contact me if you have seen her at all. 5154012478
Des Moines - Central
Found: 5/21/2019
Animal ID: 172476
Des Moines - Central
Found: 5/21/2019
Animal ID: 172477
Des Moines - Central
Found: 5/21/2019
Animal ID: 172468
Pleasant Hill
Found: 5/21/2019
Animal ID: 172467
Des Moines - North
Found: 5/21/2019
Animal ID: 172456
Pleasant Hill
Found: 5/21/2019
Animal ID: 172466