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>='1431907200')) ORDER BY pm1.meta_value DESC, post_date DESC
Des Moines - West
Lost: 5/23/2015
ID: 594
Name: Lilly
Type: Dog
Color: Black and White
Breed: Chihuahua Short Haired
Gender: Female
Fixed: Not Neutered
Age: Adult
ran outside when I was carrying in groceries didn't know she ran outside noticed about 30 minutes to an hour later that she was missing
Des Moines - Central
Lost: 5/21/2015
ID: 586
Name: REUNITED!!!!!!!! Valentine
Type: Cat
Color: Multi long hair
Breed: Chihuahua Short Haired
Gender: Female
Fixed: Unknown
Age: Adult
Believe she escaped out the side door of the house. She's timid so may not come when called. Please help me find her!
Des Moines - East
Lost: 5/21/2015
ID: 584
Name: Winston
Type: Dog
Color: white, black spotd
Breed: Sheep Dog
Gender: Male
Fixed: Neutered
Age: Young
On east Seneca at hope Lutheran Church in does Moines iowa
Des Moines - East
Lost: 5/21/2015
ID: 583
Name: Winston
Type: Dog
Color: white, black spotd
Breed: Sheep Dog
Gender: Male
Fixed: Neutered
Age: Young
On east Seneca at hope Lutheran Church in does Moines iowa
West Des Moines
Lost: 5/20/2015
ID: 593
Name: Peanut
Type: Cat
Color: Buff
Breed: Tiger
Gender: Male
Fixed: Neutered
Age: Young
He got out of the apartment late Wednesday night. He is an indoor cat who is front declawed only.
Norwalk
Lost: 5/20/2015
ID: 589
Name: Axl
Type: Dog
Color: Yellow
Breed: Labrador Retriever
Gender: Male
Fixed: Not Neutered
Age: Young
Des Moines - South
Lost: 5/20/2015
ID: 581
Name: Niah
Type: Dog
Color: Tricolor
Breed: German Shepherd Dog
Gender: Female
Fixed: Not Neutered
Age: Young
Stolen out of Apartment not sure where abouts are. Responds to Niyah
Des Moines - Central
Lost: 5/19/2015
ID: 582
Name:
Type: Cat
Color:
Breed: Tabby
Gender: Male
Fixed: Neutered
Age: Young
Orange tabby.. amber eyes.. near beaverdale
Des Moines - North
Lost: 5/19/2015
ID: 575
Name: Rogue
Type: Cat
Color: black brown white
Breed: Domestic Long Hair
Gender: Female
Fixed: Neutered
Age: Adult
She missing a tiny piece of her left ear. Very friendly. Comes to you when you snap your fingers.
Des Moines - East
Lost: 5/18/2015
ID: 568
Name: zeus
Type: Dog
Color: white/grey
Breed: Husky
Gender: Male
Fixed: Unknown
Age: Young
At home on east 24th just south of university