$query = "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 FROM searchy WHERE channel = '##windows' AND mdate > $datestop) AS channel_lines
 WHERE
   channel_lines.nick = nicks.nick
    AND
    channel_lines.hstring = nicks.hstring
 ) AS last_lines
GROUP BY hstring
ORDER BY avg_score";