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 (28)) and
(ProductsVisible_UA = 1) and
1=1 order by
ProductsName_, ProductsCatNodeLeft, ProductsID
limit 0, 8)
Unknown column 'ProductsName_' in 'order clause'