select p.products_image, p.products_image_optimized, pd.products_name, pd.products_short_description, pd.products_description,p.longtail, p.products_id,p.special_delivery, p.manufacturers_id, p.products_buyprice, p.products_raise, p.free_promo, p.products_tax_class_id,p.products_ean, p.unique_identifier,p.suppliers_id,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 where p.products_status = '1' and pd.language_id = '5' and p.products_id IN (223555,223606,224568,181265,235050,235051,306720,306723,306724,306725,306726,306727,306728,306729,306738,306739,306745,306746,306755,306756,306760,306761,27676,64672,306879,306880,306881,306882,306883) and pd.products_name <> '' and p.manufacturers_id in (137?osCsid=ha3h5438lkmf08bc2fn1j2ea2k) ORDER BY p.logistics_key DESC
[TEP STOP]