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 ('18333','25559','28574','25591','28568','28569','28570','28571','28573','28575','28292','28308','20255','20752','21089','21355','21357','21360','21361','21364','21365','21625','25851','25847','25850','25852','25950','25848','25849','25900','25952')
GROUP BY povt.optionID
ORDER BY pot.sort_order, pot.name_ru