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 ('63951','63952','63953','55882','55883','55884','55885','55886','55887','55888','55889','55890','55891','56878','56879','56880','56881','56882','56883','56884','56885','56886','56887','56888','56889','57247','57248','57249','57250','57251','57252','57253','57254','57255','57256','16211','12029','19344','19346') ORDER BY pot.sort_order, _name_sort