SELECT CATEGORY,count(*) FROM `mrlafiadb01`.`movies` WHERE COUNTRY LIKE '%am�ricain%' AND (ORIGINALTITLE LIKE '%Roger Carel%' OR TRANSLATEDTITLE LIKE '%Roger Carel%' OR ACTORS LIKE '%Roger Carel%' OR DIRECTOR LIKE '%Roger Carel%' OR PRODUCER LIKE '%Roger Carel%') GROUP BY CATEGORY ORDER BY CATEGORY<br />
<br />
Invalid Query: User 'mrlafiadb01' has exceeded the 'max_questions' resource (current value: 12753)