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

SQL

SELECT
    page.page_title AS page_title,
    SUM(CASE WHEN pl1.pl_title IN (SELECT page_title FROM page WHERE page_namespace = 0) THEN 1 ELSE 0 END) AS blue_links,
    SUM(CASE WHEN pl2.pl_title NOT IN (SELECT page_title FROM page WHERE page_namespace = 0) THEN 1 ELSE 0 END) AS red_links
FROM
    page
LEFT JOIN pagelinks AS pl1 ON (pl1.pl_from = page.page_id)
LEFT JOIN pagelinks AS pl2 ON (pl2.pl_from = page.page_id)
WHERE page_title = 'الصحراء_الكبرى' 
AND page_namespace = 0
GROUP BY pl1.pl_from;

SQL

Checking query status...