About My ACE Intelligence Product
Choose Product Category
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 'AND categoryID = 1 AND status = "Active"' at line 1 ]: DB query [SELECT COUNT(*) FROM products WHERE franchiseID = AND categoryID = 1 AND status = "Active"]
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 'AND categoryID = 2 AND status = "Active"' at line 1 ]: DB query [SELECT COUNT(*) FROM products WHERE franchiseID = AND categoryID = 2 AND status = "Active"]
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 'AND categoryID = 3 AND status = "Active"' at line 1 ]: DB query [SELECT COUNT(*) FROM products WHERE franchiseID = AND categoryID = 3 AND status = "Active"]
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 'AND categoryID = 4 AND status = "Active" AND inventory_id > 0 AND inventory_id I' at line 1 ]: DB query [SELECT COUNT(*) FROM products WHERE franchiseID = AND categoryID = 4 AND status = "Active" AND inventory_id > 0 AND inventory_id IN (SELECT inventory_id FROM inventory_stock WHERE franchise_id = GROUP BY inventory_id HAVING SUM(quantity) > 0)]
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 'AND categoryID = 5 AND status = "Active"' at line 1 ]: DB query [SELECT COUNT(*) FROM products WHERE franchiseID = AND categoryID = 5 AND status = "Active"]
Please Wait...
×
Cart