ack! query failed:
  • errorno=1064
  • 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 tsc.subCategoryID=tssc.subCategoryID and cat.categor
  • query=select tsc.categoryID as 'catid', categoryName, tsc.subCategoryID as 'subcatid', tsc.description as 'subdes', subCategoryName, subSubCategoryName, subSubCategoryID, tsc.oldSubCategoryID as 'oldsubcatid', oldSubSubCategoryID, tsc.totalProducts as 'totalproduct' from tblsubcategorymaster tsc, subsubcategorymaster1 tssc, tblcategorymaster cat where tsc.categoryID= and tsc.subCategoryID=tssc.subCategoryID and cat.categoryID=tsc.categoryID AND FIND_IN_SET('1',cat.osSupported) group by tsc.subCategoryID