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 (327, 328, 329, 330, 331, 332, 333, 334, 335, 336, 337, 338, 339, 340, 341, 342, 343, 344, 345, 346, 347, 348, 349, 350, 351, 352, 353, 354, 355, 356, 357, 358, 359, 360, 361, 362, 363, 364, 365, 366, 367, 368, 369, 370, 371, 372, 373, 374, 375, 376, 377, 378, 379, 380, 381, 382, 383, 384, 385, 386, 387, 388, 389, 390, 391, 392, 393, 394, 395, 396, 397, 398, 399, 14087, 14088, 14089, 14090, 14091, 14092, 14093, 14094, 14095, 14096, 14097, 14098, 14099, 14100, 14101, 16671, 16672, 16673, 18242, 18243, 18244, 18245, 18246, 18247, 18277, 18477, 18774, 18775, 18776, 20154, 23092, 23093, 23094, 23095, 23096, 23097, 23098, 23099, 23784, 23785, 23786, 23787, 23788, 23789, 25497, 25498, 26306, 26307, 28681, 28682, 28684, 28685, 28686, 28687, 28688, 28689, 31907, 33422, 34595, 34596, 34597, 35030, 35031, 35032, 36903, 36905, 36906, 36907, 37089, 37090, 38462, 38463, 38464, 38465, 39861, 39862, 39863, 39864, 39865, 39866, 39867, 39868, 39869, 39870, 39871, 39872, 40331, 40332, 40333, 40334, 40348, 40349, 41446, 41447, 41448, 41449, 41450, 41451, 41452, 41454, 41455, 41456, 41457, 41458, 41459, 41460, 41461, 41462, 41467, 41468, 41469, 41470, 41471, 41472, 41473, 41477, 41478, 41479, 41480, 41481, 41482, 41483, 41662, 41663, 41664, 42309, 42315, 42316, 42317, 42443, 42444, 42464, 42465, 42466, 42467, 42468, 42469, 42470, 42569, 42661, 42712, 42713, 42714, 42715, 42716, 42717, 43323, 43548, 43551, 43552, 43553, 43554, 43676, 43677, 43678, 43774, 43775, 43776, 43778, 43779, 43782, 43783, 44484, 44485, 44486, 44487, 44933, 44934, 44935, 44936, 45058, 45059, 45525, 45536, 45724, 45826, 45827, 45902, 45903, 45905, 45906, 46089, 46090, 46377, 46378, 46598, 46599, 47705, 47706, 47750, 47751, 47752, 47753, 47754, 47755, 48048, 48091, 48092, 48093, 48648, 48649, 48650, 48651, 48652, 48653, 48654, 48775, 48776, 48777, 48856, 48857, 49045, 49106, 49107, 49108, 49109, 49110, 49111, 49227, 51561, 52191, 52220, 52221, 52222, 52223, 52224, 55002, 55003, 55004, 55005, 55038, 55114, 55268, 56522, 56539, 56540, 56580, 56582, 56905, 56906, 56907, 57830, 58247, 58248, 58249, 58718, 58719, 58720, 58722, 58723, 58724, 58998, 59083, 59084, 59175, 59176, 59177, 60804, 60805, 60806, 62125, 62597, 62598, 62599, 62601, 62602, 62603, 62604, 62781, 62975, 63224, 63225, 63226, 63227, 63228, 63229, 63230, 63231, 63232, 63264, 63265, 63266, 63297, 64415, 64416, 64417, 64418, 64419, 64497, 64498, 64499, 64507, 64508, 64509, 64590, 64591, 64592, 64594, 64595, 64596, 64597, 64598, 64599, 67180, 67181, 67182, 67183, 67184, 67791, 67792, 67793, 67794, 70482, 70483, 70484, 70485, 70486, 71936, 71937, 71938, 71940, 71941, 71942, 71943, 71944, 71945, 72009, 72010, 72011, 72012, 72013, 72014, 72015)]