Untitled query #69182

SQL

SELECT DISTINCT CONCAT('تصنيف:',page_title,'') AS en
FROM page
WHERE page_namespace = 14
and page_title like "%القرن_13%"
and page_id not in (
    SELECT tl_from FROM templatelinks 
    WHERE tl_namespace = 10
    and ( 
        tl_title like '%year%' or
        tl_title like '%تصفح%' or
        tl_title like '%قرن%' or
        tl_title like '%عقد%' or
        tl_title like '%سنة%' or
        tl_title like '%سنوات%' or
        tl_title like '%تصنيف%' )
)
#limit 10
;
AND tl_target_id = (SELECT lt_id FROM linktarget WHERE lt_namespace = 10 AND lt_title = "%s")
SQL

Checking query status...
