SQL: SELECT a.*, (q.start_date < NOW()) AS contest_officially_started, c.name AS category_name, c.urldecoded_name AS category_urldecoded_name, u.username AS username, u.urldecoded_name AS username_urlencoded, u.is_aboutme_specified AS user_is_aboutme_specified, cntry.name AS country_name, cntry.code AS country_code, u.city AS user_city, u.state AS user_state, q.name AS contest_name, q.start_date AS contest_start_date, q.end_date AS contest_end_date, q.is_freezed AS contest_is_freezed, RAND() AS random_thing FROM music_song AS a INNER JOIN music_category AS c ON (c.music_category_ = a.category_) INNER JOIN user AS u ON (u.user_ = a.user_) INNER JOIN countries AS cntry ON (cntry.country_ = u.country_) LEFT JOIN music_contest AS q ON (a.contest_is_participating = 'yes' AND q.music_contest_ = a.contest_) order by a.added_date desc, random_thing asc limit 100, 10

Fatal error: Incorrect key file for table '/var/tmp/#sql366_5458a_406.MYI'; try to repair it [/seagate1/apache/riffstar.com/lib/framework/PaMySqlDbConnection.php:204] in /seagate1/apache/riffstar.com/lib/framework/PaSqlError.php on line 75