Most wanted articles: ns0→ns0 redlinks only

SQL

-- select * from (select * from pagelinks where pagelinks.pl_from = 46575528) as pl left join page as p on p.page_id=pl.pl_from left join linktarget as lt on lt.lt_id=pl.pl_target_id where p.page_id is null or pl.pl_target_id is null limit 100;

select p.page_title as enTitle, count(iwl.iwl_from) as LinkCount, iwl.iwl_prefix as LinkPrefix  
from (select * from iwlinks where CHAR_LENGTH(iwlinks.iwl_title)>0
      and iwlinks.iwl_prefix in ("fr","de","no","es","it","zh")
     ) as iwl left outer join page as p on p.page_id=iwl.iwl_from 
     where p.page_namespace=0 
     group by enTitle, LinkPrefix
     order by LinkCount desc;

select iwl.iwl_title as LinkTarget, count(p.page_title) as enSourceCount, iwl.iwl_prefix as LinkPrefix  
from (select * from iwlinks where CHAR_LENGTH(iwlinks.iwl_title)>0
      and iwlinks.iwl_prefix in ("fr","de","no","es","it","zh")
     ) as iwl left outer join page as p on p.page_id=iwl.iwl_from 
     where p.page_namespace=0 
     group by LinkTarget, LinkPrefix 
     order by enSourceCount desc;
     
-- select p.page_title as enTitle, iwl.iwl_title as LinkTitle 
-- from (select * from iwlinks where iwlinks.iwl_prefix="it" and CHAR_LENGTH(iwlinks.iwl_title)>0
--      ) as iwl left outer join page as p on p.page_id=iwl.iwl_from 
--      where p.page_namespace=0 and iwl.iwl_title<"B"
--      limit 1000;

-- SELECT * -- linktarget.lt_title, count(distinct spage.page_id) as LinkCount-- pagelinks.pl_target_id AS Target, SUM(pagelinks.page_title IS NULL) AS LinkCount
-- FROM pagelinks
-- left join linktarget on pagelinks.pl_target_id = linktarget.lt_id
-- left join page as spage on pagelinks.pl_from = spage.page_id
-- Left join page as tpage on pagelinks.lt_title = tpage.page_name_title
-- where ( pagelinks.pl_from = 64386913 or pagelinks.pl_from = 44476398 ) AND linktarget.lt_namespace = 0
-- Group by lt_title
-- ORDER BY LinkCount DESC
-- LIMIT 1000
SQL

Checking query status...
