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 (14148, 14149, 14150, 14151, 14152, 14153, 14154, 1232, 1233, 1234, 1235, 1236, 1237, 48027, 48028, 48029, 53983, 53984, 56081, 56082, 56083, 56084, 56085, 56086, 71764, 1228, 1229, 1230, 1231, 1238, 1239, 1240, 1241, 1242, 1243, 1244, 1245, 1246, 1247, 1248, 1249, 1250, 1251, 1252, 1253, 1254, 1255, 1256, 1257, 1258, 1259, 1260, 1261, 1262, 1263, 1264, 1265, 1266, 1267, 14614, 16977, 16978, 16980, 16981, 16982, 16983, 16984, 16985, 16986, 16987, 17316, 20383, 20384, 20385, 20386, 20387, 20704, 20705, 20706, 20707, 20708, 20712, 20713, 20714, 20715, 20716, 20717, 20718, 20719, 20720, 24963, 24964, 24965, 24966, 25109, 25110, 25111, 25112, 25113, 25175, 25243, 25244, 25245, 25402, 26193, 26415, 27810, 32876, 32877, 33029, 33030, 34579, 34897, 40731, 40732, 40831, 40863, 40864, 43199, 43562, 45001, 45002, 45003, 45004, 45005, 45265, 45266, 45438, 45439, 45440, 45887, 45888, 45889, 45920, 45921, 46030, 46147, 46148, 46149, 46209, 47852, 49121, 49122, 51728, 54059, 54656, 54936, 55072, 56079, 56080, 56263, 56264, 56265, 56266, 56267, 56268, 57516, 57517, 58622, 58860, 58861, 58862, 59000, 59001, 59002, 59003, 59004, 59005, 59006, 59007, 64390, 64391, 64478, 64479, 64480, 64481, 64482, 71765, 71766, 71767, 71768, 1218, 1219, 1220, 1221, 1222, 1223, 1224, 1225, 1226, 1227, 16326, 16327, 16328, 16332, 16333, 21452, 21454, 21455, 21457, 24961, 24962, 25059, 25060, 25071, 25072, 25176, 25356, 25357, 32819, 33019, 33020, 33028, 38466, 38467, 40700, 40701, 40702, 40703, 40704, 41655, 42575, 42576, 42577, 42578, 42579, 44382, 45844, 1209, 1210, 1211, 1214, 1216, 1217, 32816, 32817, 32818, 45907, 45909, 45911, 45912, 45913, 45914, 45974, 45975, 45976, 45977, 45978, 63136, 63137, 63138, 63139, 63140, 63141, 63142, 63143, 1193, 1194, 1195, 1196, 18238, 18240, 18241, 21409, 34893, 34894, 34895, 34896, 43879, 43880, 43881, 43882, 43883, 43884, 43885, 46644, 46645, 46646, 46647, 23730, 23731, 1166, 1167, 1168, 1169, 1170, 1171, 1172, 1173, 1174, 1175, 1176, 1177, 1178, 1179, 1180, 1181, 1182, 1183, 1184, 1185, 1186, 1187, 1188, 1189, 1190, 1269, 1270, 2863, 2864, 2865, 14609, 14610, 14611, 14612, 14613, 16988, 16989, 16990, 16991, 20459, 21751, 21752, 21753, 21754, 23775, 23830, 24806, 24807, 24808, 24809, 26191, 26192, 26325, 26326, 26327, 26328, 26329, 26330, 26417, 26790, 26791, 26873, 27817, 27818, 33022, 33023, 33024, 33025, 33026, 33027, 39144, 42095, 42203, 42369, 42388, 42389, 42390, 42391, 43620, 43621, 43622, 43623, 43625, 43627, 44025, 44026, 44027, 44028, 44029, 44030, 44031, 44032, 44956, 44957, 44958, 45006, 45007, 45008, 45099, 45149, 45151, 45152, 45153, 45154, 45155, 45156, 45409, 45410, 45413, 45821, 45822, 45823, 45824, 45825, 45898, 46046, 46052, 46260, 46515, 46516, 46517, 46518, 46519, 46520, 46550, 46551, 46552, 46553, 46554, 47327, 47328, 47329, 47330, 47331, 47332, 47333, 47334, 47684, 47685, 47764, 47765, 47766, 47767, 47831, 47832, 47833, 47834, 47835, 47853, 47861, 47862, 47863, 47939, 47940, 47941, 47942, 47943, 47944, 47972, 47973, 47974, 47975, 47976, 47977, 48382, 48529, 48530, 48531, 48556, 48557, 48558, 48559, 48560, 48561, 48562, 48563, 48564, 48565, 48566, 48567, 48568, 48569, 48570, 48571, 48572, 48719, 48720, 48721, 48722, 48723, 48724, 48725, 48726, 48727, 49085, 49242, 49243, 51648, 51649, 51650, 52403, 52404, 52405, 52406, 52596, 52597, 52598, 54099, 54100, 54101, 54102, 54203, 54329, 54330, 54331, 54332, 54333, 54334, 54335, 54336, 54337, 54338, 55011, 55012, 55013, 55258, 56087, 56466, 56467, 57281, 57282, 57283, 57284, 57584, 57585, 57586, 57587, 57588, 57589, 57590, 57591, 57592, 57593, 57594, 57595, 57619, 57621, 57622, 57971, 58669, 58670, 58671, 58672, 60898, 60899, 60900, 60901, 61315, 61316, 62079, 62080, 62081, 62082, 63144, 63145, 63146, 63147, 63148, 63149, 71756, 71757, 71758, 71759, 71760, 71761, 71762, 71763, 14045, 1198, 1199, 1200, 1201, 1202, 14136, 14137, 14138, 14139, 14140, 14141, 14142, 14143, 14144, 14145, 14146, 14147, 23767, 23768, 19661, 19662, 20447, 20448, 20449, 20451, 20452, 20453, 20454, 20455, 20456, 20457, 20458, 23769, 23771, 23772, 25838, 25839, 25840, 25841, 25842, 25843, 25844, 25845, 25846, 25847, 26416, 26598, 26869, 26870, 26871, 26872, 26874, 36641, 36671, 36672, 45276, 45277, 45278, 45279, 45280, 45281, 45282, 45283, 45284, 45362, 45377, 45378, 45457, 45539, 45540, 45541, 45542, 47854, 47855, 47856, 47857, 47858, 47859, 47860, 48846, 48855, 48872, 48873, 48874, 48875, 48876, 48877, 48878, 48881, 51579, 51580, 52591, 52592, 52593, 52594, 52915, 52916, 52917, 52918, 52919, 1203, 1205, 1206, 1207, 1208, 1212, 1213, 1215, 8141, 8146, 8156, 21446, 21447, 21613, 21614, 21623, 21624, 23732, 23733, 26272, 26273, 26274, 26331, 26332, 26333, 26334, 26335, 26336, 26337, 34575, 34576, 34577, 34578, 34669, 34670, 34671, 34672, 34673, 34855, 34856, 34866, 34867, 34868, 34869, 34889, 34890, 34891, 34892, 43130, 43131, 43133, 43135, 45228, 45229, 45230, 45231, 45232, 48554, 48555, 48573, 48574, 48576, 48577, 48578, 52408, 52409, 52410, 52411, 52412, 52413, 62110, 62111, 62112, 27823, 27824, 27826, 41631, 41632, 41633, 41635, 42099, 45227, 54661, 55069, 55070, 55224, 56071, 56072, 56073, 56074, 56075, 56076, 56077, 56078, 57848, 57849, 57850, 57851, 57852, 64483, 64484, 64485, 64486, 64487, 64488, 64489, 64490, 64491, 64492, 26599, 26600, 26601, 26602, 26603, 26604, 34580, 34581, 34582, 34955, 34956, 34957, 34958, 41589, 41590, 41591, 41592, 41593, 41654, 42184, 42580, 42581, 42582, 42583, 42584, 43190, 44454, 44457, 44458, 44459, 44460, 44461, 44462, 44463, 44464, 44465, 44467, 45157, 45158, 47336, 47337, 47339, 47340, 48728, 48729, 48730, 48731, 48732, 35109, 35110, 35111, 35112, 35113, 35127, 35128, 35129, 35130, 56060, 56061, 56062, 56063, 56064, 56065, 41854, 41857, 43791, 43792, 43793, 43794, 43795, 43796, 43797, 43798, 43799, 43808, 43809, 43810, 43811, 43812, 43813, 43814, 43815, 45207, 45208, 45209, 45210, 45211, 45212, 45213, 45218, 45219, 46222, 46223, 46224, 46225, 46226, 45220, 45222, 45223, 45224, 45225, 45226, 54657, 54658, 54659, 54660, 55159, 56066, 56068, 56069, 56070, 57822, 57823, 57824, 57825, 46236, 46237, 46350, 46351, 47968, 51515, 51516, 51517, 48532, 48533, 48534, 48535, 48536, 48537, 51126, 51652, 51653, 62072, 62073, 62074, 62075, 62076)]