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>='1606003200')) ORDER BY pm1.meta_value DESC, post_date DESC
Des Moines - North
Found: 11/27/2020
Animal ID: 160216
Des Moines - North
Found: 11/27/2020
Animal ID: 194986
Des Moines - Central
Found: 11/27/2020
Animal ID: 194978
Des Moines - Central
Found: 11/27/2020
Animal ID: 176988
Des Moines - Central
Found: 11/27/2020
Animal ID: 194961
Des Moines - Central
Found: 11/27/2020
Animal ID: 194981
Ankeny
Found: 11/27/2020
Animal ID: 188908
Altoona
Found: 11/27/2020
Animal ID: 194960
Des Moines - Central
Found: 11/26/2020
Animal ID: 194980
Norwalk
Found: 11/26/2020
ID: 15560
Name:
Type: Cat
Color: Black
Breed:
Gender: Female
Fixed: Unknown
Age: Baby
Found super friendly black kitten approximately 5 months old
Des Moines - Central
Found: 11/25/2020
Animal ID: 194955
Des Moines - Central
Found: 11/25/2020
Animal ID: 194950
Des Moines - Central
Found: 11/25/2020
Animal ID: 194953
Des Moines - Central
Found: 11/25/2020
Animal ID: 194951
Des Moines - Central
Found: 11/25/2020
Animal ID: 194952
Ankeny
Found: 11/25/2020
ID: 15555
Name:
Type: Dog
Color:
Breed: Pit Bull
Gender: Female
Fixed: Unknown
Age: Young
Found on SW side of Ankeny
Des Moines - North
Found: 11/25/2020
ID: 15554
Name: Pana
Type: Dog
Color: Brindle
Breed: Pit Bull
Gender: Male
Fixed: Not Neutered
Age: Adult
Very very friendly. He’ll probably think your playing with him and will run away quickly but just approach slow. Last seen near the Grubb YMCA near 10th and Clark
Ankeny
Found: 11/25/2020
Animal ID: 194949
found with 194948
Ankeny
Found: 11/25/2020
Animal ID: 194948
Found with194949
Des Moines - North
Found: 11/25/2020
Animal ID: 194947
Des Moines - North
Found: 11/24/2020
Animal ID: 194943
found with blue and tan flower patterned collar. Possibly named Roxy.
Des Moines - Central
Found: 11/24/2020
Animal ID: 194939
Des Moines - Central
Found: 11/24/2020
Animal ID: 194896
Des Moines - North
Found: 11/24/2020
Animal ID: 194937
Des Moines - Central
Found: 11/24/2020
Animal ID: 168316