Untitled query #83595

SQL

SELECT
	C.page_title,
    C.temp
FROM
(
SELECT
	B.page_title,
    B.temp,
    CAST(GROUP_CONCAT(B.target ORDER BY B.target) AS CHAR(5000)) AS con
FROM
(
SELECT
	p.page_title AS page_title,
    p2.page_title AS temp,
    (CASE WHEN p3.page_title IS NULL THEN pl.pl_title ELSE rd.rd_title END) AS target
FROM
	page p
    INNER JOIN templatelinks tl
	ON tl.tl_from = p.page_id
	AND tl.tl_from_namespace = 0
    
    INNER JOIN linktarget lt
    ON tl.tl_target_id = lt.lt_id
    AND lt.lt_namespace = 10
    INNER JOIN page p2
    ON p2.page_namespace = 10
    AND p2.page_title = lt.lt_title
    AND p2.page_is_redirect = 0
    INNER JOIN templatelinks tl2
	ON tl2.tl_from = p2.page_id
	AND tl2.tl_from_namespace = 10
    
    INNER JOIN linktarget lt2
    ON tl2.tl_target_id = lt2.lt_id
    AND lt2.lt_namespace = 10
	AND lt2.lt_title = 'Dolaşım'
    
    INNER JOIN linktarget lt3
    ON lt3.lt_namespace = 0
    AND lt3.lt_title = p2.page_title
    INNER JOIN pagelinks pl
    ON pl.pl_from_namespace = 10
    AND pl.pl_target_id = lt3.lt_id
    

    LEFT JOIN page p3
    ON p3.page_namespace = 0
    AND p3.page_is_redirect = 1
    AND p3.page_title = pl.pl_title
    LEFT JOIN redirect rd
    ON rd.rd_from = p3.page_id
    AND rd.rd_namespace = 0
    
WHERE
	p.page_namespace = 0
    
    AND EXISTS
    (SELECT 1 FROM categorylinks cl
    WHERE cl.cl_from = p.page_id
    AND cl.cl_to LIKE '%doğumlular')

	AND EXISTS
    (SELECT 1 FROM categorylinks cl2
    WHERE cl2.cl_from = p2.page_id
    AND cl2.cl_to LIKE '%kadro%şablonları')
    
	AND p2.page_title <> 'Futbol_takımı_kadrosu'
    AND p2.page_title LIKE '%kadrosu'
    
ORDER BY
	p.page_title
    
) B

GROUP BY
	B.page_title,
    B.temp

) C

WHERE
	LOCATE(C.page_title, con) = 0

LIMIT 2000
SQL

Checking query status...
