| |
|
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 mainlistings_completed='1' and description_completed='1' and disciplines_completed='1' order by is_expired, not_current_feature, is_featured desc, (date_add(date_modified, interval 1 day) > NOW()) desc, RAND(5)
|
