Disk full (/tmp/#sql_8d9_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 ('1912','1996','2007','1983','2018','1928','2019','2021','2020','1927','2026','1580','1953','2028','1931','1695','1696','2035','2036','2033','2034','1494','1705','1706','1700','1699','1716','1717','1702','1701','1697','1698','1351','1929','1930','809','877','1355','1709','1707','1708') ORDER BY pot.sort_order, _name_sort