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 ') GROUP BY P.id ORDER BY P.name ASC' at line 1
Query:SELECT P.id, P.name, P.queryString, (SELECT PI.imagesName FROM rls_products_images PI WHERE PI.productId = P.id AND PI.status = 1 AND PI.isDeleted = 0 ORDER BY isDefault DESC LIMIT 1) AS imagesName FROM rls_categories C, rls_manufacturers M, rls_products_manufacturers PM, rls_products_categories PC, rls_products P WHERE P.id = PC.productId AND C.id = PC.categoriesId AND M.id = PM.manufacturersId AND PM.productId = P.id AND M.isDeleted = 0 AND M.status = 1 AND C.isDeleted = 0 AND C.status = 1 AND P.isDeleted = 0 AND P.status = 1 AND P.queryString != 'chesapeake-cervical-ti-stabilization-system' AND C.queryString IN() GROUP BY P.id ORDER BY P.name ASC;
Trace:/home/surgic/public_html/product.php at line 20
/home/surgic/public_html/classes/Products.php at line 285
/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