عدد الوصلات الحمراء والزرقاء

SQL

SELECT
    page.page_title AS page_title,
    COUNT(DISTINCT blue_pagelinks.pl_title) AS blue_links,
    COUNT(DISTINCT red_pagelinks.pl_title) AS red_links
FROM
    page
JOIN pagelinks AS blue_pagelinks ON (blue_pagelinks.pl_from = page.page_id)
JOIN pagelinks AS red_pagelinks ON (red_pagelinks.pl_from = page.page_id)
WHERE page_title = 'تحسين_محركات_البحث' 
AND page_namespace = 0
AND blue_pagelinks.pl_title IN (
    SELECT blue_page.page_title
    FROM page AS blue_page
WHERE blue_page.page_namespace = 0
)
AND red_pagelinks.pl_title NOT IN (
    SELECT red_page.page_title
    FROM page AS red_page
WHERE red_page.page_namespace = 0
)

SQL

Checking query status...