Disk full (/var/tmp/#sql_34a4_0); waiting for someone to free some space...
SELECT pot.*, pot.name_ru AS _name_sort, povt.* FROM SC_product_options_values as povt LEFT JOIN SC_product_options as pot ON pot.optionID=povt.optionID WHERE povt.productID IN ('1512','1101','1102','1103','946','1077','1074','925','1104','688','1105','1140','1514','702','1128','1249','1246','1452','1450','1248','704') ORDER BY pot.sort_order, _name_sort