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

SQL

SELECT
    'الصحراء_الكبرى' AS page_title,
    COUNT(pl1.pl_title) AS blue_links,
    0 AS red_links
FROM
    page
JOIN pagelinks AS pl1 ON (pl1.pl_from = page.page_id)
WHERE page_title = 'الصحراء_الكبرى' 
AND page_namespace = 0
AND pl1.pl_title IN (
    SELECT page.page_title
    FROM page
    WHERE page.page_namespace = 0
)
UNION
SELECT
    'الصحراء_الكبرى' AS page_title,
    0 AS blue_links,
    COUNT(pl2.pl_title) AS red_links
FROM
    page
JOIN pagelinks AS pl2 ON (pl2.pl_from = page.page_id)
WHERE page_title = 'الصحراء_الكبرى' 
AND page_namespace = 0
AND pl2.pl_title NOT IN (
    SELECT page.page_title
    FROM page
    WHERE page.page_namespace = 0
);

SQL

Checking query status...