Untitled query #81115

SQL

SELECT CONCAT("قالب:",REPLACE(p.page_title, "_", " ")) AS title
FROM page AS p
WHERE p.page_is_redirect = 0
AND p.page_namespace = 10
AND p.page_title NOT Like '%/%'
AND p.page_title REGEXP "أيقونة"
AND p.page_title REGEXP "عليا"
AND p.page_title NOT IN (
SELECT page_title
FROM page
JOIN templatelinks ON page_id = templatelinks.tl_from
JOIN linktarget ON templatelinks.tl_target_id = linktarget.lt_id
WHERE page_is_redirect = 0
AND page_namespace = 10
AND linktarget.lt_title REGEXP "(إيقونة_عنوان|إيقونةعلوية|Top_icon|أيقونة_علوية|إيقونة_علوية|أيقونة_عليا)"
)
GROUP BY p.page_title
SQL

Checking query status...
