SELECT * FROM (SELECT * FROM psorter_listings WHERE (ptype = 'houses' OR ptype = 'house') AND (sale_rent = 'sale')) as T ORDER BY T.price ASC LIMIT 0,10Incorrect key file for table '/tmp/#sql_d5b_1.MYI'; try to repair it