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 (5857,5858,5859,5861,5863,7386,7388,7390,7393,7697,12214,12215,12217,12254,12260,12261,14262,14263,14264,14265,14266,14267,14268,14269,14270,14271,14272,14689,17269,17283,17284,18296,18302,18304,18305,18307,18891,18892,18893,18937,24949,24950,24956,24961,24971,24979,24984,24985,24989,24990,24991,24992,24998,24999,25005,25006,25007,25008,25009,25010,25011,25012,25013,25014,25015,25016,25017,25018,25019,25020,25021,25022,25023,25024,25025,25026,25027,25028,25029,25030,25031,25032,25033,25034,25035,25036,25071,25074,25075,25076,25079,25081,25084,25085,25086,25087,25089,25090,25091,25092,25093,25100,25101,25102,25103,25105,25106,25107,28602,28603,37310,66677,66678,67526,67527,67531,67532,67642,67645,67646,67647,67650,67651,67686,67687,67688,67692,70616,82814,82815,82816,82817,109958,109963,110017,111332,126549,126991,126992,126993,126994,126995,126996,126997,126998,126999,127000,127303,127304,127306,127307,127308,128807,128808,128810,128813,128815,128817,128820,128822,128823,134226,150014,150015,150775,159264,177136,177469,177508,177509,177510,177511,177512,177513,177514,177515,177516,186264,186265,186266,186267,186272,186273,186274,186277,186279,186280,186281,186384,186385,186386,186401,187156,187157,187158,187159,187166,187167,187168,187257,187418,187523,188169,188743,188744,188745,208026,208027,208028,208426,208427,210927,210963,211754,211755,211756,211757,211758,211759,211760,211761,211762,211763,211764,211765,211766,211767,211768,211769,211770,211771,211772,211773,211774,211775,211776,211777,211778,211779,211780,211781,211782,211783,211784,211785,211786,211787,211788,211789,211790,211791,213212,215310,221345,221346,221347,221348,221349,222557,222558,222559,222560,222561,222562,222563,222564,222565,222566,222567,222568,222569,222570,222571,222572,222573,222574,222575,222576,222577,222578,222579,222580,222581,222582,222583,222584,222585,222586,222587,222588,222589,222590,222893,222966,223496,223497,223498,223499,223500,223501,223502,223503,223504,223505,223506,223507,223508,223509,223510,223511,223512,223513,223514,223515,223516,223517,223518,223519,223520,223521,223859,224460,224490,224491,224492,224493,224494,224504,224505,224530,224531,224532,224533,224534,224535,224648,224649,224650,224663,224664,224665,224675,224676,224677,224678,224679,224680,224681,224682,224840,224841,224842,224843,224844,224845,224864,224935,224936,224937,224949,224950,224951,224952,224953,224954,224955,224956,224957,224958,224959,224960,224961,224962,224963,224964,224965,224966,224967,224968,224969,224970,224971,224972,224973,224974,224975,224976,224977,224978,224979,224980,224981,224982,224983,224984,224985,224986,224987,224988,226300,226301,226302,128811,128819,177428,226754,226833,226834,226835,226836,226850,226920,226921,226922,226923,226924,226925,227138,227426,227471,227571,227767,227768,227769,227770,227771,227772,227773,227774,227775,227776,227777,227778,227779,227780,227781,227782,227783,227784,227785,227786,227787,227788,228661,228683,228684,228685,228686,228687,228688,228689,228690,228691,228692,228693,228694,228695,228696,228697,228698,164079,164080,230268,230269,230763,235144,235145,235146,235147,235148,235149,235150,235151,235152,235153,235195,235196,235630,236232,236233,236234,236235,236236,236237,236913,236914,238178,24974,24975,24976,24977,24978,111330,238508,67481,25430,239040,239041,239205,239390,239479,239480,239801,252317,252319,252320,252321,39175,177048,261198,261403,261404,261405,262663,262664,262797,262798,262852,262853,90784,262867,67530,266288,266289,266301,269240,269258,269259,269260,269262,24959,67525,299281,299282,299283,299284,299285,299286,299287,299288,299289,299290,299291,299292,299293,299294,299295,299296,299297,299298,299299,299300,299301,299302,299303,299304,299305,299306,299307,299308,299309,299310,299311,299312,299313,299314,299315,299316,299317,299318,299319,299320,299321,299322,299323,299324,299325,299326,299327,299328,299329,299330,299331,299332,299333,299334,299335,299336,299337,299343,299344,299345,299346,299347,299348,299349,299350,299351,299352,299353,299354,299449,301487,301488,301489,301490,301557,301732,301733,301734,301735,301736,301737,301738,301739,301740,301741,301742,301743,301744,301745,301746,301747,301748,301749,301750,301751,301752,301753,301754,301755,301756,301757,301758,301759,301760,301761,301762,301763,301764,301765,301766,301767,301768,301769,301770,301771,301772,301773,301774,301775,301776,301777,301778,301779,301780,301781,301782,301783,301784,301785,301786,301787,301788,301789,301790,301791,301792,301793,301794,301795,302051,302052,302053,302054,302083,302194,302195,302196,302197,302198,302199,302200,303833,303834,303839,304216,304219,17214,25057,25108,67690,13023,13026,13029,17282,24962,24963,24966,25088,67528,67529,67685,24967) and pd.products_name <> '' and p.manufacturers_id in (1140?osCsid=qj2pgbb9fojj59nbeah4gh47cv) ORDER BY p.logistics_key DESC
[TEP STOP]