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 (113866,113916,118579,118580,118586,118587,127863,132599,134220,136943,138804,138825,141252,141510,149258,151644,151645,151646,151647,151648,151650,151651,151655,151656,151658,151659,151660,158433,158620,175339,175340,176481,176482,177116,189979,189980,189981,192565,192566,192568,192569,192570,208404,208405,208406,208407,213290,214247,214248,136770,122777,141251,122834,131909,122778,240544,241434,241589,241732,241733,136942,151649,151652,138486,151653,138480,138483,138784,138785,138786,138787,138788,138789,148441,148443,148444,245088,245140,245142,245143,245144,245299,245306,157664,155725,155727,155730,159074,133938,138783,148442,151654,151657,138479,150326,152383,250272,250273,250274,138791,138792,138793,138794,138795,176483,262475,262476,262477,262478,262479,262480,262481,262482,27493,286452,124813,304048,304049,27492,113910,123364,127919,127937,131916) and pd.products_name <> '' and p.manufacturers_id in (26?osCsid=dg3epn9i1r4oqjt2mrai390tau) ORDER BY p.logistics_key DESC
[TEP STOP]