SELECT DIRECTOR,count(*) FROM `thebigwaf01`.`movies` WHERE CATEGORY LIKE '%Romance%' AND (ORIGINALTITLE LIKE '%SMPeg%' OR TRANSLATEDTITLE LIKE '%SMPeg%' OR DIRECTOR LIKE '%SMPeg%' OR PRODUCER LIKE '%SMPeg%' OR ACTORS LIKE '%SMPeg%' OR DESCRIPTION LIKE '%SMPeg%' OR VIDEOFORMAT LIKE '%SMPeg%' OR FRAMERATE LIKE '%SMPeg%' OR FILESIZE LIKE '%SMPeg%' OR AUDIOFORMAT LIKE '%SMPeg%' OR DATEADD LIKE '%SMPeg%' OR MEDIA LIKE '%SMPeg%' OR RESOLUTION LIKE '%SMPeg%' OR LENGTH LIKE '%SMPeg%' OR LANGUAGES LIKE '%SMPeg%' OR SUBTITLES LIKE '%SMPeg%' OR MEDIATYPE LIKE '%SMPeg%') GROUP BY DIRECTOR ORDER BY DIRECTOR<br />
<br />
Invalid Query: Incorrect key file for table '/tmp/#sql_8ee_3.MYI'; try to repair it