SELECT MEDIATYPE,count(*) FROM `mrlafiadb01`.`movies` WHERE COUNTRY LIKE '%Allemand%' AND (ORIGINALTITLE LIKE '%John Gatins%' OR TRANSLATEDTITLE LIKE '%John Gatins%' OR ACTORS LIKE '%John Gatins%' OR DIRECTOR LIKE '%John Gatins%' OR PRODUCER LIKE '%John Gatins%') GROUP BY MEDIATYPE ORDER BY MEDIATYPE<br />
<br />
Invalid Query: User 'mrlafiadb01' has exceeded the 'max_questions' resource (current value: 11647)