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 (12842,12843,12845,12847,13573,13580,13585,13586,13587,13590,13592,13594,13599,13604,13605,13609,13610,13611,13615,13619,13624,13639,13640,13642,13646,13647,13648,13653,29718,29719,29721,29722,29723,29724,29725,29726,29727,29749,29813,29816,29817,29845,29849,29850,29852,37687,37690,37693,37697,37711,67673,67675,67677,67679,67680,141702,141703,141711,141714,141715,142275,142278,142284,155111,159274,159275,159276,165751,165752,165753,165754,165755,165756,165757,177517,177518,177519,177520,177521,177522,177523,177524,177525,177526,186245,186246,186247,186248,215334,221464,221465,222821,222822,222823,222824,222825,222826,222827,222828,222829,222830,222831,222832,222833,222834,222998,222999,223000,223001,223002,223003,223004,223005,223006,223007,223008,223009,223010,223011,223012,223013,223014,223015,223016,223017,223018,223019,223020,223021,223022,224461,224464,224515,224536,224666,224683,224684,224685,224846,224847,224939,224940,224941,224990,224991,224992,224993,224994,224995,224996,224997,224998,224999,225000,225001,225002,225003,225004,225005,226093,226189,226190,226191,126046,226308,226309,226310,226311,226829,226830,226831,226832,226848,226849,226852,226853,226854,226855,226856,226857,226858,226859,226861,226862,226919,227789,227790,227791,227792,227793,227794,227820,227821,227822,227823,227824,227825,227826,227827,227828,227829,227830,227831,227832,227833,227834,227835,227836,227837,227838,227839,227840,227841,227842,227843,227844,227845,13591,13595,13616,228670,228671,228677,228678,228679,228680,228681,228682,161036,235154,235155,235156,235157,235158,235197,235198,235650,235651,238532,238533,238657,239500,239501,240408,252422,252423,252424,252425,91114,91107,91108,91117,91121,287461,287462,287463,287464,287465,287466,287467,175374,175375,175373,175376,13601,128793,29751,29754,29854,29738) and pd.products_name <> '' and p.manufacturers_id in (2577?osCsid=qib2pn6ddvb32gcptih849hi0s) ORDER BY p.logistics_key DESC
[TEP STOP]