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 = '5' and b.Exp_Date >= '2021-08-05' and (b.admin_appr = 'T' or b.submit_date > '2021-08-02')
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 = '5' and (b.admin_appr = 'T' or b.submit_date > '2021-08-02') 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).
Triple R Stables We as a family buy an sell horses we are not your every day horse trader we have most of our horses for 6+ month and we don't put them on the market before we feel that there ready for there new forever home! We have Freisians, Friesian crosses, draft crosses, Gypsy Vanners, Quarter Horses, ponies. Ray Raber 752877-3302752877 Cell Phone: 3302752877 3769 Township Road 154 Millersburg Ohio 44654 Township road 154 Millersburg, Ohio 44654 Bus. ID: 9459 Send E-mail
Jamestown Livestock Jeff Bridgewater 209-984-3234 Cell Phone: 209-352-2305 16206 State Hwy 108 Jamestown, CA 95327 Bus. ID: 2883
Search the Directory for: