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 
    ROW_NUMBER() OVER(ORDER BY COUNT(DISTINCT lt_title) DESC) AS id,
    page_title, 
    COUNT(DISTINCT lt_title) AS "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 in ("مع")
WHERE page_title LIKE "%إداريون/تصويت%"
GROUP BY page_title
ORDER BY "count" DESC;
SQL

Checking query status...
