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 ('2025','562','2631','274','658','2096','2633','2634','2635','2636','2637','2638','2639','2640','2632','328','414','415','458','464','762','1672','1698','2641','2572','1044','2573','3154','3155','3156','2574','277','3345','3347','3348','3349','3346','2881','2882','2883','2884','2885','2886','2034','88','2995','2996','2997','2998','2999','3000','992','3001','3002','3003','3004','3005','3006','3167','3168','3169','3170','3171','3172','3178','2035','1043','398','3334','3335','3336','3337','3338','3339','3340','3341','3342','399','3327','3328','3329','3330','3331','3332','3333','3343','3344','2642','488','3274','2650','3273','2649','2577','661','2981','2988','2989','2982','2983','2984','2985','2986','2987','126','2990','2991','2992','2993','2994','3298','459','3157','3158','3159','3160','3161','3162','3163','3164','3165','3166','3275','2965','2571','3869','3870','3871','3872','3873','3874','3875') order by products_ordered DESC, products_viewed DESC, pd.products_name ASC limit 180, 36