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>='1610236800')) ORDER BY pm1.meta_value DESC, post_date DESC
Des Moines - Central
Found: 1/15/2021Animal ID: 196423
Ankeny
Found: 1/15/2021Animal ID: 195715
Des Moines - Central
Found: 1/15/2021Animal ID: 196416
Des Moines - East
Found: 1/15/2021Animal ID: 196407
Des Moines - Central
Found: 1/14/2021Animal ID: 196399
Des Moines - Central
Found: 1/14/2021Animal ID: 196396
Des Moines - Central
Found: 1/14/2021ID: 15885Name: Type: DogColor: Brindle brown Breed: Belgian Shepherd MalinoisGender: MaleFixed: NeuteredAge: Adult
He was running in my friends yard at 36th and Seneca
Des Moines - Central
Found: 1/14/2021ID: 15884Name: Type: DogColor: Brown brindle Breed: Shepherd BelgianGender: MaleFixed: NeuteredAge: Adult
36th and Seneca’ in beaverdale
Des Moines - North
Found: 1/14/2021Animal ID: 196388
Ankeny
Found: 1/14/2021Animal ID: 196390
Pleasant Hill
Found: 1/14/2021Animal ID: 196387
Des Moines - East
Found: 1/14/2021Animal ID: 196383
Des Moines - Central
Found: 1/13/2021Animal ID: 194596
Des Moines - Central
Found: 1/13/2021Animal ID: 196381
Des Moines - East
Found: 1/13/2021ID: 15880Name: Type: CatColor: GreyBreed: UnknownGender: FemaleFixed: Not NeuteredAge: Young
Des Moines - West
Found: 1/13/2021Animal ID: 196354
Des Moines - West
Found: 1/13/2021Animal ID: 196353
Ankeny
Found: 1/13/2021Animal ID: 196351
Des Moines - East
Found: 1/13/2021Animal ID: 156289
Des Moines - North
Found: 1/13/2021Animal ID: 196346
Des Moines - South
Found: 1/13/2021Animal ID: 196345
West Des Moines
Found: 1/13/2021ID: 15873Name: Type: DogColor: Brown with some black and whiteBreed: Pit Bull TerrierGender: UnknownFixed: UnknownAge: Adult
Des Moines - West
Found: 1/13/2021ID: 15872Name: BuddyType: DogColor: TanBreed: MixGender: MaleFixed: NeuteredAge: Senior
Grand ave heading towards 63rd Street very skidish and anxious. Will run away if approached please call if spotted
Des Moines - North
Found: 1/12/2021ID: 15877Name: Type: DogColor: Black with brown and tanBreed: ChihuahuaGender: FemaleFixed: UnknownAge: Adult
She was caught at around 10:15. She was with another dog that I was unable to catch. It seemed like a Boston terrier type dog, but I could of not seen right as well.
Pleasant Hill
Found: 1/12/2021ID: 15875Name: SaydeType: DogColor: Brown/gray/redBreed: ChihuahuaGender: UnknownFixed: NeuteredAge: Adult
Pleasant Hill, IA
