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 ('27528','14490','16380','18017','18105','25764','20340','21425','21426','21708','21737','23089','23090','28544','27431','27067','27012','27123','27159','27687','24262','24263','24290')
GROUP BY povt.optionID
ORDER BY pot.sort_order, pot.name_ru