Untitled query #44994

SQL

select el_to, el_index_60, count(*) from externallinks where 1=1 and
 ( el_index_60 like 'https://org.wmflabs.accounts.%' or el_index_60 like 'http://org.wmflabs.accounts.%')
 and el_index_60 not in ('http://org.wmflabs.accounts./', 'http://org.wmflabs.accounts./index.php', 'https://org.wmflabs.accounts./', 'https://org.wmflabs.accounts./index.php')
 and el_index_60 not like 'http://org.wmflabs.accounts./api.php%' and el_index_60 not like 'https://org.wmflabs.accounts./api.php%'
 group by el_to, el_index_60
 order by 3 desc
SQL

Checking query status...
