1 Can't create/write to file '/tmp/#sql_208e_1.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 (289, 290, 291, 292, 293, 294, 295, 296, 297, 298, 299, 300, 301, 302, 303, 304, 305, 306, 307, 308, 309, 310, 311, 312, 313, 314, 315, 316, 317, 318, 319, 320, 321, 322, 323, 324, 325, 326, 16665, 16667, 16668, 20533, 24840, 25496, 26841, 26912, 26913, 28047, 28677, 28678, 28679, 28680, 38455, 38459, 38460, 41194, 41587, 41884, 42209, 42210, 42416, 42417, 43692, 43693, 43694, 43695, 43696, 43857, 43858, 43859, 43979, 43981, 43984, 44001, 44002, 44003, 44004, 44005, 44007, 44866, 44867, 44868, 44901, 44902, 44903, 44904, 44905, 44945, 45066, 45067, 45068, 45069, 45070, 45324, 45325, 45326, 45723, 45872, 45873, 45874, 48094, 48095, 48096, 49477, 51112, 51654, 51820, 51892, 56139, 56140, 56141, 57092, 57404, 58717, 58791, 58792, 58793, 59037, 64426, 64427, 64428, 64429, 64430, 64431, 64432, 72024)]