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>='1565913600')) ORDER BY pm1.meta_value DESC, post_date DESC
Des Moines - East
Found: 8/21/2019ID: 12177Name: Type: CatColor: Tabby -brown/black with some orange on faceBreed: American ShorthairGender: MaleFixed: UnknownAge: Baby
Found near Sargent Park bike trail on Eastbound aside of Des Moines
Altoona
Found: 8/21/2019Animal ID: 177074
Des Moines - Central
Found: 8/21/2019Animal ID: 177072
Des Moines - Central
Found: 8/21/2019Animal ID: 177065
Des Moines - North
Found: 8/21/2019Animal ID: 177055
This animal was found within the city limits of DSM and will be transferred to our Animal Care and Control Location- 1615 SE 14th St. Des Moines 50320 (515)-284-6905. If you are the owner of this cat, please first call our main location at (515) 473-9102 in case this cat's transfer has been delayed.
Des Moines - Central
Found: 8/20/2019Animal ID: 177057
Des Moines - Central
Found: 8/20/2019Animal ID: 177041
Des Moines - Central
Found: 8/20/2019Animal ID: 177044
Des Moines - Central
Found: 8/20/2019Animal ID: 177010
Des Moines - Central
Found: 8/20/2019Animal ID: 176986
Des Moines - Central
Found: 8/20/2019Animal ID: 177006
Des Moines - Central
Found: 8/20/2019Animal ID: 177005
Des Moines - Central
Found: 8/20/2019Animal ID: 177003
Des Moines - Central
Found: 8/20/2019Animal ID: 122297
Des Moines - South
Found: 8/20/2019ID: 12173Name: UnknownType: CatColor: Dark Brown, Tan, GrayBreed: UnknownGender: FemaleFixed: Not ApplicableAge: Young
We found this sweet girl wandering on the Southside of DSM behind Menards on SE 14th. She's very friendly and looks like she's been out on her own for awhile. No collar and is not declawed.
Des Moines - North
Found: 8/20/2019Animal ID: 176999
Des Moines - North
Found: 8/20/2019ID: 12172Name: Type: DogColor: Brown and whiteBreed: Pit BullGender: UnknownFixed: UnknownAge: Young
Found at 2nd Ave and New York.
Carlisle
Found: 8/19/2019ID: 12174Name: Type: CatColor: Black and white Breed: Pit BullGender: UnknownFixed: UnknownAge: Young
Declawed
Des Moines - Central
Found: 8/19/2019Animal ID: 176982
Des Moines - Central
Found: 8/19/2019Animal ID: 176966
Des Moines - Central
Found: 8/19/2019Animal ID: 176939
Des Moines - Central
Found: 8/19/2019Animal ID: 176971
Des Moines - Central
Found: 8/19/2019Animal ID: 176976
Des Moines - Central
Found: 8/19/2019Animal ID: 176961
Des Moines - Central
Found: 8/19/2019Animal ID: 176968
