|
|
Database error: Invalid SQL: SELECT
cat.*,
count(link.ID) as links
FROM tblcategory cat
LEFT JOIN tbllink link ON (link.CategoryID=cat.ID)
LEFT JOIN tbluser ON (tbluser.ID=link.UserID AND (tbluser.boolIsDisabled = 0 OR tbluser.boolIsDisabled IS NULL))
WHERE cat.parent=
GROUP BY cat.ID
ORDER BY cat.parent, cat.strCatName
MySQL Error: 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 'GROUP BY cat.ID
ORDER BY cat.parent, cat.strCatName' at line 8)
Session halted.
|
