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 'group_concat(mid) as `awards`, name, dle_users.email, news_num, dle_users.comm_n' at line 1
Error Number:
1064
SELECT dle_comments.id, ( comments.id%2C/ ) post_id, dle_comments.user_id, dle_comments.date, dle_comments.autor as gast_name, dle_comments.email as gast_email, text, ip,is_register,name,lastdate,,group_concat(mid) as `awards`, name, dle_users.email, news_num, dle_users.comm_num, user_group, lastdate, reg_date, signature, foto, fullname, land, icq, dle_users.xfields, dle_post.title, dle_post.date as newsdate, dle_post.alt_name, dle_post.category FROM dle_comments LEFT JOIN dle_awards оN uid = dle_comments.user_id LEFT JOIN dle_post ON dle_comments.post_id=dle_post.id ( post.id/ ) LEFT JOIN dle_users ON dle_comments.user_id=dle_users.user_id GROUP BY id ORDER BY id desc LIMIT 0,30
------------------------
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 'group_concat(mid) as `awards`, name, dle_users.email, news_num, dle_users.comm_n' at line 1
Error Number:
1064
SELECT dle_comments.id, ( comments.id%2C/ ) post_id, dle_comments.user_id, dle_comments.date, dle_comments.autor as gast_name, dle_comments.email as gast_email, text, ip,is_register,name,lastdate,,group_concat(mid) as `awards`, name, dle_users.email, news_num, dle_users.comm_num, user_group, lastdate, reg_date, signature, foto, fullname, land, icq, dle_users.xfields, dle_post.title, dle_post.date as newsdate, dle_post.alt_name, dle_post.category FROM dle_comments LEFT JOIN dle_awards оN uid = dle_comments.user_id LEFT JOIN dle_post ON dle_comments.post_id=dle_post.id ( post.id/ ) LEFT JOIN dle_users ON dle_comments.user_id=dle_users.user_id GROUP BY id ORDER BY id desc LIMIT 0,30