Location_map - Quarry

SQL

USE arwiki_p;
select DISTINCT concat("قالب:",page_title) as pagename, count(*) as tot
from page 
join templatelinks on page_title = tl_title
where page_title like "Location_map%"

or page_title like "location_map%"
or page_title like "خريطة_مواقع%"
AND page_namespace = 10
AND page_is_redirect = 1
/*AND  exists (
    SELECT *
    FROM templatelinks
    WHERE tl_from=page_id 
    AND tl_namespace = 10
    AND tl_title ="تحويلة_قالب_خريطة_مواقع" -- find files that do not transclude a [[template:TemplateBox]]
	limit 1 
)*/
limit 50;
SQL

Checking query status...
