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