WooYun.org

CDbException
CDbCommand failed to execute the SQL statement: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'JOIN g_gild_user AS gu ON gu.gild_id = gild.id
AND gu.role =1' at line 9. The SQL statement executed was: SELECT gild.name as name,gild.id as id, gild.active, guser.name as username, (
SELECT count( * )
FROM g_gild_user AS gild_user
WHERE gild_user.gild_id = gild.id and gild_user.`status`=1
) AS usercount
FROM g_gild_game AS gg
LEFT JOIN g_gild AS gild ON gg.gild_id = gild.id
AND gg.game_id =6*
LEFT JOIN g_gild_user AS gu ON gu.gild_id = gild.id
AND gu.role =1
LEFT JOIN g_user AS guser ON guser.id = gu.user_id where gild.`status`=1 GROUP BY gild.id order by gild.active desc limit 0,10