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 (29503,60234,95410,95771,103110,103111,103112,103113,103114,103115,107761,110734,112060,115140,115557,125447,132001,132003,132004,132005,136163,138513,138514,138516,138517,138521,138523,138524,142305,142306,142308,142309,142310,143162,143163,143173,143187,143188,152032,154395,154396,155433,155434,157482,157523,157524,157525,157709,157910,158181,159045,159996,178407,186231,186429,186430,186431,187410,207726,212251,212257,212378,212379,212406,213088,213089,213090,213091,213092,213444,213445,213446,213447,215301,216079,216179,216180,216194,216195,225131,225132,225133,225134,225135,225136,225137,225138,225139,225472,225473,230677,96884,96885,212259,236074,240302,240303,246815,251593,259726,259728,262306,193357,265938,270817,138515,39552,297264,297310,297312,297314,297315,297519,298520,301349,301350,302356,305638,305639,136865) and pd.products_name <> '' and p.manufacturers_id in (180?osCsid=km80suc4s8ipvsvchjjhm6e2cb) ORDER BY p.logistics_key DESC
[TEP STOP]