[web2py] Two LEFT JOINs and left=

[Annet]

How would I code this query in web2py using left=

SELECT organization.name, hub.name
FROM node LEFT JOIN organization ON node.id = organization.nodeID
LEFT JOIN hub ON node.id = hub.nodeID;


Kind regards,

Annet