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