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>='1623024000')) ORDER BY pm1.meta_value DESC, post_date DESC
Waterloo
Found: 6/13/2021Animal ID: 10923
Found on W Parker 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)
Waterloo
Found: 6/13/2021Animal ID: 10921
Found on 1200 W 3rd 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: 6/13/2021Animal ID: 79390
Des Moines - Central
Found: 6/12/2021Animal ID: 188238
Des Moines - Central
Found: 6/12/2021Animal ID: 202137
Des Moines - South
Found: 6/12/2021ID: 16938Name: Type: DogColor: Breed: Gender: MaleFixed: UnknownAge: Adult
Found on the southside by pleasant view drive.
Des Moines - South
Found: 6/12/2021ID: 16937Name: Type: DogColor: Breed: Labrador RetrieverGender: MaleFixed: UnknownAge: Adult
Found on the southside by pleasant view drive.
Waterloo
Found: 6/12/2021Animal ID: 10917
Found on 1600blk Williston 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)
Ankeny
Found: 6/12/2021Animal ID: 202130
West Des Moines
Found: 6/12/2021ID: 16930Name: ElsaType: DogColor: BROWNBreed: HoundGender: FemaleFixed: NeuteredAge: Adult
604 33rd St, 50265
Des Moines - East
Found: 6/12/2021Animal ID: 202122
Des Moines - West
Found: 6/12/2021Animal ID: 202106
Waterloo
Found: 6/12/2021Animal ID: 10901
Found on 200 Blk on Franklon 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 - Central
Found: 6/11/2021Animal ID: 202096
Des Moines - Central
Found: 6/11/2021Animal ID: 202120
Clive
Found: 6/11/2021ID: 16931Name: Type: CatColor: tortieBreed: Domestic Short HairGender: FemaleFixed: UnknownAge: Adult
12834 Walnut st,
Waterloo
Found: 6/11/2021Animal ID: 10899
Found on 1900 blk Drew 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)
Ankeny
Found: 6/11/2021Animal ID: 202094
Found with 202087, 202088, 202089, 202090, 202091, 202092, and 202093
Ankeny
Found: 6/11/2021Animal ID: 202093
Foudn with 202087, 202088, 202089, 202090, 202091, 202092, and 202094
Ankeny
Found: 6/11/2021Animal ID: 202092
Found with 202087, 202088, 202089, 202090, 202091, 202093, and 202094
Ankeny
Found: 6/11/2021Animal ID: 202091
Found with 202087, 202088, 202089, 202090, 202092, 202093, and 202094
Ankeny
Found: 6/11/2021Animal ID: 202090
Foudn with 202087, 202088, 202089, 202091, 202092, 202093, and 202094
Ankeny
Found: 6/11/2021Animal ID: 202089
Found with 202087, 202088, 202090, 202091, 202092, 202093, and 202094
Ankeny
Found: 6/11/2021Animal ID: 202088
Found with 202087, 202089, 202090, 202091, 202092, 202093, 202094
Ankeny
Found: 6/11/2021Animal ID: 202087
found with 202088, 202089, 202090, 202091, 202092, 202093, and 202094
