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 (6031,6032,6057,6062,13320,13430,13431,19161,21876,21877,25795,25796,25797,25798,25799,25800,25803,25804,25805,25807,25809,37631,37648,37649,37651,64439,64440,67859,70711,71437,84262,84263,84264,84265,84266,84267,84269,84270,84271,84272,84274,84275,84276,84277,84279,84280,84281,84282,84283,84286,84287,84288,84289,84290,84291,84292,84293,84294,84295,84296,84297,84298,84299,84300,84301,84302,84303,84308,84309,84310,84311,84312,84313,84314,84315,84316,84317,84318,84319,84320,84321,84322,84323,84325,84326,84327,84328,84329,84331,84332,84334,84335,109978,110178,131523,131524,133240,133241,133242,133243,140782,141316,141317,141320,141321,151178,154271,154272,154273,154274,154275,154276,154277,154278,154279,154280,156407,156445,160033,160034,176976,176977,178438,178439,178440,178441,178442,178443,178444,178445,178507,178536,178585,185562,185854,185855,187183,187413,187414,187415,187416,187775,208203,208263,208264,208265,208424,209064,209312,209313,209314,209315,209316,209317,209318,209319,209320,210896,212371,212372,212373,212374,212375,212687,214151,220740,220741,222862,224863,226077,13432,226251,226252,226253,226254,226255,226256,226257,226258,226259,226260,226261,226262,226263,226264,25811,125329,226709,226710,227498,227499,227500,227501,227502,227503,227504,227505,227506,227507,227508,227509,141648,141649,230385,230386,235597,235598,235599,235600,235601,236648,237005,90061,111340,240183,240184,240185,240186,240187,240188,240257,252362,252363,252364,252365,252366,255951,256084,256151,256264,256985,256986,256987,256988,257284,257285,259795,259796,261063,261064,261065,261066,261067,261068,261069,261070,261071,261072,261073,261074,261075,261076,261077,261078,261079,261080,261081,261082,261083,261084,261087,261088,261090,262301,262361,262558,262778,262779,262780,262782,262804,262832,262865,266069,288279,288281,291021,291415,291416,291417,291418,297663,297686,299197,299198,299199,299200,299204,299966,299968,300129,300130,301633,301634,301635,301636,301637,301638,301639,303389,303390,303452,303453,303738,303777,304479,304481,304482,304490,304492,304493,24947,24948,71434,82265,84284,96491,125330,128731,135290,167094) and pd.products_name <> '' and p.manufacturers_id in (222?osCsid=vov2ia348tbvbo7mrik852t9c0) ORDER BY p.logistics_key DESC
[TEP STOP]