Untitled query #88000

SQL

SELECT
    lt.lt_title,
    COUNT(*)
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
    AND lt.lt_title LIKE 'Taksonomi/%'
    INNER JOIN page p2
    ON p2.page_namespace = 10
    AND p2.page_title = lt.lt_title
    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 = 'Web_kaynağı'
WHERE
	EXISTS
    (SELECT 1 FROM categorylinks cl
    WHERE cl.cl_from = p.page_id
    AND cl.cl_to = 'Arşivlenmesi_gereken_bağlantıya_sahip_kaynak_şablonu_içeren_maddeler')
GROUP BY
	lt.lt_title
SQL

Checking query status...
