1 Can't create/write to file '/tmp/#sql_208e_0.MYI' (Errcode: 28 - No space left on device)
in:
[select distinct p.products_id, p.products_type, p.master_categories_id, p.manufacturers_id, p.products_price, p.products_tax_class_id, pd.products_description, IF(s.status = 1, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status =1, s.specials_new_products_price, p.products_price) as final_price, p.products_sort_order, p.product_is_call, p.product_is_always_free_shipping, p.products_qty_box_status, f.status as featured_status, s.status as special_status from products_description pd, products p left join manufacturers m on p.manufacturers_id = m.manufacturers_id, products_to_categories p2c left join specials s on p2c.products_id = s.products_id left join featured f on p2c.products_id = f.products_id where p.products_status = 1 and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = '1' and p.products_id in (2206, 2207, 2208, 2209, 2210, 2211, 2212, 2213, 2214, 2215, 2216, 2217, 2218, 2219, 2220, 2221, 2222, 2223, 2224, 2225, 2226, 2227, 2228, 2229, 2272, 14662, 16566, 16567, 17126, 35732, 35733, 41962, 42472, 42473, 42474, 42475, 42538, 42539, 42540, 42541, 42659, 42660, 43821, 44280, 45509, 45510, 45511, 45512, 45616, 45617, 45618, 45619, 45620, 45923, 46075, 46078, 46081, 46082, 46083, 46084, 46085, 46086, 46087, 46088, 46097, 46098, 46100, 46101, 46253, 46254, 46255, 46400, 46401, 46402, 47969, 47970, 47971, 47981, 47982, 47983, 47984, 47985, 47986, 47987, 47988, 48050, 48051, 48052, 48053, 48054, 48055, 48056, 48057, 48086, 48087, 48089, 48090, 48152, 48608, 48609, 48610, 48611, 48612, 48613, 48614, 48615, 49255, 49256, 49257, 52428, 52429, 52430, 53764, 53765, 53766, 53767, 54349, 54350, 54353, 55006, 55008, 55085, 55086, 55087, 55088, 55181, 55182, 55183, 55184, 56322, 56339, 56853, 56896, 57091, 57608, 57609, 57610, 57611, 57612, 59119, 59120, 64006, 64007, 64008, 64009, 67714, 67715, 67716, 71847)]