select
sum(1) as n,
sum(if(ipb_address != '' and ipb_range_start =... |
3 years ago |
select
sum(1) as n,
sum(if(ipb_address != '', 1, 0)) as... |
3 years ago |
select
sum(1) as n,
sum(if(ipb_address != '', 1, 0)) as n_with_address
... |
3 years ago |
select
sum(1) as n,
sum(if(ipb_anon_only, 1, 0)) as n_anon,
... |
3 years ago |
select
sum(1) as n,
sum(if(ipb_expiry = 'infinity', 1, 0)) as... |
3 years ago |
select
sum(1) as n,
sum(if(ipb_expiry = 'infinity', 1, 0)) as... |
3 years ago |
select
count(*) as n
from
ipblocks
; |
3 years ago |