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>='1596240000')) ORDER BY pm1.meta_value DESC, post_date DESC
Des Moines - Central
Found: 8/7/2020
Animal ID: 190428
Maxwell
Found: 8/7/2020
Animal ID: 190425
Des Moines - North
Found: 8/7/2020
Animal ID: 190403
West Des Moines
Found: 8/7/2020
ID: 14633
Name:
Type: Cat
Color: Orange tabby
Breed: Domestic Short Hair
Gender: Male
Fixed: Not Neutered
Age: Adult
Grimes
Found: 8/6/2020
ID: 14634
Name:
Type: Cat
Color: Black & white
Breed: Domestic Short Hair
Gender: Unknown
Fixed: Unknown
Age: Adult
Des Moines - Central
Found: 8/6/2020
ID: 14628
Name:
Type: Dog
Color: Black and brown
Breed: Domestic Short Hair
Gender: Male
Fixed: Not Neutered
Age: Adult
Missing 3 toes on his back left foot and 1 toe on his back right foot. He is with me for the night
Des Moines - Central
Found: 8/6/2020
Animal ID: 190400
Des Moines - Central
Found: 8/6/2020
Animal ID: 190399
Des Moines - Central
Found: 8/6/2020
Animal ID: 190400
Des Moines - Central
Found: 8/6/2020
Animal ID: 190395
Des Moines - Central
Found: 8/6/2020
Animal ID: 190354
Des Moines - Central
Found: 8/6/2020
Animal ID: 190366
Des Moines - Central
Found: 8/6/2020
Animal ID: 190340
Bondurant
Found: 8/6/2020
Animal ID: 190362
Des Moines - East
Found: 8/6/2020
Animal ID: 190373
Madrid
Found: 8/6/2020
Animal ID: 190367
Des Moines - North
Found: 8/6/2020
Animal ID: 190360
Des Moines - Central
Found: 8/5/2020
Animal ID: 190347
Urbandale
Found: 8/5/2020
ID: 14624
Name:
Type: Dog
Color: Black
Breed: Labrador Retriever
Gender: Female
Fixed: Unknown
Age: Adult
Altoona
Found: 8/5/2020
Animal ID: 190338
Altoona
Found: 8/5/2020
ID: 14619
Name:
Type: Dog
Color:
Breed: Mix
Gender: Unknown
Fixed: Unknown
Age: Young
Found in Altoona. Please message with description if this may be your dog
Des Moines - Central
Found: 8/5/2020
Animal ID: 190332
Des Moines - Central
Found: 8/4/2020
Animal ID: 190295
Des Moines - Central
Found: 8/4/2020
Animal ID: 190296
Des Moines - Central
Found: 8/4/2020
Animal ID: 190297