SQL
AخA
SELECT
page.page_title as page_title,
COUNT(pagelinks.pl_title) as blue_links,
(SELECT COUNT(pagelinks.pl_title) FROM pagelinks WHERE NOT EXISTS (SELECT 1 FROM page AS p2 WHERE p2.page_title = pagelinks.pl_title)) AS red_links
FROM
page
JOIN pagelinks ON (pagelinks.pl_from = page.page_id)
WHERE page_namespace = 0
AND page.page_title = "الصحراء_الكبرى"
GROUP BY page.page_id;
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.