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 ('1095','1287','733','939','968','927','730','734','771','1385','738','1231','1096','1288') ORDER BY pot.sort_order, _name_sort