SQL
x
USE trwiki_p;
SELECT concat("[[",replace(p.page_title,"_"," "),"]]") as madde
, CONCAT("https://tr.wikipedia.org/w/index.php?action=edit§ion=0&title=",replace(p.page_title," ","_")) as link0
, COUNT(pl.pl_from) as kaclink
, CONCAT("[[Özel:SayfayaBağlantılar/",replace(p.page_title,"_"," "),"]]") as baglantilar
-- , CONCAT("https://tr.wikipedia.org/wiki/Özel:SayfayaBağlantılar/",replace(p.page_title," ","_")) as baglantilar
, p.page_latest as son_revizyon
FROM page p
JOIN categorylinks c ON p.page_id = c.cl_from AND c.cl_to = "Öksüz_maddeler"
JOIN pagelinks pl ON p.page_title = pl.pl_title AND p.page_namespace = pl.pl_namespace
JOIN page p2 ON p2.page_id = pl.pl_from
AND pl.pl_from_namespace = 0 and p2.page_is_redirect=0
GROUP BY p.page_title
having COUNT(pl.pl_from)>0
ORDER BY COUNT(pl.pl_from) DESC, p.page_latest ASC
;
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.