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 tsc.subCategoryID=tssc.subCategoryID
and cat.categorquery=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