select p.products_image, p.products_image_optimized, pd.products_name, pd.products_short_description, pd.products_description, p.products_id, p.manufacturers_id, p.products_buyprice, p.products_raise, p.products_tax_class_id, p.unique_identifier,p.suppliers_id,p2c.sort_order,p.products_srp,p.products_id,products_sku,p.back_to_back from products_description pd inner join products p on p.products_id=pd.products_id inner join products_to_categories p2c on p.products_id=p2c.products_id where p.products_status = '1' and pd.language_id = '4' and p2c.categories_id = '48' and p.manufacturers_id in (165?osCsid=2a993keb4lrhul347lvs13o68e)
[TEP STOP]