cause of death

[^maikl11]

Hello everyone,
I want to make a report with a specific cause of death!
Only people should be listed who have "Fallen (in german: Gefallen)" the cause of death and where they died.
How do I do it?

I've already prepared something, but all causes of death are listed!

SELECT cause AS cause_of_death, personID, p.lastname, p.firstname, p.birthdate, p.deathdate, YEAR(p.deathdatetr)-YEAR(p.birthdatetr) AS age, p.gedcom FROM tng_events AS e
INNER JOIN tng_people AS p ON (e.persfamID=p.personID AND e.gedcom=p.gedcom)
WHERE cause<>"" AND parenttag="DEAT" AND YEAR(p.deathdatetr)<1910 ORDER BY cause_of_death, p.lastname;

[bhemph]

WHERE (cause LIKE "%Fallen%" OR cause LIKE "%Gefallen%") AND...

[^maikl11]

Thank you so much!!!