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' AND pm2.meta_value = 'Active' AND (pm3.meta_value IS NULL or (pm3.meta_value IS NOT NULL AND pm1.meta_value>='1529107200')) ORDER BY pm1.meta_value DESC, post_date DESC
Des Moines - West
Lost: 6/20/2018
ID: 8888
Name: Patty
Type: Dog
Color: Fawn/ brown w black mussle
Breed: Bull Terrier
Gender: Unknown
Fixed: Neutered
Age: Senior
She will be with a black dog she's friendly.
Des Moines - West
Lost: 6/20/2018
ID: 8887
Name: Chase
Type: Dog
Color: Black
Breed: Bull Terrier
Gender: Male
Fixed: Neutered
Age: Senior
He's blind in one eye and shoukd be with our other dog a brown n black nosed terrier
Des Moines - West
Lost: 6/20/2018
ID: 8886
Name: Chase
Type: Dog
Color: Black
Breed: Chesapeake Bay Retriever
Gender: Male
Fixed: Neutered
Age: Senior
He's blind in one eye and shoukd be with our other dog a brown n black nosed terrier
Des Moines - South
Lost: 6/20/2018
ID: 8885
Name: Chipper
Type: Cat
Color: Orange
Breed: Tabby
Gender: Male
Fixed: Neutered
Age: Senior
Last seen 05/25/2018 Posting a picture of what he looks like when he is sick and stops eating.. he slipped out of his collar and got out. He does look like a stray so I’m unsure if someone took him in to care from him. I’ve had him for 12 years and would really love to have him home. He has a cataract or discoloration in one eye and freckles on his nose and mouth. Please help. He is dearly missed and needs to see his vet for his thyroid problem.
Leland
Lost: 6/19/2018
ID: 8891
Name: Bailey jean
Type: Dog
Color: white black
Breed: German Shorthaired Pointer
Gender: Female
Fixed: Neutered
Age: Young
last seen in Leland,ia she is a epilepsy service dog, friendly but shy. please help
Des Moines - East
Lost: 6/19/2018
ID: 8881
Name: Nightmare
Type: Cat
Color: Black
Breed: German Shorthaired Pointer
Gender: Female
Fixed: Neutered
Age: Young
Last seen on 25th and Grandview Ave in East DSM.
Des Moines - East
Lost: 6/19/2018
ID: 8880
Name: Boots
Type: Cat
Color: Tuxedo (Black & White)
Breed: American Shorthair
Gender: Male
Fixed: Neutered
Age: Adult
It's been a little over a week since he was last seen. He is used to being outside but he's never been gone this long.
West Des Moines
Lost: 6/18/2018
ID: 8897
Name: Phantom
Type: Cat
Color: Black and white
Breed: Domestic Short Hair
Gender: Male
Fixed: Not Neutered
Age: Young
He is sensitive to light and has never attempted to leave before.
Bondurant
Lost: 6/18/2018
ID: 8879
Name: Odie
Type: Dog
Color: Blonde
Breed: Labradoodle
Gender: Male
Fixed: Neutered
Age: Senior
Last seen north of our house at 10am. Has never wondered before and is a very friendly dog. Loves people and other animals.
Des Moines - South
Lost: 6/18/2018
ID: 8868
Name:
Type: Dog
Color: White
Breed: American Staffordshire Terrier
Gender: Female
Fixed: Not Neutered
Age: Young
Missing June 9 2018 south of county line road heading towards des Moines