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>='1595980800')) ORDER BY pm1.meta_value DESC, post_date DESC
Des Moines - Central
Found: 8/4/2020
Animal ID: 190278
found with 190281
Des Moines - North
Found: 8/4/2020
Animal ID: 190281
found with 190278
Des Moines - Central
Found: 8/3/2020
Animal ID: 190279
Des Moines - Central
Found: 8/3/2020
Animal ID: 190282
Ankeny
Lost: 8/3/2020
ID: 14612
Name: Lily
Type: Cat
Color: Calico
Breed:
Gender: Female
Fixed: Unknown
Age: Senior
Last seen in Ankeny between Magazine and Trilein Dr. Very friendly, does not have a collar on. She is a long haired cat, 2 back paws are white.
Altoona
Lost: 8/3/2020
ID: 14610
Name: cali
Type: Cat
Color: White and grey
Breed: Ragdoll
Gender: Female
Fixed: Neutered
Age: Adult
Last see in Altoona near Pinewood Ct SW in Venbury neighborhood.
Ankeny
Lost: 8/3/2020
ID: 14609
Name: Lily
Type: Cat
Color: Calico
Breed: Ragdoll
Gender: Unknown
Fixed: Unknown
Age: Senior
Last seen in Ankeny between Magazine and Trilein Dr.
West Des Moines
Lost: 8/3/2020
ID: 14608
Name: Lucy
Type: Dog
Color: White and red/brown
Breed: Dachshund-Miniature
Gender: Female
Fixed: Neutered
Age: Young
Des Moines - West
Lost: 8/3/2020
ID: 14607
Name: Lucy
Type: Dog
Color: Red/Orange and White
Breed: Dachshund-Miniature
Gender: Female
Fixed: Neutered
Age: Young
She was last seen near Aspen Dr and 50th St in WDM, IA
Polk City
Found: 8/3/2020
Animal ID: 190277
Des Moines - Central
Found: 8/3/2020
Animal ID: 190269
Des Moines - Central
Found: 8/3/2020
Animal ID: 190270
Des Moines - Central
Found: 8/3/2020
Animal ID: 190272
Altoona
Found: 8/3/2020
Animal ID: 190268
came in with 190267
Altoona
Found: 8/3/2020
Animal ID: 190267
came in with 190268
West Des Moines
Found: 8/3/2020
ID: 14603
Name:
Type: Cat
Color: Grey
Breed: Domestic Short Hair
Gender: Unknown
Fixed: Unknown
Age: Adult
Des Moines - Central
Found: 8/3/2020
Animal ID: 190256
Windsor Heights
Lost: 8/2/2020
ID: 14613
Name: Mona
Type: Cat
Color: Gray
Breed: Tabby
Gender: Female
Fixed: Neutered
Age: Adult
Last seen on 63rd St in Windsor Heights. She has a very soft meow.
Des Moines - Central
Found: 8/2/2020
Animal ID: 190263
Des Moines - Central
Found: 8/2/2020
Animal ID: 207
Des Moines - Central
Found: 8/2/2020
Animal ID: 190262
Des Moines - Central
Found: 8/2/2020
Animal ID: 190261
Des Moines - Central
Found: 8/2/2020
Animal ID: 190260
Ankeny
Lost: 8/2/2020
ID: 14604
Name: Milkyway
Type: Cat
Color: Orange and white
Breed: Tabby
Gender: Male
Fixed: Neutered
Age: Adult
Front declawed Long hair
West Des Moines
Found: 8/2/2020
ID: 14599
Name:
Type: Cat
Color: Calico
Breed: Calico
Gender: Unknown
Fixed: Unknown
Age: Adult
800 block & 15th street. Has a bob tail.