Disk full (/var/tmp/#sql_d07_1); waiting for someone to free some space...
SELECT pot.*, IF(LENGTH(pot.name_ua), pot.name_ua, 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 ('1179') ORDER BY pot.sort_order, _name_sort