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

SQL

SELECT
    page.page_title AS page_title,
    COUNT(pl1.pl_title) AS blue_links,
    COUNT(pl2.pl_title) AS red_links
FROM
    page
JOIN pagelinks AS pl1 ON (pl1.pl_from = page.page_id)
JOIN pagelinks AS pl2 ON (pl2.pl_from = page.page_id)
WHERE page_namespace = 0
AND page.page_title = "الصحراء_الكبرى"
AND pl1.pl_from_namespace = 0
AND pl2.pl_from_namespace = 0
AND pl2.pl_title (SELECT rd_page.page_title FROM page AS rd_page WHERE rd_page.page_namespace = 0 AND rd_page.page.page_id = NULL)
GROUP BY page.page_id;

SQL

Checking query status...