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>='1637539200')) ORDER BY pm1.meta_value DESC, post_date DESC
Des Moines - East
Found: 11/28/2021Animal ID: 209744
Des Moines - Central
Found: 11/28/2021Animal ID: 209740
Des Moines - Central
Found: 11/28/2021Animal ID: 209739
Des Moines - Central
Found: 11/28/2021Animal ID: 209743
Des Moines - Central
Found: 11/28/2021Animal ID: 209742
found with 209741
Des Moines - Central
Found: 11/28/2021Animal ID: 209741
Found with 209742
Des Moines - Central
Found: 11/28/2021ID: 18325Name: Type: CatColor: GreyBreed: Russian BlueGender: FemaleFixed: UnknownAge: Young
She has been showing up daily, for the past week and a half hungry and trying to get into my apt building.
Dubuque
Found: 11/27/2021ID: 18324Name: Type: CatColor: White and grayBreed: UnknownGender: MaleFixed: UnknownAge: Adult
Found in Key West area. Will take him to the Humane Society in the morning.
Des Moines - Central
Found: 11/27/2021Animal ID: 209737
Waterloo
Found: 11/27/2021Animal ID: 12963
Found on 100blk Sunset Rd. 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: 11/27/2021Animal ID: 12965
Found on 500blk Bratnober St. 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 - North
Found: 11/27/2021Animal ID: 209727
Found with AID 209726
Des Moines - North
Found: 11/27/2021Animal ID: 209726
Found with AID 209727
Des Moines - North
Found: 11/27/2021Animal ID: 209733
Blockton
Found: 11/27/2021Animal ID: 209735
Des Moines - Central
Found: 11/27/2021Animal ID: 209731
Des Moines - Central
Found: 11/27/2021Animal ID: 209730
Waterloo
Found: 11/27/2021Animal ID: 12962
Found on 1900blk Clifton Ave. 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 - Central
Found: 11/27/2021ID: 18319Name: Type: DogColor: BrownBreed: Chihuahua Short HairedGender: MaleFixed: UnknownAge: Adult
Found! Please help find his home!
De Soto
Found: 11/26/2021Animal ID: 209738
Carlisle
Found: 11/26/2021Animal ID: 209736
Perry
Found: 11/26/2021Animal ID: 209702
Waterloo
Found: 11/26/2021Animal ID: 12960
Found on 5800blk A B Ave. 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 - West
Found: 11/26/2021Animal ID: 209695
Des Moines - North
Found: 11/26/2021Animal ID: 209685
