SELECT distinct b.*, a.sortID
FROM `busi_in_cat_uf` a LEFT JOIN v_BusiUser b
on a.busi_id = b.busi_id
where a.cat_id = '39' and b.Exp_Date >= '2019-04-19' and (b.admin_appr = 'T' or b.submit_date > '2019-04-16')
union all
SELECT distinct b.*, a.sortID
FROM `busi_in_cat` a LEFT JOIN v_BusiUser b
on a.busi_id = b.busi_id
where a.cat_id = '39' and (b.admin_appr = 'T' or b.submit_date > '2019-04-16') ORDER BY sortID DESC , member DESC, busi_name
Bay Area Equestrian Network - Show business listings
Help update BAEN's Directory and earn FREE Photo Ads.
If you find a listing that needs flagging, let us know. Examples: wrong category, broken web links, duplicate, business no longer exists, etc.. Email bayequest@gmail.com and include the ID number of the listing along with your comments. We'll say thanks for your help with a FREE photo ad (maximum value $22).
Custom Covers by Cheryl Horse, Mule & Dog Treats, along with stall drapes, tack trunks, embroidery, show accessories and more Cheryl Chandler 866-523-7577 Fax: 650-726-9141 11830 San Mateo Rd. Half Moon Bay, CA 94019 Bus. ID: 2444 Send E-mailView Map
Nicker Bait Cookies For Horses We take pride in offering unique cookies, treats and gift items using premium ingredients your horse will flip over. We use San Francisco's own "Giusto's" ground flax, oat flour and barley (human grade) and Organic carrots, sweet potato, and banana. We top each cookie off with a special yummy treat! 510-733- 2126 castro valley, CA 94552 Bus. ID: 5859 Send E-mailView Map
Whole Equine Healthy Horses, Naturally! The Bay Area's online resource for natural care products for horses from supplements and first aid products to premier brushes and hoof boots. Montara, CA 94037 Bus. ID: 8719 Send E-mailView Map
Winnies Organic Animal Products Complete line of organic products for horses. Winnie's Cookies works like a supplement, tastes like a treat. Baked fresh and shipped daily to your home or barn. 707-748-0341 Benicia, CA Bus. ID: 1134 Send E-mail
Search the Directory for:
