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 (55665, 55666, 55667, 55668, 55669, 55670, 55671, 55672, 55673, 55674, 55675, 55677, 55678, 55679, 55680, 55681, 55682, 55684, 55685, 55686, 55687, 55688, 55689, 55690, 55691, 55692, 55693, 55695, 55765, 55766, 55767, 55769, 55770, 55771, 55772, 55773, 55774, 55775, 55776, 55777, 55778, 55779, 55780, 55781, 55782, 55783, 55784, 55785, 55786, 55787, 55788, 55790, 55791, 55792, 55793, 55794, 55795, 55796, 55797, 55798, 55799, 55801, 55802, 55803, 55804, 55805, 55806, 55807, 55808, 55809, 55812, 55813, 55814, 55815, 55816, 55817, 55818, 55819, 55820, 55821, 55823, 55824, 55825, 55826, 55827, 55828, 55829, 55830, 55831, 55833, 55834, 55835, 55836, 55837, 55838, 55839, 55840, 55841, 55844, 55845, 55846, 55847, 55848, 55849, 55850, 55851, 55852, 55855, 55856, 55857, 55858, 58148, 58149, 58150, 59305, 59306, 59307, 59308, 59309, 59310, 59311, 59312, 59313, 59314, 59316, 59317, 59318, 59319, 59320, 59321, 59322, 65035, 65036, 65037, 65040, 65041, 65042, 65451, 65452, 65565, 65566, 65567, 65569, 65570, 65571, 65572, 65573, 65574, 65575, 65772, 65773, 65774, 65776, 65931, 65932, 65933, 65934, 65935, 65936, 65937, 65938, 65939, 65940, 65941, 65942, 65943, 65944, 65945, 65946, 65947, 65948, 65949, 65950, 65951, 65952, 65953, 65954, 65955, 65956, 65957, 65958, 65959, 65960, 65961, 65962, 65963, 66354, 66355, 66356, 66357, 66358, 66359, 66360, 66361, 66362, 66363, 66364, 66365, 66366, 66367, 66368, 66369, 66370, 66371, 66372, 66373, 66374, 66375, 66376, 66377, 66378, 66379, 66381, 66382, 66383, 66384, 66385, 66520, 66521, 66522, 66523, 66524, 66525, 66526, 66527, 66528, 66529, 66530, 66531, 66532, 66533, 66534, 66535, 66536, 66537, 66538, 66539, 66540, 66541, 66542, 66543, 66544, 66545, 66546, 66547, 66548, 66549, 66550, 66551, 66552, 66553, 66554, 66557, 66558, 66559, 66560, 66561, 66562, 66564, 66565, 66566, 66568, 67847, 67848, 67849, 67850, 67851, 67852, 67853, 67854, 67855, 67856, 67857, 67858, 67859, 67860, 67861, 67862, 67863, 67864, 67865, 67866, 67867, 67919, 67920, 67921, 67922, 67923, 67924, 67925, 68298, 68299, 68300, 68301, 68302, 68303, 68304, 68305, 68306, 68307, 68308, 68309, 68310, 68436, 68437, 68438, 68439, 68440, 68441, 68442, 68443, 68444, 68445, 68446, 68447, 68448, 68565, 68566, 68567, 68568, 68569, 68571, 68572, 68574, 68575, 68576, 68577, 68579, 68580, 71104, 71105, 71106, 72333, 72334, 72335, 72336, 72337, 72338, 72339, 72340, 72341, 72342, 72343, 72344, 72345, 72346, 72347, 72348, 72349, 72350, 72351, 72352, 72353, 72354, 72355, 72356, 72357, 72358, 72359, 72360, 72361, 72362, 72363, 72364, 72365, 72366, 72367, 72368, 72369, 72370, 72371, 72372, 72373, 72374, 72375, 72376, 72377, 72379, 72380, 72381, 72382, 72383, 72384, 72385, 72386, 72387, 72388, 72389, 72390, 72391, 72392, 72393, 72394, 72395, 72396, 72397, 72398, 72399, 72400, 72401, 72402, 72403, 72404, 72405, 72406, 72407, 72408, 72410, 72411, 72412, 72413, 72414, 72415, 72416, 72417, 72418, 72419, 72420, 72421, 72422, 72423, 72424, 72425, 72426, 72427, 72428, 72429, 73063, 73064, 73066, 73067, 73069, 73071, 73073, 73074, 73075, 73783, 73784, 73785, 73786, 73787, 73788, 73789, 73790, 73791, 73792, 73793, 73794, 73795, 73796, 73797, 73798, 73799, 73800, 73801, 73802, 73803, 73804, 73805, 73806, 73807, 73808, 73809, 73810, 73811, 73813, 73814, 73815, 73929, 73930, 73931, 73935, 73936, 73937, 73938, 73939, 73940, 73941, 75488, 75489, 75490, 75491, 75492, 75493, 75494, 75495, 75496, 75497, 75498, 75499, 75500, 75501, 75502, 75503, 75504, 75505, 75506, 75507, 75508)]