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 (5009,5010,8069,8070,8073,8075,8076,8078,8081,8083,8107,8108,8109,8110,8111,8112,8113,8114,13565,13566,13567,14087,14088,14100,14101,14104,14105,14107,14108,14113,21915,22485,22514,22540,22541,22825,22826,22827,22828,22829,22830,22831,22832,22833,22834,22865,23013,23016,28486,28489,28530,28531,28532,28533,28534,28535,28536,28538,28539,28540,28541,28542,28543,28544,28546,28547,28548,28549,28550,28553,28554,28555,28556,28557,28558,28559,28561,28562,28563,28565,28567,28568,28569,28570,28571,28572,28573,28574,40128,40130,40132,40133,40134,40135,40136,40137,40138,40139,40140,40141,40142,66831,67408,67409,67410,67411,67514,67515,95094,95095,95096,95097,95098,95099,95100,95395,95396,95397,96201,96205,96206,96207,101982,101983,101984,101985,101986,101987,101988,101989,103952,103953,110901,110902,110903,110904,110905,110906,127458,127459,127460,127462,127463,128032,128572,128734,128781,128864,129480,129481,129482,129483,131100,131103,131104,131105,131106,131862,131863,131864,132284,132570,132571,132593,134986,135260,135261,135634,135635,136941,151500,151503,151504,151505,151506,151507,151508,151619,151620,151621,151622,166525,166526,166847,166848,166849,166850,166851,166852,166853,166854,166855,166856,166857,166858,166859,166869,166870,166871,166872,166873,166874,166875,166876,166877,166878,166879,166880,166881,166882,166883,166884,166885,166886,166887,166888,166889,166890,166891,166892,177047,177049,177050,186269,186271,186275,186402,186403,187161,187163,187353,187354,188148,188167,188742,208021,208022,208023,208024,208025,208425,215303,220801,224483,224484,224485,224486,224487,224623,224624,224625,224626,224627,224628,224629,224630,224631,224632,224633,224634,224635,224636,224637,224638,224639,224640,224641,224642,224643,224668,224669,224670,224671,224672,224673,224674,224807,224839,224924,224925,224926,224927,224928,224929,226117,226118,226119,226120,226121,226122,226123,226124,226125,226177,226178,226179,226180,226181,226182,226183,226184,226185,126543,126544,126545,126546,126547,127466,127467,127468,127469,226266,226267,226268,226269,226270,226271,226272,226273,226274,226275,226276,226277,67520,67521,127456,127457,128801,128804,128805,11370,226864,226873,226874,226875,226876,226877,226878,226879,226880,226881,226882,226883,226884,226885,227424,227469,227477,227478,227632,227633,227634,227635,227636,227637,227638,227639,227640,227641,227642,227643,227644,227645,227646,227647,227648,227649,227650,227651,227652,227653,227654,227655,227656,227657,227658,227659,227660,227661,227662,227663,227664,227665,227666,227667,227668,227669,227670,227671,227672,227673,227674,227675,227676,227677,227678,227679,227680,227681,227682,227683,227684,227685,227686,227687,227688,227689,227690,227691,227692,227693,227694,227695,227696,227697,227698,227699,227700,227701,227702,227703,227704,227705,227706,227707,227708,227709,227710,227711,227712,227713,227714,227715,227716,227717,227718,227719,227720,227721,227722,227723,227724,227725,227726,227727,227728,227729,227730,227731,227732,227733,227734,227735,227736,227737,227738,227739,227740,227741,227742,227743,227744,227745,227746,227747,227748,234927,234928,234929,234930,234931,234932,234933,234934,234935,234936,235181,235182,235183,235184,235185,235186,236678,236679,236680,236681,236682,236941,236942,40129,65539,65540,65541,65542,65543,238138,111382,111384,238364,28483,28487,28488,28522,28551,28485,64518,28484,64517,256759,256760,256761,256762,256763,256764,256765,256766,256767,260128,260129,260130,262617,262640,262641,262642,262795,262851,266223,266231,266298,266299,266307,269228,269229,269230,269231,269263,269265,269266,269267,269268,269269,269270,269271,269272,269273,269274,269275,269276,269278,269279,269280,269281,269282,269283,269284,269292,269293,269295,269297,269318,269340,269341,269342,269344,269345,269346,269347,269351,269352,67513,297805,297806,237259,299422,299423,299424,299425,299426,299427,299428,299429,299430,299431,299432,299433,299434,299435,299436,299693,299700,299721,299722,299732,299833,299840,299860,299861,299868,300009,300016,300036,300037,300044,301483,301491,301492,301493,301494,301495,301496,301497,301498,301499,301500,301501,301502,301503,301504,301505,301506,301507,301508,301509,301510,301511,301512,301513,301514,301515,301516,301517,301518,301519,301520,301521,301522,301523,301524,301525,301526,301527,301528,301529,301530,301531,301532,301533,301534,301535,301536,301537,301538,301539,301540,301541,301542,301543,301544,301545,301547,301548,301549,301550,301551,301552,301553,301554,301555,301556,302188,302189,302190,302191,302192,302193,302210,302211,302212,302213,302214,302215,302216,302217,302218,302219,302220,302221,302222,302223,302224,302225,302226,302227,302228,302229,302230,302231,302232,302233,302234,302235,302236,302237,302238,302239,302240,302241,302242,302243,302244,302245,302246,302247,302248,302249,302250,302251,303838,304217,304221,28491,305728,305729,305730,305731,305732,305733,305735,305736,305737,305738,305739,305740,305741,305742,305743,305744,305745,305734,14112,67710,10881,22484,28490,67522) and pd.products_name <> '' and p.manufacturers_id in (3346?osCsid=47qm5b47rcij3l17cuhbm45m63) ORDER BY p.logistics_key DESC
[TEP STOP]