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 = 'lost' or pm.meta_value = 'found' or pm.meta_value = 'Spotted') AND pm2.meta_value = 'Active' AND (pm3.meta_value IS NULL or (pm3.meta_value IS NOT NULL AND pm1.meta_value>='1568505600')) ORDER BY pm1.meta_value DESC, post_date DESC
Des Moines - North
Lost: 9/20/2019
ID: 12397
Name: Hugo
Type: Dog
Color: Brindle
Breed: Mastiff English
Gender: Male
Fixed: Neutered
Age: Adult
Arthur Ave, Des Moines
Des Moines - North
Lost: 9/20/2019
ID: 12396
Name: Hugo
Type: Dog
Color: Brindle
Breed: Mastiff English
Gender: Male
Fixed: Neutered
Age: Adult
Arthur Ave Des Moines
Pleasant Hill
Lost: 9/20/2019
ID: 12394
Name: Coco
Type: Dog
Color: Brown
Breed: Siberian Husky
Gender: Male
Fixed: Not Neutered
Age: Young
Pleasant Hill
Found: 9/20/2019
Animal ID: 178453
West Des Moines
Found: 9/20/2019
ID: 12393
Name:
Type: Cat
Color: Grey and White
Breed: Domestic Short Hair
Gender: Male
Fixed: Not Neutered
Age: Adult
6500 Vista Dr
Des Moines - South
Lost: 9/20/2019
ID: 12392
Name: Syn
Type: Dog
Color: Female
Breed: Domestic Short Hair
Gender: Male
Fixed: Unknown
Age: Young
Last seen in the area of SE5th and McKinley
Des Moines - North
Found: 9/20/2019
Animal ID: 178423
Des Moines - Central
Found: 9/20/2019
Animal ID: 178416
Ankeny
Found: 9/20/2019
Animal ID: 178414
Des Moines - Central
Found: 9/20/2019
Animal ID: 178412
McIntire
Found: 9/19/2019
ID: 12395
Name:
Type: Dog
Color: Black/white
Breed: Border Collie
Gender: Male
Fixed: Neutered
Age: Adult
Found at Taopi MN
Des Moines - Central
Found: 9/19/2019
Animal ID: 169347
Des Moines - Central
Found: 9/19/2019
Animal ID: 178405
Des Moines - Central
Found: 9/19/2019
ID:
Name: All-PetsHospital-
Type: Dog
Color:
Breed: Border Collie
Gender:
Fixed:
Age:
Mostly brown with some white and black.
Des Moines - Central
Found: 9/19/2019
Animal ID: 178408
Des Moines - Central
Found: 9/19/2019
Animal ID: 178407
Ankeny
Found: 9/19/2019
ID: 12390
Name:
Type: Cat
Color:
Breed: Domestic Medium Hair
Gender: Female
Fixed: Unknown
Age: Adult
Norwalk
Lost: 9/19/2019
ID: 12389
Name: Thir
Type: Dog
Color: Black.. getting grey
Breed: Shih Tzu
Gender: Male
Fixed: Neutered
Age: Senior
About 9:30 on
West Des Moines
Found: 9/19/2019
ID: 12388
Name:
Type: Cat
Color: Brown Tabby
Breed: Domestic Short Hair
Gender: Female
Fixed: Unknown
Age: Adult
Found on 200 block of S 79th St.
Des Moines - East
Lost: 9/19/2019
ID: 12387
Name: Sky
Type: Bird
Color: Blue/grey
Breed: Quaker Parakeet
Gender: Unknown
Fixed: Unknown
Age: Young
Last seen around E12th st. Sky has a silver collar on her right leg
Des Moines - Central
Found: 9/19/2019
Animal ID: 178401
Clive
Found: 9/19/2019
ID: 12386
Name: Unknown
Type: Dog
Color: black, tan, and white
Breed: Akita
Gender: Female
Fixed: Unknown
Age: Young
Found roaming an apartment complex Contact Bree - (515) 802-0642
Des Moines - Central
Found: 9/19/2019
Animal ID: 178327
Des Moines - Central
Found: 9/19/2019
Animal ID: 178362
Des Moines - Central
Found: 9/19/2019
Animal ID: 178365