REF-004Filter out referrals that were never realCount active referrals, not registered ones. Four queries that separate a genuine promoter from someone with a script.PHPTested on PHP 8.2, MariaDB 10.6