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 ('31234','31253','31254','31483','31250','31255','31251','31266','31252','31268','31257','31272','31271','31233','31263','31244','31270','31264','31605','31265','31235','31258','31610','31273','31611','31256','31604','31232','31478','31223','31477') GROUP BY povt.optionID ORDER BY pot.sort_order, pot.name_ru