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 (9466,9467,13545,13546,13548,13550,13551,14793,14794,26190,26191,26193,26194,26195,26197,26198,26200,26203,64450,64451,66984,66986,67444,67445,70712,70714,70883,70884,70886,70888,70899,70900,70901,70902,70957,70958,70959,70961,70968,77192,77193,80405,80406,80408,80409,80412,80413,84243,89392,89394,89887,89889,89907,89908,89909,89910,89911,89912,95336,95337,114587,114588,114589,119737,125474,126524,126525,126528,126529,127017,127257,131726,131727,131728,131738,131739,131740,131741,131742,131750,131751,142257,143835,143836,143837,150438,150439,150441,150442,150443,151498,151499,165675,165677,165679,165680,165818,165819,165820,165821,165822,175415,175416,175417,175418,175618,176533,178091,186258,186260,186262,186283,186284,186285,188177,207998,207999,208000,208001,208002,208003,208004,208875,208876,208877,208878,208879,210823,211739,211740,216412,222551,222552,222553,223724,223726,224544,224545,224546,224576,224577,224578,224579,224580,224581,224582,224694,224695,224696,224697,224698,224699,89891,89892,89894,89902,89903,89904,89905,89906,89952,89953,89954,161578,225535,225536,225537,225538,225617,225618,225619,225661,225662,225663,225664,225665,26192,26199,226126,226127,226128,226129,226130,226131,226132,226149,226150,226151,226152,226153,226154,226197,226237,226238,232101,235213,235214,235562,235563,236180,236181,236182,236555,236641,236642,236643,238118,238119,238148,238694,238709,238818,95334,89895,89896,239549,239550,239551,256152,256154,256156,256158,256161,256447,256459,256461,256467,256470,256472,260810,260811,260821,260822,260823,260824,260825,260826,260832,260833,260834,260835,260836,260837,260838,260839,260840,260841,260842,260843,260844,260845,260846,260847,260848,260849,260850,260851,260852,260853,260854,260855,260856,262863,263910,263917,263918,265622,266292,266303,266305,266309,266312,266314,269813,269840,269841,269842,269843,269844,269846,269847,269848,269850,269851,269852,269853,269854,269856,270785,67443,288030,291603,291601,292288,294246,294250,294251,294252,294253,297675,297725,297812,299123,299124,299125,299126,299127,299128,299129,299130,299131,299132,299133,299134,299135,299136,299137,299138,299139,299140,299141,299142,299143,299144,299145,299146,299147,299148,299149,299150,299151,299152,299153,299154,299155,299156,299716,299726,299729,299737,299738,299739,299855,299865,299867,299870,299871,299872,300031,300041,300043,300046,300047,300048,303739,303741,303743,303744,303745,303835,303840,303842,304424,304429,304550,67446,64453,89901) and pd.products_name <> '' and p.manufacturers_id in (180?osCsid=ekqsvhi7pshadnrmohauc80svm) ORDER BY p.logistics_key DESC
[TEP STOP]