Error al executar SQL

Incorrect key file for table '/tmp/#sql_159f8_1.MYI'; try to repair it

						FROM (
							SELECT idchollo, as name, as uname, description, price, discount, image, providerlink, referredlink, cdate, pdate, fdate, shop_name
							FROM chollo
							INNER JOIN users
							ON chollo.users_username=users.username
							WHERE active=TRUE and ( LIKE '%%' or chollo.description LIKE '%%')
							ORDER BY pdate DESC, cdate DESC
							) as con
						LIMIT 60 OFFSET 0