Upgraded email uniqueness and "check_in" query