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>='1632009600')) ORDER BY pm1.meta_value DESC, post_date DESC
Des Moines - North
Found: 9/24/2021ID: 17791Name: Type: BirdColor: Yellow, green, black, white Breed: ParakeetGender: UnknownFixed: UnknownAge: Baby
Seen on 52nd and Urbandale Ave. Very tame. It let me get close enough to touch it but flew into a tree before I could get it.
Des Moines - Central
Found: 9/24/2021Animal ID: 206534
Des Moines - East
Found: 9/24/2021Animal ID: 206520
Lamoni
Found: 9/24/2021Animal ID: 206507
found with 206506
Lamoni
Found: 9/24/2021Animal ID: 206506
found with 206507
Waterloo
Found: 9/24/2021Animal ID: 12258
Found on HWY 218 and Hawthorne. To reclaim your pet, please contact Cedar Bend Humane Society Intake Center at 319-232-6887 between 9 AM and 5 PM(closed over 12-1PM lunch hour)
Waterloo
Found: 9/24/2021Animal ID: 12257
Found on HWY 218 and Hawthorne. To reclaim your pet, please contact Cedar Bend Humane Society Intake Center at 319-232-6887 between 9 AM and 5 PM(closed over 12-1PM lunch hour)
Des Moines - East
Found: 9/24/2021Animal ID: 206513
Des Moines - North
Found: 9/24/2021Animal ID: 206504
Found on NW 35th Street
Des Moines - North
Found: 9/24/2021Animal ID: 206499
Des Moines - Central
Found: 9/24/2021Animal ID: 206502
Found on 24th & University
Des Moines - Central
Found: 9/24/2021Animal ID: 206501
Des Moines - South
Found: 9/24/2021ID: 17788Name: Type: DogColor: Tan/redBreed: Pit BullGender: FemaleFixed: Not NeuteredAge: Baby
Des Moines - Central
Found: 9/24/2021Animal ID: 205887
Des Moines - East
Found: 9/24/2021Animal ID: 206498
Front Declawed, Neutered - Found on E Douglas and E 56th (right on the border of Altoona & Des Moines)
Des Moines - North
Found: 9/24/2021Animal ID: 206478
Des Moines - East
Found: 9/24/2021Animal ID: 206488
Female - Front Declawed - Found on SE 8th Street
Des Moines - North
Found: 9/24/2021Animal ID: 206477
Des Moines - Central
Found: 9/24/2021Animal ID: 206481
Des Moines - East
Found: 9/24/2021Animal ID: 206486
Found on S. Union Street
Des Moines - East
Found: 9/24/2021Animal ID: 169446
Denver
Found: 9/24/2021Animal ID: 12252
Found on Killdeer Avenue. To reclaim your pet, please contact Cedar Bend Humane Society Intake Center at 319-232-6887 between 9 AM and 5 PM(closed over 12-1PM lunch hour)
Des Moines - East
Found: 9/24/2021Animal ID: 206458
Female - Found on Walnut Street
West Des Moines
Found: 9/24/2021ID: 17781Name: Type: DogColor: White with brown earsBreed: Pit BullGender: UnknownFixed: UnknownAge: Adult
Des Moines - East
Found: 9/23/2021Animal ID: 206495
Found on Leland Ave
