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>='1600387200')) ORDER BY pm1.meta_value DESC, post_date DESC
West Des Moines
Found: 9/21/2020
ID: 15010
Name: Sajha
Type: Dog
Color: white/yellow
Breed: Labrador Retriever
Gender: Female
Fixed: Unknown
Age: Adult
Hidden Valley Soccer Field
Waterloo
Found: 9/21/2020
ID: 15009
Name:
Type: Dog
Color: Black
Breed: Mix
Gender: Female
Fixed: Unknown
Age: Young
Picked up near Laporte Rd/Clark gas station
Polk City
Found: 9/21/2020
Animal ID: 192244
Des Moines - East
Found: 9/21/2020
Animal ID: 192239
Des Moines - Central
Found: 9/21/2020
Animal ID: 192237
Des Moines - North
Found: 9/21/2020
Animal ID: 192185
came in with AID 192184
Des Moines - North
Found: 9/21/2020
Animal ID: 192184
came in with AID 192185
Des Moines - Central
Found: 9/20/2020
Animal ID: 192178
Des Moines - South
Found: 9/20/2020
Animal ID: 192198
Des Moines - South
Found: 9/20/2020
Animal ID: 192199
Des Moines - South
Found: 9/20/2020
Animal ID: 192199
Des Moines - South
Found: 9/20/2020
Animal ID: 192196
Des Moines - South
Found: 9/20/2020
Animal ID: 192197
Des Moines - Central
Found: 9/20/2020
Animal ID: 192189
Des Moines - Central
Found: 9/20/2020
Animal ID: 145790
microchipped dog named Cali
Des Moines - East
Found: 9/20/2020
ID: 15002
Name:
Type: Dog
Color:
Breed: Mix
Gender: Male
Fixed: Unknown
Age: Senior
Des Moines - North
Found: 9/20/2020
Animal ID: 124698
Des Moines - Central
Found: 9/20/2020
Animal ID: 192158
Perry
Found: 9/20/2020
Animal ID: 192156
Des Moines - North
Found: 9/20/2020
Animal ID: 192150
Des Moines - Central
Found: 9/19/2020
Animal ID: 192175
Microchipped dog named MAX
Des Moines - Central
Found: 9/19/2020
Animal ID: 192125
Des Moines - Central
Found: 9/19/2020
Animal ID: 72937
Des Moines - Central
Found: 9/19/2020
Animal ID: 192148
Des Moines - North
Found: 9/19/2020
Animal ID: 192133