Задавайте вопросы, мы ответим
Вы не зашли.
MySQL Error!
------------------------
The Error returned was:
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 '.xfields, makegame_2dle_post.title, makegame_2dle_post.date as newsdate, makegam' at line 1
Error Number:
1064
SELECT makegame_2dle_comments.id, post_id, makegame_2dle_comments.user_id, makegame_2dle_comments.date, makegame_2dle_comments.autor as gast_name, makegame_2dle_comments.email as gast_email, text, ip, is_register, lastdate,group_concat(mid) as `awards`, name, makegame_2dle_users.email, news_num, makegame_2dle_users.comm_num, user_group, reg_date, banned, signature, foto, signature, foto, fullname, land, icq, xfields, repa, repa_mod, repa_off makegame_2dle_users.xfields, makegame_2dle_post.title, makegame_2dle_post.date as newsdate, makegame_2dle_post.alt_name, makegame_2dle_post.category, makegame_2dle_post.flag FROM makegame_2dle_comments LEFT JOIN makegame_2dle_awards ON uid = makegame_2dle_comments.user_id LEFT JOIN makegame_2dle_post ON makegame_2dle_comments.post_id=makegame_2dle_post.id LEFT JOIN makegame_2dle_users ON makegame_2dle_comments.user_id=makegame_2dle_users.user_id GROUP BY id ORDER BY id desc LIMIT 0,30
Неактивен
repa_mod, repa_off makegame_2dle_users.xfields,
После repa_off нужна запятая.
Неактивен
а как зделать правильны запрос? что бы вставить запятую
Неактивен