User:
Title: slowsql
Content:
$query = "SELECT regat_uid as user_id, user_name, SUM(regat_score) AS user_level,".
" GROUP_CONCAT(regat_sid) AS site_ids,".
" GROUP_CONCAT(regat_solved) AS site_solveds, ".
" COUNT(regat_score) AS nlinks, user_countryid".
" FROM $regat AS B".
" JOIN $sites AS S ON B.regat_sid = S.site_id".
" JOIN $users AS U ON B.regat_uid = U.user_id".
" WHERE site_status = 'up'".
" GROUP by regat_uidn ".
" ORDER BY user_level DESC, user_id ASC".
" LIMIT $from, $count";