Disk full (/var/tmp/#sql_4013_0); 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 ('21084','21085','21086','21178','21919','22533','22534','22537','22538','22539','22540','22541','22548','23128','28364','26127','26473','26591','26594','26596','26609','26905','27789','29852','30266','30267','30347','30456','30443','30488','30559') GROUP BY povt.optionID ORDER BY pot.sort_order, pot.name_ru