Error (126) Incorrect key file for table '/tmp/#sql_6cd_0.MYI'; try to repair it<br>
SQL:<br>
<pre>SELECT ov.option_value, ov.option_type, ov.variantID, v.option_value variant_value 
 FROM `ss_product_options_values` ov 
 LEFT JOIN `ss_products_opt_val_variants` v ON ov.variantID = v.variantID
 LEFT JOIN ss_products p ON ov.productID = p.productID AND p.categoryID IN (82,151,427) AND p.firmID IN (216,249,252,191,66,325,270,65,44,111,401,321,414,362,345,140,338,78,194,440,370,375,461,451,410,441,333,39,379,344,285,307,90,48,335,402,400,106,339,110,187,425,224,378,460,464,468,483,488,481,476,446,404)
 WHERE 1
 AND ov.optionID = '111' AND p.productID IN (26861,21560,32578,13770,13769,13768,13767,13766,16350,462,6545,6960,1193,1194,1196,1199,1200,1202,1207,2279,2280,2281,2808,2811,2809,2810,2812,2813,2814,2815,2816,5312,6968,6991,7833,7834,7835,7836,1057,1060,1061,1062,1065,1070,1073,1080,1082,1084,1087,1088,1089,1090,1093,1094,1096,1142,1143,5313,5314,5315,5316,5317,6016,6017,6018,6023,6026,6027,6029,6030,6031,6817,6818,6978,6979,6980,6981,6982,7829,7830,7831,7832,7837,7865,10198,25974,10122,18190,10687,10688,10689,10690,10691,10692,10693,11294,11295,11296,11297,11298,11299,11300,11302,11984,11985,12075,12076,12077,13022,13023,13024,13025,13172,13789,13790,14201,14614,14615,14616,14706,14707,14708,14709,14731,14797,14798,14799,14800,14810,14808,14809,14811,14812,14813,14814,14815,14816,14817,14819,14820,14821,14822,14823,14824,14825,14827,14878,14879,15001,30164,15452,15453,15454,15455,15456,15457,15458,15459,15460,16336,16337,16338,16339,16340,16440,16441,16442,16443,16444,16445,16446,16447,16448,16449,16450,16451,16452,16453,16454,16455,16456,16457,16713,16714,16715,16716,16717,16935,16936,16937,16938,17180,17421,17422,17423,17424,17425,17426,17427,17428,17591,17592,17593,17594,17595,17874,17902,17903,17904,17905,18080,18409,18642,18279,18359,18360,18361,18362,18363,18364,18365,18366,18367,18368,18369,18370,18371,18372,18373,18374,18375,18376,18377,18378,18379,18380,18381,18382,18383,18384,18385,18386,18387,18456,18571,18636,18637,18640,18641,18643,18644,18645,19127,19465,19466,19467,19468,19469,19470,19471,19579,19580,19745,19746,19765,19766,19767,19815,19816,19817,19822,19876,19877,19878,19927,19926,19928,19998,20058,20117,32835,32836,32837,20831,20832,20897,20966,21190,21191,21192,21193,21194,21195,21196,21197,21198,21199,21200,21201,21202,21203,21204,21205,21206,21207,21208,21209,21210,21211,21212,21213,21214,21215,21216,21217,21218,21219,21220,21221,21222,21223,21224,21225,21226,21263,21274,21528,21529,21562,21563,21564,21565,21566,21848,21855,21887,21890,21889,21892,21987,21994,21995,21996,21997,21998,33263,22406,22407,22408,22409,22882,22791,22792,22793,22794,22991,22992,22993,23338,23340,23341,23342,23449,23450,23633,23634,33776,33777,23799,23801,23802,23803,23804,23805,23806,23807,23808,23914,23915,24065,24066,24067,24068,24069,24070,24071,24072,24073,24074,24075,24076,24077,24078,24568,24569,24570,24571,26250,24863,24864,24865,24866,24867,24868,24869,25053,25055,25056,25057,25058,25173,26252,25443,25522,25523,25524,25525,25526,25527,25528,25529,25530,25531,25532,25533,25664,25676,25677,25673,25674,25675,25678,25796,25819,25975,25976,25977,25978,25979,25980,26180,26181,26253,26254,26251,26304,26326,26701,26703,26704,26705,26706,26707,26849,26850,27138,27139,27140,27141,27142,27143,27144,27145,27177,27178,27179,27238,27239,27236,27237,27340,27338,27339,27341,27755,27756,27757,30374,28079,28080,28305,28306,29002,29003,29004,29005,29006,29007,29008,29009,29010,29011,29012,29013,29014,29015,29016,29017,29018,29019,29020,29021,29022,29023,29024,29025,29026,29027,29028,29029,29030,29031,29032,29033,29036,29037,29038,29039,29040,29041,29042,29043,29044,29045,29046,29047,29048,29049,29050,29051,29052,29053,29054,29055,29056,29057,29060,29059,29061,29062,29063,29069,29070,32532,29396,29397,29530,29585,29586,29584,29587,29588,29589,29590,29591,29592,29593,29595,29596,29597,29857,29858,29859,29860,29910,29911,30014,30015,30016,30017,30018,30226,30227,30228,30593,30594,30595,30596,30750,30751,30752,30748,30749,30753,30754,31394,30951,31054,31062,31055,31056,31061,31067,31066,31365,31366,31367,31368,31369,31370,31395,31396,31397,31413,31530,31531,31532,31541,31811,31812,31813,31814,31815,31856,31857,31858,31859,31860,31951,31952,32058,32216,32217,32409,32410,32510,32511,32512,32567,32568,32569,32570,32571,32766,32768,32767,32769,32770,32773,32774,32775,32776,32834,32822,33001,33083,33084,33085,33264,33265,33266,33267,33268,33273,33274,33275,33276,33277,33278,33279,33315,33316,33319,33321,33322,33323,33324,33369,33370,33371,33372,33373,33374,33375,33430,33431,33432,33466,33673,33674,33676,33675,33682,33683,33684,33742,33745,33746,33747,33748,33749,33750,33751,33752,33753,33754,33755,33756,33757,33758,33759,33760,33761,33762,33764,33766,33767,33770,33771,33772,33773,33774,33775,33778,33904,33903,33905,33906,34013,34014,34228,34398,34396,34397,34424,34425,34548,34583,34630,34631,34879,35107,35109,35108,35456,35457,35458,35459,35460,35686,35888,35901,35902,35903,36080,36220,36341,36342,36357,36413,36437,36438,36439,36440,36441,36505,36513,36514,36515,36516,36517,36518,36590,36591,7838,7839,13179,11303,11304,11305,11306,11675,11676,11677,13026,13027,13030,13028,13029,13031,13032,13033,13034,13035,13036,13037,13038,13039,13040,13041,13042,13043,13180,13181,13182,13183,13184,13186,14098,16800,21508,22795,22796,22797,22798,23292,24870,24871,24872,24873,24875,24876,24877,24878,24879,24880,24881,24882,24883,24884,24885,24886,24887,24888,27835,27836,27837,27838,27839,27840,27945,27946,27947,27948,27949,27950,27951,27952,27953,27954,27955,27956,27957,27958,30755,30756,30757,30758,30759,30760,30765,30766,30767,30768,31398,31399,31400,31401,31402,31403,31404,31405,31406,31407,31408,31409,31410,31411,31412,32077,32078,32513,34104) 
 AND 
 (
 (ov.option_type = 0 AND ov.option_value <> '') || 
 (ov.option_type = 1 AND v.option_value <> '')
 )
 -- AND ov.variantID IS NOT NULL
 GROUP BY ov.option_value, ov.option_type, ov.variantID, v.option_value</pre>