SQL: SELECT DISTINCT c.*,max(s.score) as score,avg(s.score) as avgscore,max(y.score) as myscore,avg(y.score) as myavgscore FROM cdb_arcadegames c LEFT JOIN cdb_arcadescores s ON s.game=c.name AND s.valid=1 LEFT JOIN cdb_arcadescores y ON y.game=c.name AND y.username='不眠蛙' GROUP BY c.gameid ORDER BY c.title ASC
Error: Illegal mix of collations (gb2312_chinese_ci,IMPLICIT) and (latin1_swedish_ci,COERCIBLE) for operation '='
Errno.: 1267
Similar error report has beed dispatched to administrator before.
SQL: YTo2OntzOjY6InBsdWdpbiI7YToxMDp7czo3OiJwbHVnX2lkIjtzOjI6IjEzIjtzOjEwOiJwbHVnX3RpdGxlIjtzOjk6IlByb2FyY2FkZSI7czoxMjoicGx1Z192ZXJzaW9uIjtzOjM6IjIuNSI7czoxMToicGx1Z19hdXRob3IiO3M6MjI6IndpbnRlcjA3MDYoUnViYmlzaG1hbikiO3M6ODoicGx1Z19rZXkiO3M6MTQ6InByb2FyY2FkZWFkbWluIjtzOjEwOiJwbHVnX3N0YXRzIjtzOjE6IjAiO3M6NzoicGx1Z19jcCI7czoxODoicHJvYXJjYWRlYWRtaW4ucGhwIjtzOjExOiJwbHVnX3RhYmxlcyI7czowOiIiO3M6MTI6InBsdWdfbGljZW5zZSI7czowOiIiO3M6OToicGx1Z19kZXNjIjtzOjA6IiI7fXM6MTI6ImJvYXJkdmVyc2lvbiI7czozOiIyLjUiO3M6ODoiZ3JvdXBrZXkiO3M6MTQ6InByb2FyY2FkZWFkbWluIjtzOjExOiJncm91cGF1dGhvciI7czoyMjoid2ludGVyMDcwNihSdWJiaXNobWFuKSI7czoxMDoiZ3JvdXB0aXRsZSI7czo5OiJQcm9hcmNhZGUiO3M6MTI6Imdyb3VwdmVyc2lvbiI7czozOiIyLjUiO30=
Error: 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 'YTo2OntzOjY6InBsdWdpbiI7YToxMDp7czo3OiJwbHVnX2lkIjtzOjI6IjEzIjt
Errno.: 1064
An error report has been dispatched to our administrator.
显身卡