Disk full (/var/tmp/#sql_cb9_3); waiting for someone to free some space...
SELECT DISTINCT var.option_value_ru FROM SC_product_options_values v LEFT JOIN SC_products_opt_val_variants var ON var.variantID = v.variantID AND v.optionID = var.optionID WHERE v.productID IN (11120,11121,11122,11124,31170,11346,11348,11350,11369,22796,18465,18470,18475,20106,21553,21557,21563,21565,27010,27014,30402,30404,30547,30577,31090,31100,31091,31076,11382,11407,30015,31089,30807,11194,29751,9792,9827,9828,9829,31831,30576,9747,9744,9741,9746,9739,9722,9723,9719,9720,9778,9780,9784,9787,9788,27829,27920,21048,21049,21050,21087,23787,23788,31699,10379,10385,18443,22913,22914,18278,31164,18137,18517,18527,18528,18529,20969,23326,31625,31158,25906,25904,25905,25903,25902,25960,25958,25959,27422,31574,29734,31567,18520,18547,21320,21321,21322,21329,21331,21334,21335,21336,28003,23577,26531,26535,31552,30633,18783,23367,20033,20038,20043,20058,20072,20475,20476,20503,31681,31682,31683,31667,31668,31666,31676,29024,29739,31684,31663,31671,31672,31657,31678,31662,31665,18653,29023,20610,20613,31679,31664,31673,31680,31670,31677,31656,30673,20721,21483,21484,21485,21486,21487,21491,21492,21493,21494,21495,21523,16078,20608,20897,21544,21545,21546,21547,21559,21592,21593,20904,22136,31185,18449,18450,28005,22525,22526,22542,22545,22909,23005,23451,23452,23453,23461,23462,23463,23464,23465,23466,28602,28647,28716,28543,24067,23837,23836,23061,23062,23066,23067,24370,28538,28542,26574,26652,26697,26694,26873,26874,26875,23163,25211,31802,23266,23306,23307,23309,23310,23311,25836,25837,23362,23562,23567,23598,24757,20004,24085,20404,20428,20689,20690,25788,12165,22504,29878,30524,31512,31022,31491,31511,24087,31494,31495,31493,31490,31489,31492,31473,20407,20413,20414,20415,20424,20425,20691,20692,31496,31497,20410,20411,24008,24060,25302,25277,25275,25276,25303,25304,25787,26505,26506,26507,26508,29297,29301,29300,29296,26595,30634,29003,28037,25842,29427,27503,27646,27641,27466,27638,27645,27473,30647,30704,30806,28061,29129,29512,29516,29523,29531,29515,29595,29524,29525,29527,29530,29532,29487,29578,29514,29526,29529,29528,29486,29488,29489,29577,29593,29594,29596,29592,29591,29576,30021,30102,30070,31101,30411,30796,30314,30254,30798,30621,30620,30643,30642,30703,30805,30797,30349,31509,31770) AND v.variantID IS NOT null AND v.variantID != '' AND v.optionID = 854 ORDER BY var.option_value_ru