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 (1463,1464,1465,5681,5682,5683,5684,5686,5687,5688,5689,8393,10022,10023,10024,10372,10374,10376,10377,10432,10433,10434,10435,10436,10437,10438,10439,10454,10455,10456,10457,10458,10459,10831,10832,10833,10834,10835,10836,10837,12481,12482,12483,20560,20561,29876,30099,30100,30101,30102,30103,30104,30105,30106,30107,30138,30139,30140,30141,30142,30143,30144,30624,30625,30626,30627,30630,30631,30641,30642,30643,30644,30645,30646,30653,30654,30655,30667,30668,30671,30673,30691,30693,39627,39628,39629,39630,39631,39632,66979,66980,67185,67187,81463,84064,84065,84066,84068,84094,84095,84096,84097,84098,84099,84100,95538,95539,95540,95541,102800,102801,102803,102804,102805,107869,107870,107871,107872,109107,109108,109109,109110,111927,111935,111936,111937,111938,111941,111945,111949,111953,111957,111961,111965,111976,115095,115097,125496,128626,134131,134132,134133,134134,134135,134136,134137,134138,134139,134141,134142,134143,134144,134741,136212,136213,136214,136215,136217,136230,136233,136235,136236,136882,136883,136884,136885,141309,141311,141312,141313,141314,141600,152166,152189,152195,152196,155086,155087,155088,157151,175449,175450,177590,177704,177991,178563,178564,185869,185871,185872,185873,185879,185883,185894,185900,186377,187193,187501,187777,187851,187852,187853,187854,187855,187856,187857,187858,187859,187860,188071,188665,188666,188667,189822,189823,189824,189825,189826,189827,189828,189829,189830,189831,189832,189833,207362,207363,207364,207365,207366,207367,208458,208459,208460,208461,208462,208569,208570,208571,213460,213461,214245,214246,216369,216420,216424,220822,220823,220824,220825,221469,223134,223135,223136,223137,223205,223206,223207,224379,224434,224435,226637,226971,226974,226975,226976,226977,226978,226979,226980,226981,226982,226983,226984,226985,226986,226987,226988,226989,177745,178566,178567,178568,178569,178570,178571,185870,227164,227165,227166,227167,227168,227169,227193,227194,227195,227196,227197,227198,228059,228060,228061,228062,228063,228064,228069,228070,228071,228072,228073,228074,228075,228076,228077,228078,228079,228080,228081,228082,228083,159118,228084,228085,228086,228087,228088,228089,228090,228091,228092,228093,228094,228095,228096,228097,228098,228099,228100,228101,228102,228103,228140,228141,228142,228143,228144,228145,228146,228147,228148,228149,228150,228151,228152,228153,228154,228155,228156,228157,228158,228159,228160,228161,228162,228163,228164,228165,228166,228167,228168,228169,228170,228171,228172,228173,228174,228175,228176,228467,228468,228469,94310,228701,136232,136237,164153,164154,228842,228843,228844,134140,176958,176960,229060,229061,229062,229063,229064,229069,229070,229071,229072,229073,229074,229135,229136,229156,229172,229173,229174,229175,229176,229195,229199,229200,229201,229202,229203,229204,229205,229206,229233,230035,230036,230037,230038,230039,230040,230041,230042,230043,230044,230045,230046,230047,230060,230071,230072,230073,230074,230075,230076,230077,230078,230079,230080,230081,230082,230083,230084,230085,230086,230087,230088,230089,230097,230098,230099,230100,230118,230119,230120,230121,230122,230123,230124,230125,230126,230127,230128,230129,230130,230131,230132,230133,230134,230135,230136,230137,230138,230139,230140,230155,230156,230157,230158,230159,230160,230161,230162,230163,230164,230165,230166,230167,230168,185897,230297,230298,230299,230314,230315,230316,230317,230318,230319,230320,230659,230660,230767,87992,88086,88106,88134,231264,231265,231266,231271,231272,231277,231278,231279,231280,231281,231834,231835,134742,232065,232066,232067,232068,94227,94232,94298,232948,232949,232950,232951,232952,232953,232954,232955,232956,232957,232958,232959,232960,232961,232962,232963,232964,232965,232966,232967,232968,232969,232970,232971,232972,232973,232974,232975,232976,232977,232978,232979,94206,94207,94208,94305,94306,94307,94308,94313,94314,94315,94316,94321,94322,94323,94324,94763,136222,136227,232980,232981,232982,232983,232984,232985,232986,232987,232988,232989,232990,232991,232992,232993,232994,232995,232996,232997,232998,232999,233000,233001,233002,233003,233004,233005,233006,233007,233008,233009,233010,233011,233012,233013,233014,233015,233016,233017,233018,233019,233020,233021,233022,233023,233024,233025,233026,233027,233028,233029,233030,233031,233032,233033,233034,233035,233036,233037,94187,94189,94192,94296,94301,94302,94303,94304,233038,233039,233040,233041,233042,233043,233044,233045,233046,233047,233048,233049,233050,233051,233052,233053,233054,233055,233056,233057,233058,233059,233060,233061,233948,233949,233950,233951,233952,233953,234969,234970,234971,234972,234973,235349,235350,235351,235352,235353,235354,235355,235356,235370,235371,235372,235373,235374,235375,235376,235389,235390,235442,235443,235444,235445,235446,235447,235448,236784,236785,236786,236787,236838,236839,236840,236841,236842,236843,10332,10337,10338,110717,110719,110720,12129,115096,29967,238876,238877,238878,30682,100293,33600,239206,256074,77949,262761,263986,263987,263988,263989,263990,263991,264090,264091,266193,266753,268335,268336,268337,268338,268339,268340,268341,268342,268343,268344,268345,268346,268347,268348,268356,268357,268358,268359,268361,268362,268363,268491,268492,268493,268494,268753,268755,268756,268757,268758,268759,268760,268773,268776,94176,286999,287000,287003,287004,287549,287550,287551,287552,287553,287554,287555,287556,287557,287558,287559,287560,287564,287565,287566,287580,287581,287582,287591,287592,287593,287594,287595,287596,287597,287598,287599,287600,287616,287618,287619,287621,287622,287623,287640,287649,287734,287735,287790,287791,123142,297253,297254,297665,297669,297863,298026,298028,298030,298037,298141,88110,88111,299031,300138,300139,301057,301058,301059,301060,301061,301062,301063,301064,301065,301066,301067,301068,301069,301070,301072,301073,301074,301077,301078,301079,301080,301081,301082,301083,301084,301149,301150,301151,301152,301286,301287,301288,301289,301290,301291,301292,301296,301297,301298,301299,302439,302440,302441,302442,302443,302444,302445,302447,302448,302449,302450,302451,302453,302454,302455,302456,302457,302458,302459,302460,302461,302462,302463,302718,302719,302720,302932,302933,302934,302935,302936,302937,302938,302940,302941,303463,303464,303465,303466,303614,303793,30137,305050,305051,305052,305053,305054,305055,305056,305057,305058,305752,305753,305754,306647,306649,306651,306652,306664,306665,306670,306671,102802,30436,308526,308537,150925) and pd.products_name <> '' and p.manufacturers_id in (302?osCsid=jtf9gll6ouvp222mphl378rae4) ORDER BY p.logistics_key DESC
[TEP STOP]