SQL
AخA
use nowiki_p;
select
DISTINCT replace( cl_to, "_", " " ), concat( "[http://no.wikipedia.org/wiki/Category:", cl_to, "?action=edit&preload=Template:WantedCat&summary=Oppretter_etterspurt_kategori", " create]" )
from categorylinks left join page on page_title = cl_to and page_namespace=14 where page_title is null limit 9999;
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.