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 ('2049','562','2631','274','658','2096','2633','2634','2635','2636','2637','2638','2639','2640','2632','328','414','415','458','464','762','1672','1698','2641','135','1053','2967','3276','3277','2968','2969','3278','3279','2970','1054','2972','3281','3282','3283','3284','2974','2975','1055','2979','2980','1056','2976','3287','3288','3289','3290','2977','3292','3293','3294','3295','331','1671','340','1088','1089','1090','1091','1092','1093','1094','1373','4327','4328','4329','341','1095','1096','1097','1098','1099','1156','1520','548','88','2995','2996','2997','2998','2999','3000','992','3001','3002','3003','3004','3005','3006','1100','4317','4318','1101','4315','4316','1102','1103','4319','4320','1104','4325','4326','4267','4321','4323','4324','4322') order by products_ordered DESC, products_viewed DESC, pd.products_name ASC limit 180, 36