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 ('22724','27244','22865','22927','23078','23093','23094','23099','23105','23106','23113','23118','23339','28458','28461','28559','25492','25365','25371','25403','25485','25488','25502','25642','25851','25644','25630','25633','25636','25640','25847')
GROUP BY povt.optionID
ORDER BY pot.sort_order, pot.name_ru