Disk full (/var/tmp/#sql_cb9_5); 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 ('21586','21587','21588','21589','21590','21591','22684','22691','22692','22693','23448','23449','23450','23459','23460','27888','27890','31066','25130','25208','25209','26157','26192','26179','26180','26181','26182','26183','26184','26185','26186')
GROUP BY povt.optionID
ORDER BY pot.sort_order, pot.name_ru