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>='1578787200')) ORDER BY pm1.meta_value DESC, post_date DESC
Elkhart
Found: 1/17/2020
Animal ID: 183098
Des Moines - Central
Found: 1/17/2020
Animal ID: 183094
Des Moines - Central
Found: 1/17/2020
Animal ID: 183087
Urbandale
Found: 1/16/2020
ID: 13253
Name: Unknown
Type: Cat
Color: Brown and Black Tabby
Breed: Domestic Short Hair
Gender: Female
Fixed: Not Neutered
Age: Adult
Last seen at 142nd street and Sheridan ave in Urbandale. Cat was hit by a car and unfortunately did not survive her injuries :(
Des Moines - Central
Found: 1/16/2020
Animal ID: 183081
Des Moines - Central
Found: 1/16/2020
Animal ID: 183073
Altoona
Found: 1/16/2020
Animal ID: 183062
Des Moines - Central
Found: 1/15/2020
Animal ID: 183066
West Des Moines
Found: 1/15/2020
ID: 13250
Name: Unknown
Type: Cat
Color: Orange Tabby
Breed: Domestic Short Hair
Gender: Unknown
Fixed: Unknown
Age: Young
Last seen in the 5000 block of Vista Dr
West Des Moines
Found: 1/15/2020
ID: 13249
Name: Unknown
Type: Cat
Color: Brown and White Tabby
Breed: Domestic Short Hair
Gender: Unknown
Fixed: Unknown
Age: Young
Last seen in the 5000 block of Vista Dr
West Des Moines
Found: 1/15/2020
ID: 13248
Name: Unknown
Type: Cat
Color: Black
Breed: Domestic Short Hair
Gender: Unknown
Fixed: Unknown
Age: Adult
Last seen in 5000 block of Vista Dr
Altoona
Found: 1/15/2020
Animal ID: 183048
Des Moines - Central
Found: 1/15/2020
Animal ID: 171947
Des Moines - Central
Found: 1/15/2020
Animal ID: 183045
Bondurant
Found: 1/15/2020
Animal ID: 183038
Des Moines - Central
Found: 1/14/2020
Animal ID: 183041
Des Moines - East
Found: 1/14/2020
Animal ID: 182999
Des Moines - Central
Found: 1/13/2020
Animal ID: 182981
Des Moines - Central
Found: 1/13/2020
Animal ID: 175848
Des Moines - North
Found: 1/13/2020
Animal ID: 182964
Des Moines - North
Found: 1/13/2020
Animal ID: 182963
Des Moines - North
Found: 1/13/2020
Animal ID: 182961
Des Moines - Central
Found: 1/13/2020
Animal ID: 182948
Des Moines - Central
Found: 1/13/2020
Animal ID: 162726
West Des Moines
Found: 1/13/2020
ID: 13242
Name:
Type: Cat
Color: brown and orange torbie
Breed: Domestic Short Hair
Gender: Female
Fixed: Unknown
Age: Adult
2200 Block of Grand Avenue in WDM