PLEASURE is only one section of HSC's sale listings, and is searchable by name, breed, disciplines and state.
Use our Main Search to find PLEASURE 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, hfslistingsXperformancesuitability where 1=1 and hfslistingsXperformancesuitability.listing_id = hfslistings.id and (hfslistingsXperformancesuitability.performance_suit_id = '648' or hfslistingsXperformancesuitability.performance_suit_id = '226' or hfslistingsXperformancesuitability.performance_suit_id = '227' or hfslistingsXperformancesuitability.performance_suit_id = '229' or hfslistingsXperformancesuitability.performance_suit_id = '230' or hfslistingsXperformancesuitability.performance_suit_id = '231' or hfslistingsXperformancesuitability.performance_suit_id = '232' or hfslistingsXperformancesuitability.performance_suit_id = '233' or hfslistingsXperformancesuitability.performance_suit_id = '649') and mainlistings_completed='1' and description_completed='1' and disciplines_completed='1' order by not_current_feature, rand(11)
|
