Database Error
Message: MySQL Error has occured
MySQL Error: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 C.isDeleted = 0 AND C.status = 1 AND C.queryString != 'kinamed' GROUP BY C.i' at line 3
Query:SELECT C.id, C.name, C.queryString, C.images, C.parent, COUNT(CJ.id) AS subCatCount FROM rls_categories C LEFT JOIN rls_categories CJ ON CJ.parent = C.id AND CJ.status = 1 AND CJ.isDeleted = 0 WHERE C.parent = AND C.isDeleted = 0 AND C.status = 1 AND C.queryString != 'kinamed' GROUP BY C.id ORDER BY C.name ASC LIMIT 0,40;
Trace:/home/surgic/public_html/subcategory.php at line 27
/home/surgic/public_html/classes/Categories.php at line 71
/home/surgic/public_html/classes/database/class.database-mysqli.php at line 539
/home/surgic/public_html/classes/database/class.database-mysqli.php at line 520