new = CertificateAuthenticationCode.objects.filter(generated=r.generated,
                                                       sold_to_customer_on=r.sold_to_customer_on,
                                                       sold_to_user_on=r.sold_to_user_on,
                                                       customer=r.customer,
                                                       user=r.user,
                                                       replaced_on__isnull=True,
                                                       ).count()