Query error
Question and answer:
SELECT SQL_CALC_FOUND_ROWS t1.*,t3.content,t3.ID commentID, DATEDIFF(NOW(),t1.date_added) as diff, UNIX_TIMESTAMP(t1.date_added) as unix_added, DATE_FORMAT(t1.date_added,'%d.%m %H:%i') as date_added2 FROM content_menu t1 LEFT JOIN content_comment t3 ON t3.parentID=t1.ID WHERE t1.ID IN () AND t1.langID=2 AND t1.module IN ('comment') ORDER BY t1.date_added DESC LIMIT 50 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 ') AND t1.langID=2 AND t1.module IN ('comment') ORDER BY t1.date_' at line 8