SELECT nick, hstring, avg(score) AS avg_score FROM (SELECT channel_lines.nick, channel_lines.hstring, channel_lines.score FROM (SELECT DISTINCT nick, hstring FROM searchy WHERE channel = '##windows' ORDER BY increment DESC LIMIT 20 ) AS nicks, (SELECT nick, hstring, score, mdate FROM searchy WHERE channel = '##windows' AND mdate > 10160) AS channel_lines WHERE channel_lines.nick = nicks.nick AND channel_lines.hstring = nicks.hstring order by mdate DESC limit 80 ) AS last_lines GROUP BY hstring ORDER BY avg_score DESC