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 (1721,5015,11584,12098,12105,12964,12967,12968,12969,12970,20206,23925,23930,23931,23963,23964,23965,23967,23968,23971,24013,24014,24018,24062,24065,24110,24113,24117,24230,24279,24280,24283,24284,24285,24286,24287,24288,24289,24290,24291,24292,24293,24294,24295,24318,24319,24320,24321,24322,24323,24324,24325,24326,24327,24328,24329,24330,24331,24332,24335,24354,24355,24356,24357,24358,39061,64287,65027,65499,65500,65501,71491,71492,80151,80344,84036,96290,96391,97709,97711,107301,109125,109583,110026,125386,126584,126585,126586,126587,126588,126589,126590,126990,135262,135625,135626,135627,135629,135630,135687,135771,137032,137033,137034,140278,140930,140931,141211,141694,141695,141696,152049,152050,154491,155107,158839,159993,159995,167060,175554,177134,177582,177583,177601,177735,177794,177969,186424,186425,186426,186427,186428,187015,187267,188168,207232,207246,207969,208651,208652,208653,208888,208889,208890,208891,213441,213442,213517,213518,213519,213520,213521,213522,213523,213609,214858,215298,216540,216541,223607,223608,223733,223734,223735,223736,223737,223738,223739,223740,223741,223742,223743,223744,223745,223757,223758,223759,223760,223761,223762,223763,223764,223765,223766,223767,223778,224012,224013,224014,224015,224359,224360,224361,224362,224363,224364,224365,224366,224367,224368,225714,225715,225716,225811,225812,225813,225814,225815,226087,226088,226089,226723,226724,123192,226780,226781,227416,227434,227583,227584,227757,228672,228673,228674,228675,79502,79645,232443,235067,235326,252323,253149,253153,253280,253288,253293,253294,253295,254274,254317,254331,254332,254335,254336,254344,254345,254350,254359,254360,254361,254368,254369,254370,254376,254378,254383,254384,254385,254389,254391,254398,254404,254406,254424,254425,254436,254447,254450,254458,254461,254466,256205,256206,256207,256218,256226,256227,256312,257768,257771,257773,257786,257787,258674,258678,258679,258695,258696,258697,258698,258699,258700,258701,258702,258703,258704,258705,258706,258707,258708,258709,258710,258711,258712,258713,258714,258715,258716,258717,258718,258719,258720,258721,258722,258723,258724,258725,258726,258727,258728,258729,258730,258731,258732,258733,258734,258735,258736,258737,258738,258739,258740,258741,258742,258743,258744,258745,258746,258747,258748,258749,258750,258751,258752,258753,258754,261731,261732,261733,261734,261735,261736,261737,261738,261739,261740,261741,261742,261743,261744,261745,261746,261747,261748,261749,261758,261759,261760,261761,261762,261763,261764,261765,261766,261767,261768,261769,261790,261814,261815,261816,261817,261818,261819,261820,261821,261829,261830,261831,261832,261833,261834,261835,261836,261837,261838,261839,261840,261841,261842,261843,261844,261845,261846,261847,261848,261849,261850,261851,261852,261853,261854,261855,261856,261857,261858,261859,261860,261861,261874,261875,261876,261877,261878,261879,261880,261881,261882,261883,261884,261885,261886,261887,261888,261889,261890,261891,261892,261893,261894,261895,261896,261897,261898,261899,261900,261901,261902,261903,261904,261909,261910,261911,261912,261913,261914,261915,261917,261918,261919,261920,261921,261922,261924,261925,261926,261927,261928,261929,261930,261931,261932,261933,261934,261935,261936,261937,261938,261939,261940,261941,261942,261943,261944,261945,261946,261954,261955,261956,261957,261958,261959,261960,261961,261962,261963,261964,261965,132183,132184,262045,262046,262047,262694,263958,263964,264032,207338,265511,265512,265513,265514,265899,266129,126583,126592,126582,126591,130803,286737,286738,298469,298722,298744,299054,299055,299392,299393,299394,299395,299396,299397,299398,299399,299400,299409,299411,299412,299413,299414,299415,299416,299417,299418,299419,299420,299421,299444,299597,299672,299988,301934,301935,301936,301939,301940,301941,301951,301955,301984,301986,301989,301993,301995,302003,302004,302007,302008,302009,302010,302011,303286,303763,303766,304643,306043,125588,23924,23974,38543,151704,307977,24114,308557,308558,308584) and pd.products_name <> '' and p.manufacturers_id in (2546?osCsid=9jc52kqurvrrthd5f2rjlj7fc9) ORDER BY p.logistics_key DESC
[TEP STOP]