Disk full (/var/tmp/#sql_cb9_5); waiting for someone to free some space...
SELECT pot.*, povt.*, v.option_value_ru as variantName
FROM SC_product_options_values as povt
LEFT JOIN SC_products_opt_val_variants as v ON v.variantID=povt.variantID
LEFT JOIN SC_product_options as pot ON pot.optionID=povt.optionID
WHERE povt.productID IN ('31399','26771','23591','20934','16670','11916','15216','20935','7857','9967','11920','15214','28423','26766','27348','28435','29447','7858','15218','15219','28438','28434','27814','26765','27817','27816','26761','11918','28442','26767','11919')
GROUP BY povt.optionID
ORDER BY pot.sort_order, pot.name_ru