SELECT MEDIATYPE,count(*) FROM `mrlafiadb01`.`movies` WHERE CATEGORY LIKE '%Guerre%' AND (ORIGINALTITLE LIKE '%Reporter)%' OR TRANSLATEDTITLE LIKE '%Reporter)%' OR ACTORS LIKE '%Reporter)%' OR DIRECTOR LIKE '%Reporter)%' OR PRODUCER LIKE '%Reporter)%') GROUP BY MEDIATYPE ORDER BY MEDIATYPE
Invalid Query: User 'mrlafiadb01' has exceeded the 'max_questions' resource (current value: 9867)