SELECT count(DISTINCT a.`ID`) AS CNT 
				FROM `view_products_plain` a  inner join `tbl_products2cats` c2p on a.`ID` = c2p.`ITEM_ID` inner join `tbl_products_categories` cat ON cat.`ID` = c2p.`CAT_ID` AND cat.`LEFT_ID` >= 31 AND cat.`RIGHT_ID` <=  32 
				WHERE (a.`FLAG_GUEST` ) AND (a.`TYPE` IN ('PROD', 'DIGPROD', 'BUNDLE'))   
				ORDER BY `ID` DESC|Query failed MySQL message:Column 'ID' in order clause is ambiguous