Railsbin – The vulnerable pastebin service!

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";

Edit | Back