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 (94,308,307,309,461) AND p.firmID IN (468,78,252,401,249,367,345,216,187,318,324,314,460,451,27,110,325,465,425,466,476,307,470,488,44,228,337,417,357,448,106,111,215,238,333,246,25,241,274,344,257,76,223,48,322,104,224,285,414,378,203,121,321,483,412,369,484,472)
 WHERE 1
 AND ov.optionID = '8' AND p.productID IN (397,139,140,9017,8826,7193,8435,8436,8457,8458,8469,8471,12562,12561,12560,18187,10995,10996,10997,11215,11932,12563,12564,12565,12566,12568,12569,12570,12571,12572,12573,12574,12575,12578,12579,12580,12581,12582,12584,12586,13740,13741,14116,14118,14119,14123,14124,14345,14346,14926,14927,15110,15111,16813,16814,16815,18470,18471,19107,19108,19109,19110,19111,19128,19129,19701,19702,19768,20296,20297,20298,20826,20827,21428,21446,21589,21719,21720,21780,23095,23096,26344,26345,26922,26923,27040,27408,27409,29243,29451,29452,29865,30417,30615,30616,30617,30620,30621,30639,31503,32288,35563,35314,35315,35471,35872,36193,36194,36195,36408,36403,36405,36404,12431,10495,1401,1402,1448,1449,1450,1480,25425,2791,2792,2793,7036,11151,11152,9159,9364,9365,9940,10223,10248,10908,10950,11428,11429,11822,11823,14350,14369,14534,14577,14608,14610,14611,14853,14923,14924,14925,15107,15108,15109,15294,15328,15329,15954,16086,16087,16711,17342,17499,18264,18648,20797,21264,21422,21423,21424,21425,21426,21427,21483,21530,21531,21532,21533,21534,22425,22426,25424,23104,23105,23103,23129,23189,23454,23455,23456,23515,23516,23622,23629,23630,23920,23921,24266,24267,24268,24269,25176,25175,25321,25453,25519,27410,27411,27412,27413,27414,27415,27416,27717,27997,28043,28044,28087,28088,28089,28322,28431,28432,29336,30101,30102,30210,30263,30786,32101,31024,31025,31291,31363,31615,32102,32103,32120,32286,32287,32691,32983,33465,33499,33531,33532,33983,34000,34239,34501,34651,34652,34653,34654,34974,35509,35587,36173,36459,36528,36529,36546,36129,36130,21717,36104,36131,14120,14121,14347,14348,14349,29450,30618,30619,36409) 
 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>