Fork of
Untitled query #16044
by MohammadtheEditor
This query is marked as a draft
This query has been published
by Evolutionoftheuniverse.
SQL
AخA
USE trwiki_p;
SELECT pl_title, COUNT(pl_title) AS counting
FROM pagelinks, page
WHERE pl_from = page_id
AND pl_from_namespace = 0
AND pl_namespace = 0
AND pl_title RLIKE "(B|b)araj(ı|)"
AND NOT EXISTS
(SELECT * FROM page AS p1
WHERE p1.page_title = pl_title
AND pl_namespace = 0
AND p1.page_namespace = 0)
GROUP BY pl_title
HAVING counting > 0
ORDER BY counting DESC, pl_title ASC, page_title 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.