| |
|
|
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 < 1) as not_current_feature, date_add(hfslistings.feature_listings_expiry, INTERVAL 7 DAY) as adjustup_feature_expiry from hfslistings where 1=1 and mainlistings_completed='1' and description_completed='1' and disciplines_completed='1' and ((date_modified < '2012-10-02 22:08:40') OR (horse_img > '')) order by is_expired, not_current_feature, is_featured desc, CASE (date_add(date_modified, interval 7 day) > NOW()) WHEN true THEN date_modified END desc, RAND(3)
|
