Fork of
!!
by Mr. Ibrahem
This query is marked as a draft
This query has been published
by Mr. Ibrahem.
SQL
x
SELECT
p2.page_title,
p1.page_title
FROM page p1
JOIN pagelinks
ON pl_from = p1.page_id
left JOIN page p2
ON pl_target_id = p2.page_id
WHERE p1.page_namespace = 0
and p2.page_namespace = 10
And p2.page_title = "1997_in_athletics"
#group by p2.page_title
#order by count(p1.page_id) desc
#limit 30
;
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.