Fork of
specieswiki red links
by Estopedist1
This query is marked as a draft
This query has been published
by Estopedist1.
SQL
x
use specieswiki_p;
select pl_title
FROM page
INNER JOIN pagelinks AS pl ON pl_from = page_id
WHERE page_namespace = 14
AND pl_namespace = 0
AND pl_title NOT IN (SELECT page_title FROM page WHERE page_namespace = 0)
#AND page_title IS NULL
ORDER BY RAND()
LIMIT 999;
By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.
All SQL code is licensed under CC0 License.