Invalid query for dataset getproduct: ( select * from tblproducts left join tblproductscategory on ProductsCatID = ProductsCatRef left join tblproductstatus on ProductsStatusRef = ProductsStatusID left join unit_measure on unit_measure.UnitMeasureID = tblproducts.Unit_Measure_ID where (ProductsCatRef in (2,11,12,13,29,27,26,10,3,9,8,28,30)) and (ProductsVisible_UA = 1) and 1=1 order by ProductsName_, ProductsCatNodeLeft, ProductsID limit 0, 8)
Unknown column 'ProductsName_' in 'order clause'