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 ('52704','52705','52706','52707','52708','52709','52710','52711','52712','52713','52714','52715','52716','52717','52718','52719','52720','52721','52722','52723','52724','52725','52726','52727','52728','52729','52730','52731','16506','16507','16511','16512','16515','16517','16518','16519','16522','16527','2484') ORDER BY pot.sort_order, _name_sort