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 ('824','821','1293','1066','1150','1149','811','818','1256','1254','1258','809','1255','1280','1281','1165','1448','1155','988','989','1517') ORDER BY pot.sort_order, _name_sort