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>='1573689600')) ORDER BY pm1.meta_value DESC, post_date DESC
Des Moines - Central
Found: 11/19/2019
Animal ID: 180895
Des Moines - Central
Found: 11/19/2019
Animal ID: 180928
Ankeny
Found: 11/19/2019
Animal ID: 180966
West Des Moines
Found: 11/19/2019
ID: 12863
Name: Unknown
Type: Dog
Color: Tan and brown
Breed: Mix
Gender: Unknown
Fixed: Unknown
Age: Adult
Found on 8800 block of Grand.
Johnston
Found: 11/19/2019
Animal ID: 180944
Alleman
Found: 11/19/2019
Animal ID: 180914
Altoona
Found: 11/19/2019
Animal ID: 180930
Altoona
Found: 11/19/2019
Animal ID: 180929
Des Moines - Central
Found: 11/18/2019
Animal ID: 180889
Des Moines - Central
Found: 11/18/2019
Animal ID: 180891
Johnston
Found: 11/18/2019
Animal ID: 180890
Des Moines - Central
Found: 11/18/2019
Animal ID: 180887
West Des Moines
Found: 11/18/2019
ID: 12856
Name: Unknown
Type: Cat
Color: Black and White Tuxedo
Breed: Domestic Short Hair
Gender: Unknown
Fixed: Unknown
Age: Adult
Found on 800 block of 28th st
Des Moines - Central
Found: 11/18/2019
ID: 12855
Name: Unknown
Type: Dog
Color: Black and white
Breed: Alaskan Husky
Gender: Male
Fixed: Unknown
Age: Young
Found running by Grandview University. Turned over to ARL. No microchip detected.
Des Moines - North
Found: 11/18/2019
Animal ID: 180865
Des Moines - North
Found: 11/18/2019
Animal ID: 180864
Norwalk
Found: 11/18/2019
Animal ID: 180861
Des Moines - Central
Found: 11/18/2019
Animal ID: 180863
Des Moines - Central
Found: 11/17/2019
Animal ID: 180875
Des Moines - Central
Found: 11/17/2019
Animal ID: 180884
Des Moines - Central
Found: 11/17/2019
Animal ID: 180877
Des Moines - Central
Found: 11/17/2019
Animal ID: 180876
Des Moines - Central
Found: 11/17/2019
Animal ID: 180868
West Des Moines
Found: 11/17/2019
ID: 12851
Name:
Type: Cat
Color: Black and White
Breed: Alaskan Husky
Gender: Unknown
Fixed: Unknown
Age: Young
Black and white tuxedo cat has been in the neighborhood for several days. Keeps coming up to our front window by the door like it wants to be let in. Runs off when you open the door. Keeps going from house to house like it is looking for home. Westwood Drive in WDM off of 50th street between EP True and Mills Civic.
Altoona
Found: 11/17/2019
Animal ID: 180853