SELECT |
c.*, CASE WHEN ceil((sysdate - create_date) * 24 * 60 * 60) <= (48 * 60 * 60) THEN ceil((sysdate - create_date) * 24 * 60 * 60) ELSE 0 END AS create_date_order |
FROM |
cms c |
ORDER BY |
create_date_order desc , |
read_times desc |