您可以在
ORDER BY子句中使用所需的数据。
SELECt p.id, p.title, p.time_submitted, SUM(v.score) as num_votes FROM posts p, votes v WHERe v.postid = p.idGROUP BY p.idORDER BY (SUM(v.score) - 1) / POW(TIMESTAMPDIFF(HOUR,p.time_submitted,NOW()) + INTERVAL 2 HOUR, 1.8) DESCLIMIT 100
