left join

How should I use the XF finder with an sql query left joining 3 tables (I can join only 2 of them if it's simpler...)? I'm working on adding API endpoints to an existing add-on (I've already succeeded in doing it for another add-on) but have had a problem: I have 3 tables. One has events, the...