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 ('26633','26644','26635','26646','26649','26647','26643','26632','26634','26636','26637','26638','26639','26640','26642','26641','26645','26648','26650','28809','30155','30153','30150','30152','30154','30151','30156','31459','31445','31704','31705') GROUP BY povt.optionID ORDER BY pot.sort_order, pot.name_ru