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;