Disk full (/var/tmp/#sql_cb9_3); 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 ('16281','16380','17283','17281','17582','17891','17960','18017','18046','18105','18327','18409','23924','23923','23922','18546','23920','18708','20467','18914','20014','25593','25764','28428','25558','27958','19996','20047','20340','20841','20842') GROUP BY povt.optionID ORDER BY pot.sort_order, pot.name_ru