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>='1547424000')) ORDER BY pm1.meta_value DESC, post_date DESC
Bondurant
Found: 1/20/2019
Animal ID: 168197
Bondurant
Found: 1/19/2019
Animal ID: 168188
Bondurant
Found: 1/19/2019
Animal ID: 168187
Pleasant Hill
Found: 1/19/2019
Animal ID: 168196
Johnston
Found: 1/19/2019
Animal ID: 168193
Urbandale
Found: 1/19/2019
ID: 10481
Name:
Type: Cat
Color: Grey Tabby
Breed: Domestic Short Hair
Gender: Male
Fixed: Not Neutered
Age: Young
found in the 2900 block of 70th St
Des Moines - Central
Found: 1/19/2019
Animal ID: 168179
Des Moines - Central
Found: 1/19/2019
Animal ID: 144296
Ankeny
Found: 1/19/2019
Animal ID: 168181
Des Moines - Central
Found: 1/18/2019
Animal ID: 168172
Urbandale
Found: 1/18/2019
ID: 10484
Name:
Type: Cat
Color: Orange Tabby
Breed: Domestic Short Hair
Gender: Male
Fixed: Not Neutered
Age: Adult
146th Street
Clive
Found: 1/18/2019
ID: 10483
Name:
Type: Cat
Color: Orange Tabby
Breed: Domestic Short Hair
Gender: Male
Fixed: Not Neutered
Age: Adult
2600 block of Alice Rd
Urbandale
Found: 1/18/2019
ID: 10482
Name:
Type: Cat
Color: Brown Tabby
Breed: Domestic Short Hair
Gender: Male
Fixed: Not Neutered
Age: Young
14000 block of Aurora
Des Moines - Central
Found: 1/18/2019
Animal ID: 168170
Des Moines - Central
Found: 1/18/2019
Animal ID: 88731
Des Moines - Central
Found: 1/17/2019
Animal ID: 168152
Altoona
Found: 1/17/2019
Animal ID: 168154
Melcher-Dallas
Found: 1/16/2019
ID: 10475
Name:
Type: Cat
Color:
Breed: Domestic Medium Hair
Gender: Female
Fixed: Unknown
Age: Adult
Des Moines - Central
Found: 1/16/2019
Animal ID: 168138
Altoona
Found: 1/16/2019
Animal ID: 168137
Ankeny
Found: 1/16/2019
Animal ID: 168132
Des Moines - East
Found: 1/15/2019
ID: 10460
Name:
Type: Dog
Color: White
Breed: Great Pyrenees
Gender: Male
Fixed: Unknown
Age: Adult
Found this cute doggy at QT on E 14th & Grand ave. Please call or text 515-441-1325
Johnston
Found: 1/15/2019
Animal ID: 168124
Des Moines - North
Found: 1/15/2019
Animal ID: 168123
Des Moines - Central
Found: 1/15/2019
Animal ID: 168119