total-number-urls.sql

select distinct
    jobid,
    ListID,
    BatchID,
    subscriberid, 
    count(distinct url) AS URLs
from _click
group by subscriberid, jobid, ListID, BatchID