Database Error | |
---|---|
Message: | MySQL Error has occured |
MySQL Error: | You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'AND C.isDeleted = 0 AND C.status = 1 AND C.queryString != 'kinamed' GROUP BY ...' 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 |