Complete functional test of ticket with linked resources, inner join changed to left join