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>='1575590400')) ORDER BY pm1.meta_value DESC, post_date DESC
Des Moines - Central
Found: 12/11/2019
Animal ID: 181931
Des Moines - Central
Found: 12/11/2019
Animal ID: 181938
West Des Moines
Found: 12/11/2019
ID: 13011
Name: Unknown
Type: Cat
Color: Black, White, and Orange Calico
Breed: Calico
Gender: Female
Fixed: Unknown
Age: Adult
Scheel's Parking Lot at Jordan Creek Mall
West Des Moines
Found: 12/11/2019
ID: 13010
Name: Unknown
Type: Cat
Color: Black, White, and Orange Calico
Breed: Calico
Gender: Female
Fixed: Unknown
Age: Adult
Scheel's Parking Lot at Jordan Creek
Des Moines - Central
Found: 12/10/2019
Animal ID: 181901
West Des Moines
Found: 12/10/2019
ID: 13004
Name:
Type: Cat
Color: Brown and Black Tabby
Breed: Domestic Short Hair
Gender: Unknown
Fixed: Unknown
Age: Young
8900 block of Wendover Road
West Des Moines
Found: 12/10/2019
ID: 13003
Name:
Type: Cat
Color: Black and White
Breed: Domestic Medium Hair
Gender: Unknown
Fixed: Unknown
Age: Adult
4000 block of 66th street in Urbandale north of Aurora
Ankeny
Found: 12/10/2019
Animal ID: 181911
Johnston
Found: 12/10/2019
Animal ID: 181910
Grimes
Found: 12/10/2019
Animal ID: 181909
Des Moines - Central
Found: 12/10/2019
Animal ID: 181819
Des Moines - North
Found: 12/10/2019
Animal ID: 181804
Des Moines - North
Found: 12/10/2019
Animal ID: 181808
Ankeny
Found: 12/9/2019
Animal ID: 181689
Des Moines - North
Found: 12/9/2019
Animal ID: 181667
Des Moines - Central
Found: 12/8/2019
ID:
Name: arlacc-
Type: Cat
Color:
Breed: Domestic Medium Hair
Gender:
Fixed:
Age:
Female cat, no microchip or identification - she is located at Fury Friends in DSM
Nevada
Found: 12/8/2019
ID: 12999
Name:
Type: Cat
Color: Tabby
Breed: Domestic Short Hair
Gender: Male
Fixed: Neutered
Age: Adult
Very Friendly
West Des Moines
Found: 12/8/2019
ID: 12997
Name:
Type: Dog
Color: Tan
Breed: Shih Tzu
Gender: Unknown
Fixed: Unknown
Age: Adult
Walnut Woods Park
Des Moines - Central
Found: 12/8/2019
ID: 12995
Name: Unknown
Type: Cat
Color: Black, White, and Orange Calico
Breed: Domestic Short Hair
Gender: Female
Fixed: Unknown
Age: Adult
Des Moines
Des Moines - Central
Found: 12/8/2019
Animal ID: 181665
Des Moines - Central
Found: 12/8/2019
Animal ID: 181666
Des Moines - Central
Found: 12/8/2019
Animal ID: 181660
Ankeny
Found: 12/8/2019
Animal ID: 181661
Johnston
Found: 12/8/2019
Animal ID: 181658
West Des Moines
Found: 12/8/2019
ID: 12992
Name:
Type: Dog
Color: Brown and Black
Breed: Yorkshire Terrier Yorkie
Gender: Unknown
Fixed: Unknown
Age: Senior
Found in the 5000 block of Ashworth in WDM