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 ('53857','53858','53859','53852','53853','53854','53855','53856','53850','53851','53848','53849','53846','53843','53844','53845','53841','53842','53835','53836','53837','53838','53839','53840','53832','53833','53834','53825','53826','53828','53829','53830','53831','53824','53827','53847','53860','53862','53863') ORDER BY pot.sort_order, _name_sort