Disk full (/var/tmp/#sql_49eb_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 ('47769','57356','57357','57358','57359','57361','57362','57363','63871','63870','57259','57260','47793','47795','47796','47797','47798','47799','47801','47802','47803','47804','47805','47806','47807','47808','47809','47817','47818','47819','47820','47821','47822','47823','47824','47847','47848','47849','47850') ORDER BY pot.sort_order, _name_sort