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>='1585008000')) ORDER BY pm1.meta_value DESC, post_date DESC
Des Moines - Central
Found: 3/29/2020
Animal ID: 185289
Des Moines - Central
Found: 3/29/2020
Animal ID: 185288
West Des Moines
Found: 3/29/2020
ID: 13658
Name:
Type: Cat
Color: Grey and White
Breed: Domestic Short Hair
Gender: Unknown
Fixed: Unknown
Age: Young
Urbandale
Found: 3/29/2020
Animal ID: 185287
Urbandale
Found: 3/29/2020
Animal ID: 185286
Des Moines - North
Found: 3/29/2020
ID: 13656
Name: Unknown
Type: Dog
Color: Grayish
Breed: Pit Bull
Gender: Male
Fixed: Unknown
Age: Baby
He’s staying with me till we find his family. He is neutered. Super friendly.
Des Moines - North
Found: 3/29/2020
Animal ID: 185273
Name is Diesel
Des Moines - Central
Found: 3/29/2020
ID: 13653
Name:
Type: Dog
Color: Black and white
Breed: Boxer
Gender: Female
Fixed: Unknown
Age: Adult
Found near Moulton Elementary
Des Moines - South
Found: 3/28/2020
Animal ID: 156774
Des Moines - Central
Found: 3/27/2020
Animal ID: 185227
Des Moines - Central
Found: 3/27/2020
Animal ID: 185169
Des Moines - Central
Found: 3/27/2020
Animal ID: 185222
Des Moines - Central
Found: 3/26/2020
Animal ID: 185210
Des Moines - Central
Found: 3/26/2020
Animal ID: 185204
Des Moines - Central
Found: 3/26/2020
Animal ID: 185200
Marion
Found: 3/26/2020
ID: 13633
Name:
Type: Cat
Color: Gray tabby
Breed: Tabby
Gender: Female
Fixed: Not Neutered
Age: Young
At MercyCare Marion clinic. Extremely friendly and comfortable with people and riding in the car. Looks like she has recently weaned kittens.
Grimes
Found: 3/25/2020
Animal ID: 185172
Des Moines - Central
Found: 3/25/2020
Animal ID: 185166
Des Moines - Central
Found: 3/25/2020
Animal ID: 185164
Found at Grandview park
Clive
Found: 3/25/2020
ID: 13628
Name:
Type: Dog
Color: Tan and White
Breed: Boxer
Gender: Male
Fixed: Unknown
Age: Adult
Des Moines - Central
Found: 3/24/2020
Animal ID: 185169
Des Moines - North
Found: 3/24/2020
Animal ID: 172993
Pleasant Hill
Found: 3/24/2020
Animal ID: 185151
Grimes
Found: 3/24/2020
Animal ID: 185140
West Des Moines
Found: 3/22/2020
ID: 13616
Name:
Type: Small or Furry
Color: Black, Brown, and White
Breed: Ferret
Gender: Unknown
Fixed: Neutered
Age: Adult
Kum and Go Parking Lot on Mills Civic Parkway