SELECT CATEGORY,count(*) FROM `nutricoaching`.`movies` WHERE (MEDIA LIKE '%Ed Harris%' OR MEDIATYPE LIKE '%Ed Harris%' OR SOURCE LIKE '%Ed Harris%' OR ORIGINALTITLE LIKE '%Ed Harris%' OR TRANSLATEDTITLE LIKE '%Ed Harris%' OR DIRECTOR LIKE '%Ed Harris%' OR PRODUCER LIKE '%Ed Harris%' OR COUNTRY LIKE '%Ed Harris%' OR CATEGORY LIKE '%Ed Harris%' OR YEAR LIKE '%Ed Harris%' OR ACTORS LIKE '%Ed Harris%' OR DESCRIPTION LIKE '%Ed Harris%' OR COMMENTS LIKE '%Ed Harris%' OR VIDEOFORMAT LIKE '%Ed Harris%' OR VIDEOBITRATE LIKE '%Ed Harris%' OR AUDIOFORMAT LIKE '%Ed Harris%' OR AUDIOBITRATE LIKE '%Ed Harris%' OR RESOLUTION LIKE '%Ed Harris%' OR FRAMERATE LIKE '%Ed Harris%' OR LANGUAGES LIKE '%Ed Harris%') GROUP BY CATEGORY ORDER BY CATEGORY<br />
<br />
Invalid Query: Incorrect key file for table '/tmp/#sql_9c2_2.MYI'; try to repair it