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 = 'lost' or pm.meta_value = 'found' or pm.meta_value = 'Spotted') 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
Ankeny
Lost: 10/9/2022
ID: 15170
Name: Charlie
Type: Cat
Color: White with black spots/tail
Breed: American Shorthair
Gender: Male
Fixed: Neutered
Age: Senior
At home address. Comes to “Ki Ki”. Friendly
Des Moines - Central
Found: 1/15/2021
Animal ID: 196423
Ankeny
Found: 1/15/2021
Animal ID: 195715
Des Moines - Central
Found: 1/15/2021
Animal ID: 196416
Des Moines - East
Found: 1/15/2021
Animal ID: 196407
Des Moines - Central
Found: 1/14/2021
Animal ID: 196399
Des Moines - Central
Found: 1/14/2021
Animal ID: 196396
Des Moines - Central
Found: 1/14/2021
ID: 15885
Name:
Type: Dog
Color: Brindle brown
Breed: Belgian Shepherd Malinois
Gender: Male
Fixed: Neutered
Age: Adult
He was running in my friends yard at 36th and Seneca
Des Moines - Central
Found: 1/14/2021
ID: 15884
Name:
Type: Dog
Color: Brown brindle
Breed: Shepherd Belgian
Gender: Male
Fixed: Neutered
Age: Adult
36th and Seneca’ in beaverdale
Des Moines - North
Found: 1/14/2021
Animal ID: 196388
Ankeny
Found: 1/14/2021
Animal ID: 196390
Pleasant Hill
Found: 1/14/2021
Animal ID: 196387
Des Moines - East
Found: 1/14/2021
Animal ID: 196383
Ankeny
Spotted: 1/14/2021
ID: 15881
Name: Unknowm
Type: Dog
Color:
Breed: Beagle
Gender: Unknown
Fixed: Unknown
Age: Young
Outside ankeny Sam's club and Fleet Farm.
Norwalk
Lost: 1/13/2021
ID: 15889
Name: Knight
Type: Cat
Color:
Breed: Unknown
Gender: Male
Fixed: Not Neutered
Age: Young
I was playing on my phone and he jumped out my window. He often goes outside and always comes back inside. After I got home from school the next day and he wasn’t there I got worried and looked for him. I went out again the next day still not being able to find him. He responds to his name, snapping, and kitty. Also if you pat the ground he usually comes.
Des Moines - Central
Found: 1/13/2021
Animal ID: 194596
Des Moines - Central
Found: 1/13/2021
Animal ID: 196381
Des Moines - East
Found: 1/13/2021
ID: 15880
Name:
Type: Cat
Color: Grey
Breed: Unknown
Gender: Female
Fixed: Not Neutered
Age: Young
Des Moines - East
Lost: 1/13/2021
ID: 15878
Name: Bugsy
Type: Dog
Color: Black with brown only white on chest
Breed: Rat Terrier
Gender: Male
Fixed: Not Neutered
Age: Adult
10:30 AM he is very friendly please call 515-587-0782
Des Moines - West
Found: 1/13/2021
Animal ID: 196354
Des Moines - West
Found: 1/13/2021
Animal ID: 196353
Ankeny
Found: 1/13/2021
Animal ID: 196351
Des Moines - East
Found: 1/13/2021
Animal ID: 156289
Des Moines - North
Found: 1/13/2021
Animal ID: 196346
Des Moines - South
Found: 1/13/2021
Animal ID: 196345