de_wiki: red links count gt 120

SQL

use dewiki_p;
SET sql_mode='PIPES_AS_CONCAT';
select '- [['||pl_title||']] <!--'|| c ||' Links-->' as output
from (select pl_title , count(*) as c , pl_namespace
      from pagelinks 
      where pl_from_namespace=0 and pl_namespace=0
      group by pl_title, pl_namespace
      having count(*)>120) as pl
  left join page
    on (pl_title=page_title and page_namespace= pl_namespace)
where page_id is null
order by c desc
limit 100
union all
select '<!-- bis hier 100 Lemmata -->-  [[Wikipedia:Fehlende Artikel|mehr]]<noinclude>\n\n\n== Weitere meistverlinkte Seiten ==\n\n\n'
union all
select '- [['||pl_title||']] <!--'|| c ||' Links-->' as output
from (select pl_title , count(*) as c , pl_namespace
      from pagelinks 
      where pl_from_namespace=0 and pl_namespace=0
      group by pl_title, pl_namespace
      having count(*)>120) as pl
  left join page
    on (pl_title=page_title and page_namespace= pl_namespace)
where page_id is null
order by c desc
limit 1900 offset 100;
SQL

Checking query status...
