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 (11381,17082,17315,17316,19040,19072,19074,21451,21627,21630,21631,21633,21726,21733,25139,25142,25159,25165,25166,25167,25169,25170,25171,25172,25174,25175,25177,25178,25179,25180,25181,25183,25184,25185,25186,25188,25189,25190,25191,25192,25193,25195,25202,25203,25204,25205,25206,25207,25208,25209,25210,25211,25212,25213,25214,25215,25216,25217,25218,25219,25220,25221,25222,25223,25224,25225,25226,25227,25228,25229,25234,25235,25236,25237,25238,25239,25240,25241,25242,25243,25244,25245,25246,25247,25248,25249,25250,25251,25252,25253,25254,25255,25256,25257,25258,25259,25260,25261,25262,25263,25264,25265,25266,25267,25268,25269,25270,25271,25272,25281,25282,25283,25284,25285,25287,25289,25291,25292,25294,25295,25296,25297,25299,25301,25302,25303,25305,25307,25308,25311,25312,25313,25314,25318,25319,25320,25321,25322,25323,25324,25325,25326,25327,25328,25330,25331,25332,25333,25334,25335,25336,25337,25338,25339,25340,25342,25343,25344,25345,25346,25348,25349,25351,25429,25431,28610,28623,29466,39183,39184,39185,67908,67909,67910,67911,67912,67913,67914,67915,67916,67917,97612,102363,102845,111335,111336,127001,127002,127003,127004,127007,127008,131608,131609,131610,131611,131612,143076,143077,143078,147207,151226,151227,151228,151229,151230,151262,151532,151533,151555,152114,152115,152116,152117,152118,152119,152120,152121,152122,152123,152124,152125,152126,152127,152128,152129,152130,152131,152132,152133,152134,152135,152136,159146,177527,177528,177529,177530,186406,188936,188937,188938,188939,188940,188941,188942,188943,208035,208036,208037,208038,208039,209746,209757,210875,210935,210936,210937,210938,210939,210940,210941,210942,210943,210944,210945,210946,210947,210948,215014,216766,216767,216768,223865,223866,224644,224652,224653,224654,225031,225032,225033,225034,225035,225036,225037,225038,225039,225040,225041,225059,225060,226192,226193,226194,226195,226196,226226,226227,226228,226229,226230,25161,25162,187776,226287,226288,226289,226290,25160,187873,226889,226890,226891,226892,226893,226894,226895,226896,227872,227873,227874,227875,227876,227877,227878,227879,227880,227881,227882,227883,227884,227885,227886,227887,227888,227889,227890,227891,227892,227893,227894,227895,227896,227897,227898,227899,227900,227901,227902,227903,227904,227905,227906,227907,227908,227909,227910,227911,227912,227913,227914,227915,227916,227917,227918,227919,227920,227921,227922,227923,227924,227925,227926,227927,227928,227929,227930,227931,227932,227933,228560,228561,228562,228563,228564,228565,228566,228567,228568,228569,229465,233359,233360,235161,235162,235163,235164,235165,235537,235538,235643,236201,236660,236661,236662,236917,238182,238183,238184,238185,238186,238187,238188,238189,238190,238261,238262,238263,238264,238265,238266,238267,238268,238269,238270,238271,238272,238273,238274,238275,238276,238277,238365,238366,238367,238368,238509,238510,238511,238512,238513,238514,238515,238516,238517,238518,238658,238659,238660,39187,239044,239045,239046,239047,239048,239049,239050,239051,239052,239053,239054,239055,239056,239057,239058,239059,239060,239061,239062,239063,239064,239065,239066,239067,239097,239115,240098,252326,252327,262581,262625,266222,266227,266228,266233,266237,270199,91299,91330,91332,131614,131615,131616,131617,131618,165939,165940,165942,165943,165944,165945,166026,166027,166028,166029,166030,166031,166032,166033,166035,166036,166037,166038,166039,166041,166042,166043,166044,166045,166046,166047,166051,166055,166056,166059,166060,166061,166062,166063,166064,166065,166066,166067,166068,166069,166070,166071,166072,166073,166074,166075,166076,166088,166089,166090,166091,291616,297016,297452,297902,25140,298461,166049,299268,299270,299271,299272,299273,299274,299275,299276,299277,299365,299366,299367,299692,299696,299697,299702,299703,299811,299832,299836,299837,299842,299843,299931,300008,300012,300013,300018,300019,300107,301653,301654,301655,301656,301657,301658,301659,301660,301661,301662,301663,301664,301665,301666,301667,301668,301669,301670,301671,301672,301673,301674,301675,301676,301677,301678,301679,301680,301681,301682,301683,301684,301685,301686,301687,301688,301689,301690,301691,301692,301693,301694,301695,301696,301697,301698,301699,301700,301710,301711,301712,301713,301714,301715,301716,301717,301718,301719,301720,301721,301722,301723,301724,301725,301726,301727,301728,301729,301796,301797,301798,301799,302174,303138,303306,303627,303628,304865,304866,304867,304868,304869,304870,304871,304872,304873,304874,304875,304876,304877,305707,305708,305709,305711,25173,25394,28604,91316,308523) and pd.products_name <> '' and p.manufacturers_id in (313?osCsid=q95hnq2l5ij1u838j6o70f73fn) ORDER BY p.logistics_key DESC
[TEP STOP]