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>='1600473600')) ORDER BY pm1.meta_value DESC, post_date DESC
Des Moines - North
Found: 9/24/2020
Animal ID: 192396
Grinnell
Found: 9/24/2020
Animal ID: 192218
Des Moines - North
Found: 9/24/2020
Animal ID: 192369
Des Moines - Central
Found: 9/23/2020
Animal ID: 192346
Des Moines - Central
Found: 9/23/2020
Animal ID: 192345
Des Moines - Central
Found: 9/23/2020
Animal ID: 192333
West Des Moines
Found: 9/23/2020
ID: 15028
Name:
Type: Dog
Color: Blue/grey and white
Breed: Terrier
Gender: Male
Fixed: Not Neutered
Age: Adult
5th street and Vine
Des Moines - North
Found: 9/23/2020
Animal ID: 192152
Des Moines - North
Found: 9/23/2020
Animal ID: 192151
West Des Moines
Found: 9/23/2020
ID: 15025
Name:
Type: Cat
Color: White and Brown
Breed: Domestic Short Hair
Gender: Unknown
Fixed: Unknown
Age: Adult
Des Moines - Central
Found: 9/23/2020
Animal ID: 192318
Des Moines - Central
Found: 9/23/2020
Animal ID: 192311
This animal will be transferred to Des Moines Animal Services located at 1615 SE 14th Street. Tel: 515-284-6905 Hours: 9AM-5PM (Monday through Saturday)
Des Moines - Central
Found: 9/23/2020
Animal ID: 192312
Des Moines - North
Found: 9/23/2020
Animal ID: 192314
Urbandale
Found: 9/23/2020
ID: 15021
Name:
Type: Cat
Color: Black
Breed: Domestic Short Hair
Gender: Unknown
Fixed: Unknown
Age: Adult
Des Moines - Central
Found: 9/22/2020
Animal ID: 192319
Johnston
Found: 9/22/2020
ID: 15020
Name:
Type: Cat
Color: Orange and white
Breed: Domestic Short Hair
Gender: Unknown
Fixed: Unknown
Age: Adult
He comes right up to the door and meows but won’t let us get too close. He came back this morning. Seems like he needs help.
Johnston
Found: 9/22/2020
ID: 15019
Name:
Type: Cat
Color: orange and white
Breed: American Shorthair
Gender: Unknown
Fixed: Unknown
Age: Adult
First saw him the evening of the 22. He comes up to the door and meows but is timid and doesn’t want us to get too close. Came back this morning still meowing at the door.
Williamson
Found: 9/22/2020
ID: 15016
Name:
Type: Dog
Color: Brindle
Breed: Pit Bull Terrier
Gender: Unknown
Fixed: Unknown
Age: Adult
This sweet girl showed up at our place mid- morning.
Williamson
Found: 9/22/2020
ID: 15015
Name:
Type: Dog
Color:
Breed: Pit Bull Terrier
Gender: Unknown
Fixed: Unknown
Age: Adult
This sweet girl showed up at our place mid- morning.
Ankeny
Found: 9/22/2020
Animal ID: 192269
Ankeny
Found: 9/22/2020
Animal ID: 192257
Des Moines - South
Found: 9/22/2020
Animal ID: 183854
Des Moines - South
Found: 9/22/2020
Animal ID: 183854
Des Moines - Central
Found: 9/21/2020
Animal ID: 192256