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 ('12054','21632','25594','27401','30291','29475','29579','28323','21258','24109','30268','18308','22794','31750','26407','17926','18372','18420','29230','28231','28249','28462','20206','21059','21720','22598','22700','22838','22857','22882','22923') GROUP BY povt.optionID ORDER BY pot.sort_order, pot.name_ru