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 (22261,22262,22264,22265,22277,22278,22279,22280,22281,22282,22284,102793,102915,102917,102918,102919,102920,102921,102922,102923,102925,102926,102927,102928,102929,102930,102931,102932,124862,124881,128848,157397,187049,187050,187052,187053,187054,187055,217215,217216,217218,217220,217222,218109,218110,218111,218112,218113,220826,220827,220828,220829,220830,220831,221470,222248,222249,222250,222251,222252,222253,222254,222255,228715,228716,228717,228718,102924) and pd.products_name <> '' and p.manufacturers_id in (293?osCsid=s37nhip95ea5vveqisnkbf9jq0) ORDER BY p.logistics_key DESC
[TEP STOP]