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 (4918,5654,10399,10400,10401,16536,16537,16548,16552,16555,16556,16557,16558,16561,16566,16567,16569,16571,16572,16575,16583,16603,16630,16656,16670,16888,19183,19184,19185,21909,21910,21911,26279,26280,26281,26285,26286,26287,26288,26289,26292,26293,26294,26295,26296,26297,26298,26304,26307,26310,26311,26318,26322,26323,26325,26326,26330,26334,26358,26359,26360,26361,26373,26381,26382,26383,37246,37248,37249,62257,62259,62261,62977,64471,64473,64481,64485,78052,96326,96334,104279,104925,119953,122007,122008,122753,122774,123200,123201,123202,123203,123204,123205,123206,127019,127020,127428,127430,135660,137030,150929,150930,152067,152068,152070,152071,152072,167068,177309,177310,177311,177312,177313,177314,177321,177322,185827,185828,185829,187277,187344,187345,187346,187667,187668,187669,187670,187751,187752,187753,188722,188723,190118,207550,207562,207563,207564,207985,207986,207987,207988,207989,207990,207991,207992,207993,208916,208917,215166,215167,215168,215170,215171,215172,215173,215174,215175,215176,215177,215178,215179,215180,215181,215182,215183,215184,215185,215186,215187,215188,215189,215190,215191,215192,215193,215194,215195,215196,215197,215198,215199,215200,215201,215202,215203,215347,215348,216421,226886,227435,227436,227495,227496,227497,227591,227592,227593,227594,227595,227596,227597,227598,227599,227600,227601,227602,227810,227811,227946,227947,227948,227979,227980,62978,137029,167069,167070,228292,228293,228294,228295,228296,228297,228299,228300,228301,228302,228305,228306,228307,228308,228309,228310,228311,228312,228313,228314,228315,228316,228317,228318,228319,228320,228325,228326,228327,228328,228329,228330,228331,228332,228333,228334,228335,228336,228337,228338,228339,228340,228341,228342,228343,228344,228345,228346,228347,228348,228349,228350,228351,228352,228353,228354,228355,228356,228357,228358,228359,228360,228361,228362,228363,228364,228365,228366,228367,228368,228369,228370,228371,228372,228373,228374,228375,228376,228377,228378,228379,228380,228381,228382,228383,228384,228385,228386,228387,228388,228389,228390,228391,228392,228393,228394,228395,228396,228397,228398,228399,228400,228401,228402,228403,228404,228405,228406,228407,228408,228409,228410,228411,228412,228413,228414,228415,228416,228418,228419,228420,228421,228422,228423,229059,229503,229504,229505,235657,235658,235659,235660,235661,235662,235663,235664,235665,235951,235952,235953,235954,235955,235956,235964,235965,235966,235967,235968,236189,236190,236855,21908,39221,62262,26374,103958,240648,240690,240691,240692,240693,240694,240705,240706,240707,240708,240709,240758,240759,240760,240767,254505,256755,256757,256837,256838,256839,256840,256841,256842,256843,256844,256845,256846,256847,257054,257450,260736,260737,260760,24734,261515,261516,261517,261519,261520,262290,262291,262292,262293,262294,262295,262296,262297,262298,262299,262300,262354,262355,262356,262357,262358,262359,262360,263929,71262,264230,265912,265913,265914,265983,265984,265985,266206,266209,269761,269770,269771,269773,269789,269792,270853,270854,270855,270856,270857,270858,270859,26370,26371,271189,285605,285606,285607,285658,285660,285661,285662,26319,26339,39228,287653,287850,288095,288096,288111,292388,296729,296921,296960,71202,297504,297696,26309,297899,297900,297901,297903,297904,297905,297906,297907,297908,297909,297910,297911,297912,297914,26329,298758,298761,299106,299108,299109,299110,299111,299112,299113,299117,299118,299119,303574,303710,303711,303799,303800,303803,303853,303854,303855,303856,303973,303974,303975,64480,95005,304111,304112,304113,304114,304115,304116,304117,304120,304121,304122,304123,304124,304420,304421,304422,304442,304640,304641,304642,304818,304858,305706,96329,90400,96327,308079,308560,152073,308564,308623) and pd.products_name <> '' and p.manufacturers_id in (3259?osCsid=ofdf1u57d4n7gn7uh6g4nbq5og) ORDER BY p.logistics_key DESC
[TEP STOP]