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 ('23417','22183','22182','22185','22189','26150','22215','22216','22231','22232','22224','22233','22237','22234','22240','22235','22238','22243','22242','22245','22244','22246','22325','30506','22324','26154')
GROUP BY povt.optionID
ORDER BY pot.sort_order, pot.name_ru