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 = 'found' AND pm2.meta_value = 'Active' AND (pm3.meta_value IS NULL or (pm3.meta_value IS NOT NULL AND pm1.meta_value>='1555632000')) ORDER BY pm1.meta_value DESC, post_date DESC
Des Moines - Central
Found: 4/22/2019
Animal ID: 171083
Des Moines - Central
Found: 4/21/2019
ID: 11107
Name: Unknown
Type: Dog
Color: Black with white paws, neck, stomach
Breed: Mix
Gender: Female
Fixed: Unknown
Age: Baby
Please call (515) 333-3923
Des Moines - Central
Found: 4/21/2019
Animal ID: 171096
Ankeny
Found: 4/20/2019
ID: 11131
Name: Poopsie
Type: Dog
Color: White
Breed: Bichon Frise
Gender: Female
Fixed: Neutered
Age: Adult
Urbandale
Found: 4/20/2019
ID: 11089
Name:
Type: Rabbit
Color: Black and White
Breed: Holland Lop
Gender: Unknown
Fixed: Unknown
Age: Young
Urbandale area.
Urbandale
Found: 4/20/2019
ID: 11088
Name:
Type: Dog
Color: Black
Breed: Schnauzer
Gender: Female
Fixed: Unknown
Age: Adult
Urbandale around Colby Park.
Des Moines - Central
Found: 4/20/2019
Animal ID: 171081
Altoona
Found: 4/20/2019
Animal ID: 171079
Exline
Found: 4/20/2019
Animal ID: 171076
Des Moines - Central
Found: 4/20/2019
Animal ID: 171078
Sheldahl
Found: 4/20/2019
Animal ID: 171070
Des Moines - West
Found: 4/20/2019
ID: 11082
Name:
Type: Dog
Color:
Breed: Chihuahua Short Haired
Gender: Male
Fixed: Unknown
Age: Baby
Found on High St in Des Moines. Microchip but not activated
Des Moines - South
Found: 4/19/2019
ID: 11090
Name:
Type: Cat
Color: Orange stripped
Breed: Tiger
Gender: Male
Fixed: Unknown
Age: Adult
SW Porter Avenue. Orange Stripped cat. Very friendly I think the cat is male.
Des Moines - North
Found: 4/19/2019
Animal ID: 170919
Pleasant Hill
Found: 4/19/2019
Animal ID: 171060
Pleasant Hill
Found: 4/19/2019
Animal ID: 171059
Booneville
Found: 4/19/2019
ID: 11078
Name: Dak
Type: Dog
Color: Black and White
Breed: GoldenDoodle
Gender: Male
Fixed: Neutered
Age: Young
Around 6pm
Des Moines - South
Found: 4/19/2019
ID: 11077
Name: Unknown
Type: Small or Furry
Color: White
Breed: Mouse
Gender: Unknown
Fixed: Unknown
Age: Young
Des Moines - Central
Found: 4/19/2019
Animal ID: 171029
Des Moines - Central
Found: 4/19/2019
Animal ID: 171031
Des Moines - Central
Found: 4/19/2019
Animal ID: 171028
Altoona
Found: 4/19/2019
Animal ID: 170676
Mitchellville
Found: 4/19/2019
Animal ID: 171009
Altoona
Found: 4/19/2019
Animal ID: 171003
Des Moines - Central
Found: 4/19/2019
Animal ID: 170998