Untitled query #77326

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 blue_pagelinks.pl_title)  + COUNT(DISTINCT red_pagelinks.pl_title) AS all_links
FROM
    page
INNER JOIN pagelinks AS blue_pagelinks ON (blue_pagelinks.pl_from = page.page_id)
INNER JOIN pagelinks AS red_pagelinks ON (red_pagelinks.pl_from = page.page_id)
INNER JOIN page AS blue_page ON (blue_pagelinks.pl_title = blue_page.page_title)
INNER JOIN page AS red_page ON (red_pagelinks.pl_title = red_page.page_title)
WHERE page.page_title = "آكل_النمل_العملاق"
AND page.page_namespace = 0
AND blue_pagelinks.pl_namespace = 0
AND red_pagelinks.pl_namespace = 0
AND red_page.page_namespace = 0
AND blue_page.page_namespace = 0
AND blue_page.page_id IS NULL
AND red_page.page_id IS NULL
SQL

Checking query status...
