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>='1562803200')) ORDER BY pm1.meta_value DESC, post_date DESC
West Des Moines
Found: 7/17/2019
ID: 11898
Name:
Type: Cat
Color: Brown and Black Tabby
Breed: Domestic Short Hair
Gender: Male
Fixed: Neutered
Age: Adult
6th and Locust
Des Moines - Central
Found: 7/17/2019
Animal ID: 175444
Des Moines - Central
Found: 7/17/2019
Animal ID: 175442
Pleasant Hill
Found: 7/17/2019
Animal ID: 175458
Des Moines - Central
Found: 7/17/2019
Animal ID: 175365
Des Moines - South
Found: 7/17/2019
ID: 11893
Name: Unknown
Type: Dog
Color: Black/Brown
Breed: German Shepherd/Purebred
Gender: Unknown
Fixed: Not Applicable
Age: Adult
Lamoni
Found: 7/16/2019
Animal ID: 175457
Des Moines - Central
Found: 7/16/2019
Animal ID: 175403
Des Moines - Central
Found: 7/16/2019
Animal ID: 175397
Des Moines - Central
Found: 7/16/2019
Animal ID: 117660
Des Moines - Central
Found: 7/16/2019
Animal ID: 175400
Des Moines - Central
Found: 7/15/2019
Animal ID: 175342
Des Moines - Central
Found: 7/15/2019
Animal ID: 175364
Ankeny
Found: 7/15/2019
ID: 11886
Name: Mojo
Type: Dog
Color: Black
Breed: Pinscher
Gender: Male
Fixed: Not Neutered
Age: Senior
I found mojo !! He was stuck in the garage .
Des Moines - Central
Found: 7/15/2019
Animal ID: 175323
Des Moines - Central
Found: 7/15/2019
Animal ID: 175324
Des Moines - Central
Found: 7/14/2019
Animal ID: 175411
Des Moines - Central
Found: 7/14/2019
Animal ID: 175366
West Des Moines
Found: 7/14/2019
ID: 11871
Name:
Type: Cat
Color: Black
Breed: Domestic Short Hair
Gender: Male
Fixed: Not Neutered
Age: Baby
Found at DMACC West Campus
Clive
Found: 7/14/2019
ID: 11870
Name: A42209570
Type: Cat
Color: cream and brown
Breed: Siamese
Gender: Unknown
Fixed: Unknown
Age: Baby
8000 block Harbach Blvd.
Ankeny
Found: 7/14/2019
Animal ID: 161704
Altoona
Found: 7/14/2019
Animal ID: 118602
Altoona
Found: 7/14/2019
Animal ID: 174650
Altoona
Found: 7/14/2019
Animal ID: 174650
Des Moines - Central
Found: 7/13/2019
Animal ID: 175279