Incorrect key file for table '/var/tmp/#sql39b_4c1_27d.MYI'; try to repair it
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 ('2190','2205','2299','2303','2189','2382','2374','1036','1037','824','826','2175','1038','2180','2181','1042','1039','2194','1040','1041','827','963','828','829','965','964','967','968','961','830') ORDER BY pot.sort_order, _name_sort