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 (1249,1255,1256,1271,1273,1276,1281,6274,6276,6277,6279,6281,16508,16531,16532,16671,16672,16673,16674,16675,16677,16678,16679,16680,16682,16683,16684,16685,16686,16687,16688,16689,16690,16692,16693,16694,16695,16696,16698,16699,16700,16701,28830,28831,28832,28838,28839,28840,29121,29122,29123,29124,29125,29126,29218,29219,29220,29221,29227,29228,29229,29230,29234,29235,29236,29237,29263,29264,29265,29266,29267,29268,29269,29270,29271,29272,29273,29274,29301,29302,29304,29305,29306,29307,29318,29319,29320,29321,37720,37721,37722,37723,37724,37725,37726,37773,37774,37775,38690,40143,40144,40145,40146,40147,40148,60184,62042,64528,64529,64531,64532,68314,68316,95385,95485,95486,95487,95488,132898,150761,150762,151232,151233,151234,151235,151236,152163,157307,158842,158844,176904,186988,187498,187499,187500,188717,207567,208049,210849,210850,210851,210853,211834,214135,214136,224475,224476,224477,224478,224479,224480,224481,224506,224507,224508,224509,224510,224511,224512,224513,224514,224517,224614,224615,224616,224617,224618,224619,224620,224621,226095,226096,226097,226098,226099,226100,226101,226102,226103,226104,226105,226106,226107,226108,226109,226110,226111,226112,226113,226114,132899,151011,226910,226911,226912,226913,227319,227320,227321,227322,227323,227475,227476,227479,234864,234865,235644,90264,239159,239871,239872,239873,239874,239888,64530,252318,256373,256994,256995,259785,259786,259787,259788,259790,259791,259792,259793,262769,266235,266707,268980,268981,268982,268985,287451,291304,299975,300134,300135,301377,301378,301379,301380,301381,302297,302298,302299,302300,303812,29322) and pd.products_name <> '' and p.manufacturers_id in (3166?osCsid=vd44r1svv61ph0bpl5sm6gufta) ORDER BY p.logistics_key DESC
[TEP STOP]