Untitled query #86080

SQL

/*
SELECT 
    ROW_NUMBER() OVER(ORDER BY COUNT(DISTINCT lt_title) DESC) AS id,
    page_title, 
    COUNT(DISTINCT lt_title) AS "count"
FROM page
INNER JOIN pagelinks ON pagelinks.pl_from = page.page_id
INNER JOIN linktarget ON pagelinks.pl_target_id = linktarget.lt_id AND lt_namespace = 2
WHERE page_title LIKE "%إداريون/تصويت%"
GROUP BY page_title
ORDER BY "count" DESC;

*/
SELECT 
        page.page_title,
        COUNT(tl_from) AS template_count
    FROM page
    INNER JOIN templatelinks ON templatelinks.tl_from = page.page_id
    INNER JOIN linktarget ON templatelinks.tl_target_id = linktarget.lt_id
        AND lt_namespace = 10 
        AND lt_title = 'مع'
        where page_id = 9675064;
    #WHERE page.page_title LIKE "%إداريون/تصويت%"
#    GROUP BY page.page_title
SQL

Checking query status...
