Resolve through the IoC
Include APP_REF
Left join to prevent failure when no joined results