Disk full (/var/tmp/#sql_4013_1); 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 ('18198','18199','18248','18655','18656','18722','18932','29207','29240','29123','28370','28070','28028','20053','20290','20355','20358','20454','20909','20910','20911','20913','20914','20915','20917','20918','20919','20929','20930','20931','20932')
GROUP BY povt.optionID
ORDER BY pot.sort_order, pot.name_ru