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 (6092,10519,10962,11014,13552,13553,13554,13555,13556,13557,13558,13559,13560,13561,13562,13563,13564,14630,14631,19274,20939,22375,23102,25678,25679,25693,25701,25715,25728,25731,25733,25736,25737,25738,35826,64432,64436,77201,77613,79978,79999,80649,80650,82488,82489,82490,82498,82499,83031,84239,93090,93091,93092,93094,93095,93096,93503,93506,93507,93513,93514,93527,95985,96103,96837,100673,100752,100758,100759,100760,102647,102648,102649,102650,102768,111565,111566,122016,127009,127010,127287,144043,151497,157455,167267,186257,187153,187154,188157,188163,195275,195276,206514,208012,208013,208014,208015,212334,212426,212503,212504,212505,212506,212507,212508,212509,212510,212511,212512,212554,212555,212556,212557,212558,212559,212560,212561,212562,212563,212564,212565,212566,212567,212568,212569,212570,212571,212572,212573,212574,212575,213335,214599,214600,214601,214602,214607,214608,215308,221449,221450,221475,221476,221477,221478,222482,222809,225583,225584,225592,225595,125913,226225,226236,125909,125910,125912,226280,226281,226282,226283,226284,226397,226577,226578,226579,226580,226581,226582,226583,226584,226585,227273,227755,227756,229439,229440,229441,229442,229443,67595,232845,234965,235957,235958,77615,236949,65715,65716,65717,65718,65719,80648,240711,240712,240713,240714,240715,255973,255975,264026,264029,264095,265661,266282,266290,266542,291749,291754,291755,291756,291761,291762,291774,291775,292311,297734,299196,299205,299206,299207,299705,299710,299713,299845,299850,299853,300021,300026,300029,303824,304425,304427,305761,80651,80652,35825,308542) and pd.products_name <> '' and p.manufacturers_id in (1140?osCsid=pqq221gg5cbua2vaptdp11rag7) ORDER BY p.logistics_key DESC
[TEP STOP]