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>='1492560000')) ORDER BY pm1.meta_value DESC, post_date DESC
Des Moines - North
Lost: 4/24/2017
ID: 5420
Name: Pantera or Tera
Type: Cat
Color: Grey calico
Breed: Calico
Gender: Female
Fixed: Neutered
Age: Senior
She was in the house around 730 pm, she got out of the screen door didn't notice till around 8pm, she has no front claws and just had mouth surgery 2 weeks ago, she's very scared
Des Moines - Central
Lost: 4/24/2017
ID: 5417
Name: Smitty
Type: Cat
Color: Black
Breed: Domestic Long Hair
Gender: Female
Fixed: Neutered
Age: Adult
Early Monday morning before work. Not wearing collar. All black with olive green eyes
West Des Moines
Lost: 4/23/2017
ID: 5412
Name: Lego
Type: Cat
Color: Black and white
Breed: Manx
Gender: Male
Fixed: Neutered
Age: Young
Clive
Lost: 4/23/2017
ID: 5407
Name: Gypsy
Type: Dog
Color: black/tan
Breed: Foxhound
Gender: Female
Fixed: Neutered
Age: Young
She got out of the gate while I was mowing. She is a lover.
Des Moines - Central
Lost: 4/23/2017
ID: 5405
Name:
Type: Dog
Color: Black
Breed: Labrador Retriever
Gender: Female
Fixed: Unknown
Age: Baby
40th and Shawnee
Des Moines - North
Lost: 4/23/2017
ID: 5400
Name: Bella
Type: Dog
Color: grey, white, brown
Breed: Labrador Retriever
Gender: Female
Fixed: Unknown
Age: Young
has no tail and mix of Australian shepherd and Husky. has some shaved areas on right legs.
Des Moines - Central
Lost: 4/23/2017
ID: 5394
Name: Patunia
Type: Dog
Color: Tan/cream
Breed: Pekingese
Gender: Female
Fixed: Neutered
Age: Adult
Last seen this morning we live between drake university and north high school she's friendly but I don't know if she would go up to anybody. We call her patunia or tuna fish and she listens to them.
Des Moines - Central
Lost: 4/23/2017
ID: 5390
Name: Marbles
Type: Cat
Color: Brown black and tan
Breed: Exotic Shorthair
Gender: Male
Fixed: Unknown
Age: Young
He was last seen on 34th st and center
Des Moines - East
Lost: 4/22/2017
ID: 5406
Name: Pandora
Type: Cat
Color: Black
Breed: Bombay
Gender: Unknown
Fixed: Not Neutered
Age: Young
Last seen in our home Saturday evening. Not sure how she could have got out, and she's never been out before, but we can't find her anywhere in the house and her food hasn't been touched. She is a very sweet and affectionate cat, with an area of thinner fur over her eye. She likes to stretch out on her back and roll around on the rug.
Des Moines - East
Lost: 4/22/2017
ID: 5398
Name: Lady/lady bird
Type: Dog
Color: White with fawn on back
Breed: American Staffordshire Terrier
Gender: Female
Fixed: Not Neutered
Age: Young
She broke callor off Leash in backyard