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>='1523750400')) ORDER BY pm1.meta_value DESC, post_date DESC
West Des Moines
Found: 4/21/2018
ID: 8344
Name:
Type: Dog
Color: Yellow
Breed: Labrador Retriever
Gender: Male
Fixed: Neutered
Age: Adult
7th and Elm
Bondurant
Found: 4/21/2018
Animal ID: 158024
Mitchellville
Found: 4/21/2018
Animal ID: 158021
Puppy
Des Moines - East
Found: 4/20/2018
Animal ID: 158007
Des Moines - East
Found: 4/20/2018
Animal ID: 158008
Des Moines - Central
Found: 4/20/2018
Animal ID: 158009
Des Moines - East
Found: 4/20/2018
ID: 8340
Name:
Type: Dog
Color: Deep Reddish Brown
Breed: Unknown
Gender: Female
Fixed: Unknown
Age: Adult
Des Moines - East
Found: 4/20/2018
Animal ID: 158002
Des Moines - South
Found: 4/20/2018
ID: 8337
Name:
Type: Dog
Color: Tan
Breed: Pug
Gender: Female
Fixed: Unknown
Age: Adult
In heat or has recently had puppies
Des Moines - East
Found: 4/19/2018
Animal ID: 157992