Erreur SQL !<br/>
		SELECT * FROM agen t1
		INNER JOIN agen_rub ON agen_rub.agen_id = t1.agen_id
		INNER JOIN rubss_agen ON rubss_agen.rubss_id = agen_rub.rubss_id
		INNER JOIN rub_agen ON rub_agen.rub_id =  rubss_agen.rub_id
		INNER JOIN agen_lieu_date ON agen_lieu_date.agen_id = t1.agen_id
		JOIN 
		 (
			SELECT a.agen_id FROM agen as a 
			INNER JOIN agen_lieu_date as ald ON ald.agen_id = a.agen_id
			WHERE a.agen_id>0 AND a.agen_statut=1 
			 
			 ORDER BY rand() LIMIT 0,1000
		) t2 ON t2.agen_id = t1.agen_id
		GROUP BY t1.agen_id	
	<br/>Incorrect key file for table '/tmp/#sql_1812_7.MYI'; try to repair it