CNC 602A Auto Fuel Injector Tester and Cleaner is an advanced electromechanical product, which can clean and test injectors by simulating engine working conditions. It can also perform cleaning on the injectors and fuel supply system on vehicles.
3065 - Expression #1 of ORDER BY clause is not in SELECT list, references column 'ats.xp.sort_order' which is not in SELECT list; this is incompatible with DISTINCT
select distinct p.products_id, p.products_image, pd.products_name, pd.products_description, pd.products_short, p.products_tax_class_id, products_price, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price
from products_xsell xp left join products p on xp.xsell_id = p.products_id
left join products_description pd on p.products_id = pd.products_id and pd.language_id = '1'
left join specials s on p.products_id = s.products_id
where xp.products_id = '427'
and p.products_status = '1'
order by sort_order asc limit 6
[TEP STOP]