Untitled query #83595

SQL

SELECT
	p.page_title AS baslik
FROM
	page p
    LEFT JOIN linktarget lt
    ON lt.lt_namespace = 0
    AND lt.lt_title = p.page_title
    LEFT JOIN pagelinks pl
    ON pl.pl_from_namespace = 0
    AND pl.pl_namespace = 0
    AND pl.pl_target_id = lt.lt_id
WHERE
	p.page_namespace = 0
    AND p.page_is_redirect = 0
    AND lt.lt_title IS NULL
    
    AND NOT EXISTS
    (SELECT 1 FROM page_props pp
    WHERE pp.pp_page = p.page_id
    AND pp.pp_propname = 'disambiguation')
    
    AND NOT EXISTS
    (SELECT 1 FROM templatelinks tl
    INNER JOIN linktarget lt
    ON tl.tl_target_id = lt.lt_id
    AND lt.lt_namespace = 10
	AND (lt.lt_title = 'Öksüz' OR lt.lt_title = 'Liste_listesi'
	OR lt.lt_title = 'Sil')
    WHERE
	tl.tl_from = p.page_id
	AND tl.tl_from_namespace = 0)
    
LIMIT 500
SQL

Checking query status...
