SELECT MEDIATYPE,count(*) FROM `mrlafiadb01`.`movies` WHERE CATEGORY LIKE '%Science fiction%' AND COUNTRY LIKE '%USA%' AND (ORIGINALTITLE LIKE '%Emmett J. Scanlan%' OR TRANSLATEDTITLE LIKE '%Emmett J. Scanlan%' OR ACTORS LIKE '%Emmett J. Scanlan%' OR DIRECTOR LIKE '%Emmett J. Scanlan%' OR PRODUCER LIKE '%Emmett J. Scanlan%') GROUP BY MEDIATYPE ORDER BY MEDIATYPE<br />
<br />
Invalid Query: User 'mrlafiadb01' has exceeded the 'max_questions' resource (current value: 14891)