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 ('31168','9294','9295','9303','9814','10430','30323','29407','29437','10665','10676','10678','11170','11171','27528','11356','20717','11541','11545','12168','30879','17581','14490','31840','15281','31755','15585','15832','15836','15837','29935')
GROUP BY povt.optionID
ORDER BY pot.sort_order, pot.name_ru