Pony - is only one section of HSC's sale listings, and is searchable by name, breed, disciplines and state.
Use our Main Search to find Pony - 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 = '623' or breed_id = '158' or breed_id = '580' or breed_id = '581' or breed_id = '582' or breed_id = '587' or breed_id = '596' or breed_id = '608') and mainlistings_completed='1' and description_completed='1' and disciplines_completed='1' order by not_current_feature, rand(10)
|
