def METHOD_NAME(cls):
    today = datetime.datetime.utcnow()
    yesterday = today - datetime.timedelta(1)
    join_on_start = datetime.datetime(
        yesterday.year, yesterday.month, yesterday.day, yesterday.hour, 0, 0, 0)
    join_on_end = datetime.datetime(
        yesterday.year, yesterday.month, yesterday.day, yesterday.hour, 59, 59, 59)
    requests = RegistrationRequest.objects.filter(
        request_time__gte=join_on_start,
        request_time__lte=join_on_end,
        confirm_time__isnull=True
    )
    return [req for req in requests if req.new_user_username == req.requesting_user_username]