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 (545, 546, 547, 548, 549, 550, 551, 552, 553, 554, 555, 556, 557, 558, 559, 560, 561, 562, 563, 564, 565, 566, 567, 568, 569, 570, 571, 572, 573, 574, 575, 576, 577, 578, 579, 580, 581, 582, 583, 625, 626, 1933, 2861, 14107, 14108, 16438, 16440, 16441, 16442, 16443, 20780, 21641, 21644, 23587, 23588, 23589, 25147, 25149, 25400, 26398, 26399, 26579, 26704, 26705, 26706, 26707, 35061, 35193, 41204, 42648, 43043, 43044, 43045, 43076, 43139, 43559, 43560, 43869, 43870, 43890, 44009, 44046, 44047, 44048, 44205, 44206, 44207, 44208, 44209, 44210, 44211, 44212, 44240, 44241, 44245, 44246, 44279, 44372, 44373, 44374, 44394, 44395, 44396, 44421, 44422, 44423, 44424, 44425, 44499, 44521, 44522, 44523, 44530, 44542, 44553, 44855, 44931, 45071, 45093, 45150, 45318, 45327, 45328, 45329, 45535, 45739, 45740, 45741, 45943, 45944, 45945, 45946, 45992, 45993, 45994, 45995, 45996, 45997, 46008, 46017, 46018, 46019, 46020, 46021, 46062, 46063, 46107, 46108, 46233, 46472, 46473, 46586, 47762, 47808, 47809, 47920, 48331, 48359, 48360, 48361, 48362, 48383, 48406, 49112, 49113, 49470, 49471, 49472, 49473, 53414, 53743, 54125, 54655, 57087, 57442, 57666, 61711, 62219, 62869, 68242, 68243, 68244, 68317, 68489, 68490, 68491, 68492, 68493, 68494, 68495, 68669, 68670, 70428, 70429, 70430, 70431, 70432, 70434, 71722, 71723, 71724, 71725, 71726, 71727, 71728, 71729, 71730, 71731, 71732, 506, 507, 508, 509, 510, 511, 512, 513, 514, 515, 516, 517, 518, 519, 520, 521, 522, 25103, 25104, 25105, 25106, 46047, 46337, 46338, 46471, 527, 528, 529, 530, 531, 532, 533, 16919, 60790, 60791, 60792, 60793, 523, 524, 525, 526, 495, 496, 497, 498, 624, 628, 629, 14103, 14104, 16447, 16448, 16449, 20537, 20538, 20539, 20540, 20543, 20548, 20549, 26577, 26578, 26708, 26709, 26710, 26711, 27864, 27865, 27866, 27867, 32841, 32842, 32843, 40976, 40977, 42590, 42591, 42592, 42593, 43490, 43491, 43492, 43886, 43887, 43888, 43889, 44984, 45299, 45503, 45504, 45505, 45506, 45507, 48059, 48061, 48062, 48063, 48064, 48065, 48858, 48859, 48860, 48861, 53744, 53745, 53746, 55255, 55256, 55257, 61355, 61356, 61357, 61358, 61359, 499, 584, 585, 586, 587, 588, 589, 14629, 28024, 28025, 28026, 28027, 28028, 35034, 35058, 35059, 35060, 35071, 35072, 35073, 35074, 35075, 35077, 35078, 35079, 40729, 40730, 68247, 68248, 68249, 68250, 68251, 590, 591, 592, 593, 594, 595, 596, 597, 598, 599, 600, 601, 602, 603, 604, 605, 20802, 20806, 20807, 20808, 35206, 35208, 35209, 35210, 41794, 41795, 41796, 41797, 41798, 42194, 42195, 42196, 42197, 42199, 42200, 42201, 42330, 42331, 42332, 42333, 42334, 42335, 42336, 42337, 43922, 43923, 43924, 43925, 43937, 43938, 43939, 43940, 43941, 43942, 43943, 43944, 43945, 43946, 43947, 43948, 44740, 44741, 44742, 44743, 44744, 44745, 44746, 44747, 44748, 44985, 44986, 44987, 44988, 44989, 44990, 44991, 44992, 44993, 45045, 45046, 45047, 45628, 45630, 45631, 45632, 45633, 45634, 45635, 45727, 45728, 45729, 45730, 46031, 46032, 46033, 46034, 46035, 46036, 46037, 46038, 46039, 46040, 46041, 46042, 46043, 46044, 46045, 46264, 46265, 46266, 46267, 46268, 46352, 46353, 46354, 46355, 46356, 46371, 46372, 46373, 46374, 46375, 46376, 46395, 46397, 46398, 46512, 46513, 46514, 46600, 46601, 46602, 47820, 47821, 47822, 47919, 48495, 48496, 48497, 48498, 48499, 48791, 48792, 48793, 48904, 48905, 48991, 48992, 49191, 49241, 50530, 50531, 50532, 50857, 51556, 51557, 51645, 51646, 51647, 51708, 51786, 51788, 52399, 52400, 52401, 52582, 52583, 52584, 52585, 52586, 52587, 53411, 53412, 53413, 55017, 55018, 55019, 55099, 55100, 55101, 55102, 55103, 55105, 56052, 56053, 56054, 56055, 56515, 56516, 56517, 56518, 56519, 57506, 57508, 57509, 57510, 57511, 57512, 57513, 57514, 57515, 57960, 57961, 57962, 57965, 57966, 57967, 58255, 58256, 58257, 58258, 58369, 58370, 58371, 59016, 59017, 59198, 59199, 59200, 59201, 60778, 60779, 60784, 60785, 60788, 60789, 62712, 62713, 62714, 62715, 62716, 62717, 62870, 63625, 63626, 63627, 63628, 63629, 63630, 63631, 63632, 63633, 67710, 67711, 67712, 67713, 67820, 67821, 67868, 67869, 67870, 67871, 67872, 67873, 67981, 70417, 70419, 70420, 70421, 70422, 71718, 71719, 71720, 71721, 71737, 71738, 71739, 71740, 71741, 71743, 71744, 75076, 75077, 75078, 75079, 75080, 75081, 75082, 75083, 75084, 75085, 75086, 75087, 75088, 75089, 75090, 75091, 75092, 75093, 75094, 75095, 75096, 75097, 75098, 75099, 75100, 607, 608, 609, 610, 611, 612, 613, 614, 615, 616, 617, 618, 619, 620, 621, 622, 630, 631, 632, 633, 634, 635, 636, 637, 44427, 44428, 44429, 44430, 44431, 44432, 44434, 44732, 44734, 44735, 44736, 44737, 46343, 46345, 46346, 46347, 46348, 46480, 46481, 48712, 48713, 49474, 49475, 49582, 49583, 50835, 50836, 50837, 50838, 54558, 54560, 54561, 54720, 54721, 54737, 54738, 54915, 54916, 54917, 54932, 54933, 54935, 56329, 56330, 56331, 56332, 58234, 58235, 58236, 58237, 58239, 58240, 67392, 67393, 67394, 67395, 67396, 67397, 67398, 67399, 67400, 68318, 68319, 68320, 68322, 68323, 68324, 68325, 68326, 71749, 485, 486, 487, 488, 489, 490, 491, 492, 493, 47744, 47745, 47746, 47845, 47846, 482, 483, 484, 16451, 475, 476, 534, 535, 536, 537, 538, 539, 540, 541, 623, 1932, 477, 478, 479, 480, 481, 25836, 25837, 500, 501, 502, 503, 504, 505, 28018, 28019, 28020, 28021, 28022, 28023, 57936, 57937, 57938, 57939, 57940, 57941, 57942, 57943, 57944, 57945, 14018, 14019, 14020, 14021, 14022, 14023, 14024, 14025, 14026, 14027, 16918, 16921, 33012, 34668, 44259, 44260, 44261, 47760, 47761, 56154, 63298, 16911, 16914, 16915, 16916, 44981, 44982, 17355, 17356, 17357, 26311, 26312, 26313, 26314, 26783, 26859, 40615, 45572, 45643, 45742, 45743, 606, 627, 14105, 14106, 18778, 18779, 18784, 41207, 43891, 44453, 44525, 44527, 44529, 44863, 44864, 44994, 23450, 23451, 25174, 25241, 41652, 42442, 43818, 43820, 43949, 43950, 44111, 44139, 44375, 44518, 44828, 44862, 44911, 44927, 44928, 44929, 44930, 44947, 45048, 45096, 45262, 45263, 45264, 45915, 46064, 46122, 46234, 46259, 46308, 46310, 46587, 46590, 46603, 46604, 47802, 47816, 47817, 47818, 47819, 47823, 47824, 47825, 48346, 48347, 48348, 48349, 48350, 48351, 48352, 48353, 48354, 48363, 48364, 48365, 48366, 48367, 48921, 48922, 48923, 48924, 49223, 49224, 49225, 52468, 52588, 54098, 54992, 55016, 58997, 63997, 67982, 70424, 70425, 70426, 70427, 71734, 71736, 75073, 75074, 75075, 26572, 26573, 26574, 26575, 26576, 23795, 23796, 23797, 23798, 44435, 44436, 44437, 44438, 44439, 44440, 44444, 44678, 44679, 44680, 44681, 44682, 44683, 44684, 44685, 46221, 46326, 46327, 46328, 46329, 46330, 46331, 46332, 46333, 51789, 51790, 51791, 44856, 30165, 30167, 30168, 30169, 30177, 30178, 30180, 30183, 30185, 30189, 30190, 30194, 30195, 30196, 30197, 30199, 30200, 30201, 30204, 30205, 30206, 30207, 30208, 30209, 30210, 30211, 30212, 30213, 30214, 30215, 30216, 30217, 30219, 30221, 35115, 35116, 35117, 35118, 35119, 41983, 41984, 41985, 41986, 42640, 43736, 43860, 43861, 43862, 43863, 44218, 44219, 44220, 44221, 44222, 44223, 44224, 44226, 44227, 44228, 44229, 44230, 44231, 44232, 44233, 44234, 44235, 44237, 44238, 44239, 45094, 54069, 54070, 54071, 54072, 54073, 54074, 54075, 55015, 57454, 57947, 57948, 57949, 57950, 57953, 65827, 65829, 65830, 68327, 68328, 68330, 71745, 71746, 71747, 71748, 47811, 47812, 47813, 47814, 47815)]