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 (5274,18946,18950,18965,23785,23786,23787,32708,32709,32710,32714,32716,32717,32718,32729,32731,32732,32738,32739,32740,32785,32786,32787,32788,32789,66910,66911,66912,66913,66914,66915,66916,66917,66918,66919,66920,66921,66922,66923,66924,66926,66927,66928,66929,66930,66931,66932,66933,66934,66935,66936,66937,66938,66939,66940,66941,66942,66943,95122,95123,95124,95125,95449,95453,95806,95820,95827,96023,96176,96177,96658,96920,97004,97008,97013,97023,97024,97026,97028,97041,97042,97051,97052,97053,97057,97067,97073,97074,97081,97086,97087,97088,97098,97099,97100,97104,97109,97111,97118,97119,97129,97137,97139,97141,97158,97161,97180,97186,97188,97189,97195,97197,97215,97222,97232,97268,97269,97274,97290,97319,97320,97326,97328,97331,97338,97340,97356,97359,97389,97390,97437,103214,109128,109988,109989,109990,109991,110179,110180,110285,110286,110287,110288,110289,110290,110291,110292,110293,110294,110295,110296,110297,110298,110299,110332,110333,110334,110335,110336,110337,110338,110339,110340,110341,110342,110343,110344,110345,110346,110347,110348,110349,110350,110351,110352,110353,110354,110355,110356,110375,110376,110377,110378,110383,110385,110386,110391,110392,110393,110402,110416,110705,110706,110707,132380,137343,137344,137345,137346,137352,137353,137354,137355,137356,137357,137358,137359,142847,156347,156814,157160,172266,172267,172268,172269,172270,172271,172272,172273,172274,172275,172276,172277,172278,172279,172280,172281,172282,172283,172284,172285,172295,172297,172298,172299,172300,172301,172317,172318,172319,172320,172321,172322,172350,172351,172352,172353,172354,172355,172359,172360,172367,172368,172369,172370,172371,172372,172376,172377,175508,175509,175510,175511,175512,177142,177268,177276,181574,185778,187925,187926,187927,187928,189000,189001,189002,189003,189004,189008,189009,189010,189011,189012,189013,189014,189019,189020,189021,189022,189023,189029,189030,189031,189032,189033,189034,189035,189036,189037,189038,189039,189040,189082,189083,189084,189085,189086,189087,189088,189089,189098,189099,189100,189101,189102,189103,189104,189105,189106,189107,189108,189109,189110,189111,189112,189113,189157,189166,189167,189168,189169,189170,189171,189172,189173,189174,189175,189176,189177,189178,189652,189653,189654,189655,189656,189657,189715,189716,189717,189718,189719,189720,189721,189722,189723,189724,189725,189726,189727,189728,189729,189730,189731,189737,189738,189739,189740,189744,189745,189746,189747,189748,189752,189753,189754,189755,189756,189757,189758,189759,189760,189761,189762,189763,189764,189765,189766,189767,189768,189769,189770,189771,189772,189773,189774,189775,189779,189780,189781,189785,189786,189787,189788,189789,192514,192515,192516,192517,192518,192519,192520,192548,207636,207637,207638,207732,207733,207734,207967,207968,209542,209543,209544,209545,209546,209547,209548,209549,209550,209551,209552,209553,209554,209555,209556,209558,209559,209560,209561,209562,212276,212277,212278,212279,212423,212587,212588,212658,212659,212660,212932,212933,212934,213462,214561,214562,214563,214564,214565,214566,214567,214568,214569,214570,214571,214572,214573,214574,214575,214576,214577,214578,214579,214580,214581,214582,214583,214584,214585,214586,214587,214588,214589,214590,214591,214592,216489,216490,216491,216492,216493,216494,216495,216496,216497,216498,216499,216500,216501,216502,216529,216530,216531,216532,216533,216534,216535,216536,216537,223032,223037,223038,223039,223040,223042,223210,226399,226513,226537,226663,226702,226790,226791,227417,227418,227429,227430,227563,227564,234497,234498,234499,234560,234561,234562,234563,234564,234565,235025,235773,236245,236246,236247,236525,236539,236540,236541,32791,78008,239035,154479,178301,178579,257281,257282,257283,257391,257392,257393,262590,262592,262594,262596,262599,262631,262771,263931,263932,263933,263934,263935,263936,263937,264117,267038,267056,267058,102500,101879,101882,22386,35981,35982,154476,285667,285668,285670,285671,285672,285673,285674,285676,22376,22389,286783,286784,286785,288661,291305,291306,291307,291308,291309,291310,291311,291312,291313,291314,291315,291316,291376,291377,291378,291379,291380,291381,291382,291383,291384,291610,291611,292384,292385,295265,295267,295269,295271,295273,295275,295277,295279,295281,295283,295285,296043,296073,296075,296307,296311,296313,296315,296317,296319,296321,296323,296325,296329,296331,296333,296345,296394,296396,296393,296395,296928,296929,296931,296932,296933,297206,297207,300275,300390,300414,300416,300418,300420,303392,303409,303410,303861,303862,303864,303865,303866,303867,303868,303870,305080,305083,305578,305579,305580,305581,306551,306552,306553,306554,306555,306556,306557,306558,306559,306560,306561,306562,306563,306564,306565,177760,110384,308082,175349,175350) and pd.products_name <> '' and p.manufacturers_id in (2444?osCsid=6f786c3s7f49tekqggrnfbk3b3) ORDER BY p.logistics_key DESC
[TEP STOP]