Sport Horse is only one section of HSC's sale listings, and is searchable by name, breed, disciplines and state.
Use our Main Search to find Sport Horse horses for sale by rider suitability, performance level, location, breed AND discipline -- OR Use the Quick Search at the top of the page.
select distinct hfslistings.*, (hfslistings.expiry_date < date_sub(CURDATE(), INTERVAL 7 DAY)) as is_expired, (hfslistings.expiry_date < date_sub(CURDATE(), INTERVAL 7 DAY) OR hfslistings.is_featured = 0) as not_current_feature, date_add(hfslistings.feature_listings_expiry, INTERVAL 7 DAY) as adjustup_feature_expiry from hfslistings where 1=1 and (breed_id = '187' or breed_id = '162' or breed_id = '325' or breed_id = '248' or breed_id = '250' or breed_id = '327' or breed_id = '326') and mainlistings_completed='1' and description_completed='1' and disciplines_completed='1' order by not_current_feature, rand(10)
|
