Public feed #726648

Untitled

public text v1 · immutable
Raw Edit
·published 2007-10-05 11:58 UTC
rendered paste body
EXPLAIN SELECT cem.Username, SUM(cem.ThumbsUp) AS thumbsup
FROM tbl_cnt_contestentrycomments cem, tbl_cnt_contestentries ce, tbl_cnt_contests c
WHERE cem.EntryID = ce.ID AND ce.ContestID = c.ID AND c.Startdate='2007-07-26' AND c.Enddate='2007-08-05'
GROUP BY cem.Username ORDER BY thumbsup DESC LIMIT 0,20