1 - Can't create/write to file '/tmp/#sql_19b3_0.MYI' (Errcode: 28)
select p.sold_in_bundle_only, p.products_ordered, p.products_image, pd.products_name, m.manufacturers_name, p.products_id, p.products_model, pd.products_description, p.products_weight, p.manufacturers_id, p.products_price, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price, p.tukkuhinta from products_description pd, products p left join manufacturers m on p.manufacturers_id = m.manufacturers_id left join specials s on p.products_id = s.products_id, products_to_categories p2c where p.products_status = '1' and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = '3' and p2c.categories_id IN ('2030','2925','764','2806','2807','2809','1144','3800','3801','3802','3803','4280','2926','2927','2928','2929','2930','2931','2932','53','2811','2812','2813','2814','2815','2816','3617','2924','3622','3623','173','74','81','456','457','2943','2944','2945','2946','2947','2948','2619','2955','2956','2957','2958','2942','3179','3596','2923','130','1125','764','2806','2807','2809','176','2914','2915','2916','2917','2918','2919','4334','4345','177','279','2949','2950','2951','2952','2953','2954') order by products_ordered DESC, products_viewed DESC, pd.products_name ASC limit 0, 36