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 (15341,20774,21227,21228,21232,23674,23675,23676,23779,23861,23869,23870,23873,29477,29552,37198,38700,38702,38704,59660,65350,71502,71503,95386,95394,95404,95407,95412,95425,95446,96836,103116,103118,109005,111303,121757,122047,124715,124716,132008,134504,135642,135643,138525,138526,138527,138528,138530,143146,143150,143151,143221,143222,143225,143226,152027,152028,211908,211909,212355,212356,212357,212358,213607,225144,29551,132009,132010,234827,23872,147189,21233,138532,138533,259685,23875,298693,298694,301351,302317,302318,302319,302335,302355,302360,302361,307828,307883,307886,307888,307889,307890,307893) and pd.products_name <> '' and p.manufacturers_id in (212?osCsid=ksr9gr87a7av45v38ldqq0vdme) ORDER BY p.logistics_key DESC
[TEP STOP]