Fork of
enwiki:Pages in WikiProject History of Science with trwiki interwikis
by Evolutionoftheuniverse
This query is marked as a draft
This query has been published
by Evolutionoftheuniverse.
SQL
AخA
SELECT DISTINCT article.page_id, article.page_len, article.page_title, ll_title, concat('[https://tr.wikipedia.org/w/index.php?title=Tartışma:', replace(ll_title,' ','_'),'&action=edit&preload=Şablon:VikiProje_Bilim_Tarihi/Önyükleme]') as discuss
FROM page talk
INNER JOIN page article ON
talk.page_title = article.page_title
INNER JOIN categorylinks cl ON
cl.cl_from = talk.page_id
INNER JOIN langlinks ON article.page_id = ll_from AND ll_lang='tr'
WHERE
talk.page_namespace = 1 AND
article.page_namespace = 0 AND
ll_title NOT IN (SELECT DISTINCT trarticle.page_title
FROM trwiki_p.page trtalk
INNER JOIN trwiki_p.page trarticle ON
trtalk.page_title = trarticle.page_title
INNER JOIN trwiki_p.categorylinks trcl ON
trcl.cl_from = talk.page_id
WHERE
trtalk.page_namespace = 1 AND
trarticle.page_namespace = 0 AND
trcl.cl_to LIKE "Vikiproje_Bilim_tarihi%")
cl.cl_to = "WikiProject_History_of_Science_articles";
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.