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 = 'found' AND pm2.meta_value = 'Active' AND (pm3.meta_value IS NULL or (pm3.meta_value IS NOT NULL AND pm1.meta_value>='1589932800')) ORDER BY pm1.meta_value DESC, post_date DESC
Pleasant Hill
Found: 5/25/2020
Animal ID: 187172
West Des Moines
Found: 5/23/2020
ID: 14085
Name:
Type: Dog
Color: black and white
Breed: Pit Bull
Gender: Female
Fixed: Unknown
Age: Adult
1800 Fuller Rd West Des Moines Nails are polished red.
Altoona
Found: 5/23/2020
Animal ID: 187135
Des Moines - Central
Found: 5/22/2020
Animal ID: 187102
Des Moines - Central
Found: 5/22/2020
Animal ID: 184536
Des Moines - Central
Found: 5/22/2020
Animal ID: 187108
Des Moines - Central
Found: 5/22/2020
Animal ID: 187112
Des Moines - Central
Found: 5/22/2020
Animal ID: 187111
Des Moines - Central
Found: 5/22/2020
Animal ID: 187109
Des Moines - North
Found: 5/22/2020
Animal ID: 169353
Des Moines - North
Found: 5/22/2020
Animal ID: 187102
This animal will be transferred to our Animal Services location at 1615 SE 14th ST, Des Moines, 50320. Ph: 515-284-6905
Des Moines - North
Found: 5/21/2020
ID: 14056
Name:
Type: Dog
Color: Brown/whitte
Breed: Beagle
Gender: Male
Fixed: Unknown
Age: Adult
Has collar, but won’t let anyone close. Very scared and narking
Des Moines - Central
Found: 5/21/2020
Animal ID: 186964
Des Moines - Central
Found: 5/21/2020
Animal ID: 186966
Des Moines - Central
Found: 5/21/2020
Animal ID: 186968
Des Moines - Central
Found: 5/21/2020
Animal ID: 186965
Des Moines - Central
Found: 5/21/2020
Animal ID: 187061
Des Moines - Central
Found: 5/21/2020
Animal ID: 187065
Des Moines - Central
Found: 5/21/2020
Animal ID: 187062
Des Moines - Central
Found: 5/21/2020
Animal ID: 187063
Des Moines - Central
Found: 5/21/2020
Animal ID: 187064
Altoona
Found: 5/21/2020
Animal ID: 161586
Ankeny
Found: 5/21/2020
Animal ID: 139817
West Des Moines
Found: 5/21/2020
ID: 14051
Name:
Type: Dog
Color: White black and brown
Breed: Beagle
Gender: Female
Fixed: Unknown
Age: Adult
Urbandale
Found: 5/21/2020
ID: 14050
Name:
Type: Dog
Color: Black
Breed: Labrador Retriever
Gender: Male
Fixed: Unknown
Age: Adult