Untitled query #76965

SQL

SELECT
    p.page_title AS page_title,
    p.page_len AS page_length,
    COUNT(DISTINCT bl.pl_title) AS blue_links,
    COUNT(DISTINCT rl.pl_title) AS red_links,
    COUNT(DISTINCT bl.pl_title) + COUNT(DISTINCT rl.pl_title) AS all_links,
    COUNT(DISTINCT tl.pl_from) AS to_links
FROM
    page AS p
JOIN
    pagelinks AS bl ON (bl.pl_from = p.page_id)
JOIN
    pagelinks AS rl ON (rl.pl_from = p.page_id)
JOIN
    pagelinks AS tl ON (tl.pl_title = p.page_title)
WHERE
    p.page_title = "أحمد_بن_فضلان"
    AND p.page_namespace = 0
    AND bl.pl_namespace = 0
    AND rl.pl_namespace = 0
    AND tl.pl_namespace = 0
    AND bl.pl_title IN (
        SELECT bp.page_title
        FROM page AS bp
        WHERE bp.page_namespace = 0
    )
    AND rl.pl_title NOT IN (
        SELECT rp.page_title
        FROM page AS rp
        WHERE rp.page_namespace = 0
    );
SQL

Checking query status...
