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 = '64' and b.Exp_Date >= '2019-08-19' and b.serv_region = 'Eastern Sierra' and (b.admin_appr = 'T' or b.submit_date > '2019-08-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 = '64' and b.serv_region = 'Eastern Sierra' and (b.admin_appr = 'T' or b.submit_date > '2019-08-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).
Horses' Honor A non-profit Sanctuary for Elder Horses. We keep our horses for life and network to help others in need. Tack donations support our efforts. Our oldest horse is 39 and was alone for 25 years before she came to us. Now she will live in peace and good company for the rest of her days. We are grateful. Nina Thompson 916-645-1630 Cell Phone: 530 305-9678 6600 Garden Bar Rd Lincoln, ca 95648 Bus. ID: 8188 Send E-mailView Map
Rockn B Leather Tina Burke 209-847-3569 Cell Phone: 602-1890 Oakdale, CA Bus. ID: 5200 Send E-mail
Search the Directory for: