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>='1634860800')) ORDER BY pm1.meta_value DESC, post_date DESC
Johnston
Found: 10/27/2021Animal ID: 208142
Waterloo
Found: 10/27/2021Animal ID: 12676
Found on 1400blk Forest 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)
Altoona
Found: 10/27/2021Animal ID: 208138
Des Moines - East
Found: 10/27/2021Animal ID: 208135
Des Moines - Central
Found: 10/27/2021Animal ID: 208124
Urbandale
Found: 10/27/2021ID: 18073Name: HossType: DogColor: brownBreed: German Shepherd DogGender: MaleFixed: NeuteredAge: Adult
4514 83rd Street, Urbandale, IA, USA, Polk County, 50322
Des Moines - Central
Found: 10/27/2021Animal ID: 194952
Ankeny
Found: 10/27/2021Animal ID: 208109
Des Moines - North
Found: 10/27/2021Animal ID: 208106
Found with 208104 and 208105
Des Moines - North
Found: 10/27/2021Animal ID: 208105
Found with 208104 and 208106
Des Moines - North
Found: 10/27/2021Animal ID: 208104
Found with 208105 and 208106
Des Moines - South
Found: 10/27/2021Animal ID: 208102
Des Moines - Central
Found: 10/27/2021Animal ID: 208103
Waterloo
Found: 10/27/2021Animal ID: 12664
Found on 600 Blk Dawson 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 - East
Found: 10/26/2021Animal ID: 208123
Found on SE 14th Street Menards Parking Lot
Des Moines - Central
Found: 10/26/2021Animal ID: 208118
Found on Hubbell Ave - Female
Des Moines - Central
Found: 10/26/2021ID: 18071Name: Type: DogColor: Breed: Australian Cattle DogGender: UnknownFixed: UnknownAge: Baby
Des Moines - Central
Found: 10/26/2021ID: 18070Name: Type: DogColor: Breed: Australian Cattle DogGender: MaleFixed: UnknownAge: Baby
Des Moines - South
Found: 10/26/2021Animal ID: 208112
Found on SE 5th Street
Des Moines - South
Found: 10/26/2021Animal ID: 208115
Found on SE 5th Street
Des Moines - East
Found: 10/26/2021Animal ID: 175274
Found on E 14th Street
Pleasant Hill
Found: 10/26/2021ID: 18067Name: Type: CatColor: Breed: Dilute CalicoGender: MaleFixed: Not NeuteredAge: Young
Elberon
Found: 10/26/2021ID: 18065Name: UnknownType: DogColor: Tri colorBreed: Australian Cattle DogGender: MaleFixed: UnknownAge: Young
Des Moines - East
Found: 10/26/2021Animal ID: 208096
Des Moines - East
Found: 10/26/2021Animal ID: 208096
