الحصول علي عدد وصلات الزرقاء في الصفحة

SQL

SELECT
    COUNT(pagelinks.pl_title) AS blue_links,  -- عدد الوصلات الزرقاء
    (SELECT COUNT(pagelinks.pl_title) FROM pagelinks AS pl2 WHERE NOT EXISTS (SELECT 1 FROM page AS p2 WHERE p2.page_title = pl2.pl_title)) AS red_links  -- عدد الوصلات الحمراء
FROM pagelinks AS pl
JOIN page ON pl_from = page_id
WHERE EXISTS (SELECT 1 FROM page AS p WHERE p.page_title = pl.pl_title)
AND page_namespace = 0
AND page.page_title = "الصحراء_الكبرى"
GROUP BY page.page_id;

SQL

Checking query status...