Antal subdom&auml;ner
select count(*) from subdomains
Antal bes&ouml;kta hosts
select count(*) from hosts where status <> 0
Totalt antal lagrade html icke.se
select count(*) from url
Antal svenska subdom&auml;ner
select count(*) from subdomains where subdomain like '%.se'
Antal svenska hosts
select count(*) from hosts where (hostname like '%.se' or realname like '%.se') and status <> 0
Totalt antal lagrade html URL.se
select count(*) from url_se
Antal paths
select count(*) from paths
Antal files
select count(*) from files
Antal DNS ok
select count(*) from hosts where dns_ok='Y' and status <> 0
Antal DNS ej ok
select count(*) from hosts where dns_ok='N' and status <> 0
#
Antal okontrollerade hos robotcheck
select count(*) from url_se where nystatus='1'
Antal robotblockerade URL
select count(*) from url_se where nystatus='2'
Antal ol&auml;sta URL med lastmodified='0000-00-00 00:00:00'
select count(*) from url_se where nystatus='3' and lastmodified='0000-00-00 00:00:00'
Antal ol&auml;sta URL med lastmodified ok
select count(*) from url_se where nystatus='3' and lastmodified<>'0000-00-00 00:00:00'
Antal aktiva, inl&auml;sta URL (status=200)
select count(*) from url_se where nystatus='4'
Antal URL hos fixread
select count(*) from url_se where nystatus='5'
Antal URL som ej finns (status <> 200)
select count(*) from url_se where nystatus='6'
Antal URL som inte gick l&auml;sa
select count(*) from url_se where nystatus='7'
Antal URL med noindex
select count(*) from url_se where nystatus='8'
Antal URL med godk&auml;nda hosts
select count(*) from url_se where nystatus='9'
Antal tillf&auml;lligt blockerade
select count(*) from url_se where nystatus='C'
Antal tillf&auml;lligt blockerade (time)
select count(*) from url_se where nystatus='D'
Antal sidor som kr&auml;ver login och l&ouml;senord
select count(*) from url_se where nystatus='E'
Antal snabbl&auml;sta
select count(*) from url_se where nystatus='F'
Antal som ska l&auml;sas p&aring; nytt
select count(*) from url_se where nystatus='G'
OK to read
select count(*) from url_se where nystatus='H'
OK to read block
select count(*) from url_se where nystatus='I'
#
Antal gif
select count(*) from url_gif where nystatus<>'B' and nystatus <> '6'
Antal jpg
select count(*) from url_jpg where nystatus<>'B' and nystatus <> '6'
Antal jpeg
select count(*) from url_jpeg where nystatus<>'B' and nystatus <> '6'
Antal tif
select count(*) from url_pic where nystatus<>'B' and nystatus <> '6'
Antal tiff
select count(*) from url_tiff where nystatus<>'B' and nystatus <> '6'
Antal bmp
select count(*) from url_bmp where nystatus<>'B' and nystatus <> '6'
Antal ico
select count(*) from url_ico where nystatus<>'B' and nystatus <> '6'
Antal xbm
select count(*) from url_xbm where nystatus<>'B' and nystatus <> '6'
Antal au
select count(*) from url_sound where nystatus<>'B' and nystatus <> '6'
Antal wav
select count(*) from url_wav where nystatus<>'B' and nystatus <> '6'
Antal mid
select count(*) from url_mid where nystatus<>'B' and nystatus <> '6'
Antal aif
select count(*) from url_aif where nystatus<>'B' and nystatus <> '6'
Antal aiff
select count(*) from url_aiff where nystatus<>'B' and nystatus <> '6'
Antal mp3
select count(*) from url_mp3 where nystatus<>'B' and nystatus <> '6'
Antal ram
select count(*) from url_ram where nystatus<>'B' and nystatus <> '6'
Antal mpg
select count(*) from url_video where nystatus<>'B' and nystatus <> '6'
Antal mpeg
select count(*) from url_mpeg where nystatus<>'B' and nystatus <> '6'
Antal avi
select count(*) from url_avi where nystatus<>'B' and nystatus <> '6'
Antal mov
select count(*) from url_mov where nystatus<>'B' and nystatus <> '6'
Antal pud
select count(*) from url_pud where nystatus<>'B' and nystatus <> '6'
Antal mp3 / ftp
select count(*) from ftp_mp3 where nystatus<>'B' and nystatus <> '6'
Antal lzh
select count(*) from url_lzh where nystatus<>'B' and nystatus <> '6'
Antal viv
select count(*) from url_viv where nystatus<>'B' and nystatus <> '6'
