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

SQL

SELECT
    page.page_title AS page_title,
    page.page_len AS page_length,
    COUNT(DISTINCT blue_pagelinks.pl_title) AS blue_links,
    COUNT(DISTINCT red_pagelinks.pl_title) AS red_links,
    COUNT(DISTINCT all_pagelinks.pl_title) AS all_links,
    COUNT(DISTINCT all_pagelinks.pl_title) AS to_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)
JOIN pagelinks AS all_pagelinks ON (all_pagelinks.pl_from = page.page_id)
JOIN pagelinks AS to_pagelinks ON (to_pagelinks.pl_title = page.page_title)
WHERE page_title = "أحمد_بن_فضلان"
AND page_namespace = 0
AND blue_pagelinks.pl_namespace = 0
AND red_pagelinks.pl_namespace = 0
AND all_pagelinks.pl_namespace = 0
AND to_pagelinks.pl_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...
