Disk full (/var/tmp/#sql_7cd_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 ('1522','1521','1523','1520','1493','888','1297','883','1489','1490','1491','1492','904','1147','906','907','905','1409','1277','1264','1278') ORDER BY pot.sort_order, _name_sort