Disk full (/var/tmp/#sql_7cd_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 ('1259','1323','1023','1024','1410','1245','941','744','1025','745','1272','1273','1265','1270','746','729','1530','1529','1528','1531','1527') ORDER BY pot.sort_order, _name_sort