SELECT * FROM products WHERE Brand <> '' AND Brand <> '-NA-' GROUP BY Brand ORDER BY RAND() LIMIT 30:
Incorrect key file for table '/tmp/mysqltmp/#sql_277fa_2.MYI'; try to repair it