corrected joins for user, guide and rookie models