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>='1510704000')) ORDER BY pm1.meta_value DESC, post_date DESC
Randolph
Lost: 9/1/2027
ID: 7351
Name: Gray
Type: Cat
Color: Gray
Breed: Russian Blue
Gender: Male
Fixed: Neutered
Age: Adult
Des Moines - East
Lost: 11/21/2017
ID: 7438
Name: Trig
Type: Dog
Color: Tan
Breed: Golden Retriever
Gender: Male
Fixed: Not Neutered
Age: Young
On E 46th by the Des Moines complex ball fields
Des Moines - South
Lost: 11/20/2017
ID: 7433
Name: Dewey
Type: Dog
Color: White/Black
Breed: Blue Heeler
Gender: Male
Fixed: Not Neutered
Age: Adult
Des Moines - North
Lost: 11/20/2017
ID: 7431
Name: Kenaey
Type: Dog
Color: Brown with black
Breed: German Shepherd Dog
Gender: Unknown
Fixed: Neutered
Age: Adult
On 10th st des moines
Des Moines - North
Lost: 11/19/2017
ID: 7436
Name: Roxy
Type: Dog
Color: White with brown and black spots
Breed: Chihuahua Long Haired
Gender: Female
Fixed: Not Applicable
Age: Young
Last seen around 3pm at home. She is friendly. She is so ugly she is cute!
Altoona
Lost: 11/19/2017
ID: 7428
Name: RIZZIE
Type: Dog
Color: Fawn
Breed: Boxer
Gender: Female
Fixed: Not Neutered
Age: Young
809 greenbreeze circle Altoona iowa 5153262782
Altoona
Lost: 11/19/2017
ID: 7427
Name: RIZZIE
Type: Dog
Color: Fawn
Breed: Boxer
Gender: Female
Fixed: Not Neutered
Age: Young
809 greenbreeze circle Altoona iowa 5163262782
Altoona
Lost: 11/19/2017
ID: 7425
Name:
Type: Dog
Color: Fawn
Breed: Boxer
Gender: Female
Fixed: Not Neutered
Age: Young
809 greenbreeze circle Altoona iowa
Des Moines - South
Lost: 11/18/2017
ID: 7434
Name: Jack Daniel’s Whitlow
Type: Dog
Color: Brown,Black,Tan
Breed: Staffordshire Bull Terrier
Gender: Male
Fixed: Not Neutered
Age: Senior
Saturday at 6pm he was let out of the back yard .we searched every where but could not find him .miss him so much
Des Moines - South
Lost: 11/18/2017
ID: 7419
Name: Sampson
Type: Dog
Color: Brown and white
Breed: English Bulldog
Gender: Male
Fixed: Not Neutered
Age: Adult
Around 1pm on sw 12th and Hyde drive