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 (23607,23610,23611,23612,23635,23637,23646,23647,23824,23825,23826,23827,23828,23849,28265,28266,28273,28274,28276,28279,28282,28290,34459,34460,37038,37039,37083,37097,37098,37100,37102,37112,37113,37114,37117,37118,38648,38649,38650,38655,38663,38664,38665,38668,58930,65710,66883,66884,66885,66886,66887,66888,66889,66890,66891,66892,66893,66894,66895,66896,77233,78073,78075,78076,78078,78080,78081,78083,78085,78086,78143,78144,78166,78170,78173,78176,78177,78179,78182,78183,78189,78190,78196,78201,78202,78204,80046,80048,80051,80053,80054,80055,80056,80058,80059,80060,80061,80062,80063,80064,80065,80066,80067,80068,80069,80070,80071,80072,80073,80074,80075,80076,80077,80078,82080,82081,84005,84008,84144,84145,95411,95413,95419,95421,95477,95478,95693,95694,95695,95696,95697,95698,95699,95700,95701,95702,95704,95705,95706,95707,95708,95709,95710,95711,95712,95713,95714,95715,95716,95717,95718,95719,95720,95721,95722,95723,95725,95726,95727,95728,95729,95730,95731,95732,95734,95736,95738,95739,95751,95752,95753,95755,95756,95757,95758,95759,95760,95761,95762,95763,95764,95766,95772,95774,95775,95776,95777,95778,95779,95780,95781,95782,95783,95784,95829,96032,96657,97649,97650,100418,101707,102636,111502,123429,123700,123701,124682,124700,124701,124703,124704,124706,124707,124708,124709,124710,124711,124712,125427,125428,125429,126854,131981,131982,134495,134499,135685,136006,137038,137039,147769,147772,147773,147774,147777,147779,147780,147782,147783,147786,147787,147788,151408,151997,151998,152007,152008,152011,152016,154783,156610,156611,156612,156613,156614,156615,156616,156617,156618,156619,156620,156621,156622,156623,156624,156625,156626,156627,156628,156629,156630,156631,156632,156633,156634,156635,156636,156637,156638,156639,156640,156641,156642,156643,156644,156645,156646,156647,156648,156649,156650,156651,156652,156653,156654,156655,156656,156657,156658,156659,156660,156661,156662,156663,156664,156665,156666,156667,156668,156669,156670,156671,156672,156673,156674,156675,156676,156677,156678,156679,156680,156681,156682,156683,156684,156685,156686,156687,156688,156689,157750,157751,157755,157981,158372,158373,158374,158375,158376,158377,158378,158379,158380,158381,158382,158383,158384,158385,158822,158824,158843,158845,159055,159056,159057,159058,159059,159060,159061,165641,165642,165643,165644,165652,165653,165654,167216,176565,176566,176567,176568,176569,176570,176571,176572,176573,176574,176575,176576,176577,176578,176579,176580,176581,176582,176583,176812,176813,176814,176815,176816,176817,176819,176821,176822,176824,176826,176827,176828,176829,176830,176831,176832,176834,176836,176837,177119,185543,185777,186432,186433,186434,186435,186436,186437,187484,187485,189865,207717,207739,207740,207741,208748,208749,208750,208751,208752,208753,208754,208755,208756,208757,208758,208759,208760,208761,208798,208799,208801,208802,208803,208804,208805,208806,208807,208808,208809,208810,208811,208812,208813,208814,208815,208816,208817,208818,208819,208820,208821,210676,210677,210678,210679,210680,210681,210682,210683,210684,210690,210691,210702,210703,210716,210717,210718,210719,210720,210721,210722,210723,210724,210725,210726,210727,210728,210729,210730,210731,210732,210733,210734,210735,210746,210747,210748,210749,210752,210753,210754,210755,210756,210757,210758,212275,212308,212309,212310,212311,212312,212313,212314,212524,212525,212526,212527,212528,213060,213169,213170,213173,213317,213318,213319,213530,213531,213605,213615,213616,214859,214860,214861,216061,216135,216145,216146,216147,216148,216149,216150,216151,216152,216165,216166,216167,216196,216201,216203,216225,216226,216278,216279,216280,216281,216282,216283,216284,216327,216328,216329,216330,216331,216332,216366,220307,220315,220317,220318,220320,220321,220324,225153,225156,225157,225158,225159,225160,225161,225162,226209,226210,226211,28264,152001,152014,228663,228664,228665,228666,228667,228668,228669,230500,234828,234829,234830,235200,235201,235202,235571,235572,235847,78248,102633,176842,236286,236287,236503,236508,236509,236510,236511,236512,236513,236514,236515,236516,236517,237094,158823,28297,65537,95455,102483,65708,37119,84003,23649,23650,23651,23660,23662,23666,28200,67943,67944,80052,103154,112138,135775,152012,187130,187131,240363,240364,240365,240366,240367,240368,240369,240370,240371,240372,240373,240374,240375,240376,240377,240378,240379,240380,240381,240382,240383,240384,240517,241735,241784,249241,249242,23613,102248,126834,126835,126837,126838,126840,126841,126842,126844,126845,126846,126848,126849,126850,126853,134502,136007,260227,126821,126822,126823,126824,126825,126826,126832,126833,262513,262572,262854,262855,270819,103140,103141,103142,103143,103144,112144,112146,112148,112154,112155,84002,112141,112142,112143,112145,112149,112150,112151,112152,112153,126830,126831,126816,126818,126820,126829,271187,28291,12991,15898,16962,18826,19831,23642,23643,38645,152026,100377,286627,23641,151996,292412,292413,292414,292415,298521,136008,301564,303765,304289,304291,304292,304293,304294,304295,304296,304297,304298,304299,101705,306046,151990,103152,307783,307827) and pd.products_name <> '' and p.manufacturers_id in (324?osCsid=4q64njge721k8mdg8eu54nihqb) ORDER BY p.logistics_key DESC
[TEP STOP]