use left join when getting paid flag from registered table in case the registration entry disappears for some reason