Geeklog Forums

Mon Jul 19 01:37:23 2004 - 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 '= gl_comments.sid) AND (gl_stories.draft_flag = 0) AND (tid IN . SQL in question: SELECT DISTINCT count(*) AS dups, type, question, gl_stories.title, gl_stories.sid, qid, max(gl_comments.date) as lastdate FROM gl_comments LEFT JOIN gl_stories ON ((.sid = gl_comments.sid) AND (gl_stories.draft_flag = 0) AND (tid IN ('GeekLog','General'))) LEFT JOIN gl_pollquestions ON ((qid = gl_comments.sid)) WHERE (gl_comments.date >= (DATE_SUB(NOW(), INTERVAL 172800 SECOND))) AND ((((gl_stories.owner_id IS NOT NULL AND gl_stories.perm_owner IS NOT NULL) OR (gl_stories.group_id IS NOT NULL AND gl_stories.perm_group IS NOT NULL) OR (gl_stories.perm_members IS NOT NULL))) OR (((gl_pollquestions.owner_id IS NOT NULL AND gl_pollquestions.perm_owner IS NOT NULL) OR (gl_pollquestions.group_id IS NOT NULL AND gl_pollquestions.perm_group IS NOT NULL) OR (gl_pollquestions.perm_members IS NOT NULL)))) GROUP BY gl_comments.sid ORDER BY 7 DESC LIMIT 15