Disk full (/var/tmp/#sql_cb9_3); 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 ('31064','26513','31842','27001','27013','27008','27067','27065','27066','27123','27218','27214','27691','29806','29812','29865','29882','31163','31739','30413','30477','30476','31077','30767','30795','30768','30738','30764','30765','26889')
GROUP BY povt.optionID
ORDER BY pot.sort_order, pot.name_ru