Most linked non-existing pages (lvwiki)

This query is marked as a draft This query has been published by Edgars2007.

cswiki version: http://quarry.wmflabs.org/query/1841 (Most linked non-existing pages in cswiki)

SQL

use lvwiki_p;
select pl.pl_title, COUNT(pl.pl_title)
from pagelinks pl
where pl.pl_title NOT IN (Select page_title from page where page_namespace=0) and pl.pl_from_namespace=0 and pl.pl_namespace=0
and pl.pl_title NOT IN (select pl_title from pagelinks pl where pl_from=184158) and pl.pl_title="1951._gada_Tour_de_France"
	#and pl.pl_title NOT LIKE "%Tour_de_France"
group by pl.pl_title
having COUNT(pl.pl_title)>10
order by COUNT(pl.pl_title) DESC
limit 100;

By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.

Submit Query Stop Query

All SQL code is licensed under CC0 License.

SQL

Checking query status...