Disk full (/var/tmp/#sql_cb9_2); 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 ('27383','16812','16813','28446','3520','31646','21276','27270','9323','24103','24102','9798','26740','11992','18437','26987','26956','18131','18320','18321','18542','18659','22733','22735','29221','28478','28515','27953','28013','28220','28250')
GROUP BY povt.optionID
ORDER BY pot.sort_order, pot.name_ru