Untitled query #83595

SQL

SELECT
	C.ns,
    C.title, C.links
FROM
(
SELECT
	'Kullanıcı' AS ns,
	p2.page_title AS title,
    COUNT(pl.pl_from) AS links
FROM
	(SELECT
		p.page_title AS temp_title
	FROM
		categorylinks cl
		INNER JOIN page p
		ON p.page_id = cl.cl_from
	WHERE
		cl.cl_to = 'Deneme_üstbilgi_şablonları'
		AND p.page_namespace = 10
	UNION
	SELECT 'Bilgi_sayfası' AS temp_title
	UNION
	SELECT 'Tamamlayıcı' AS temp_title
	UNION
	SELECT 'Vikipedi\'ye dair nasıl' AS temp_title
	) B
    INNER JOIN templatelinks tl
    ON tl.tl_from_namespace = 2
    INNER JOIN linktarget lt
    ON tl.tl_target_id = lt.lt_id
    AND lt.lt_namespace = 10
    AND lt.lt_title = B.temp_title
    INNER JOIN page p2
    ON p2.page_id = tl.tl_from
    INNER JOIN linktarget lt2
    ON lt2.lt_namespace = 2
    AND lt2.lt_title = p2.page_title
    INNER JOIN pagelinks pl
    ON pl.pl_from_namespace = 2
    AND pl.pl_target_id = lt2.lt_id
 GROUP BY
	p2.page_title
    
UNION

SELECT
	'Vikipedi' AS ns,
	p2.page_title AS title,
    COUNT(pl.pl_from) AS links
FROM
	(SELECT
		p.page_title AS temp_title
	FROM
		categorylinks cl
		INNER JOIN page p
		ON p.page_id = cl.cl_from
	WHERE
		cl.cl_to = 'Deneme_üstbilgi_şablonları'
		AND p.page_namespace = 10
	UNION
	SELECT 'Bilgi_sayfası' AS temp_title
	UNION
	SELECT 'Tamamlayıcı' AS temp_title
	UNION
	SELECT 'Vikipedi\'ye dair nasıl' AS temp_title
	) B
    INNER JOIN templatelinks tl
    ON tl.tl_from_namespace = 4
    INNER JOIN linktarget lt
    ON tl.tl_target_id = lt.lt_id
    AND lt.lt_namespace = 10
	AND lt.lt_title = B.temp_title
    INNER JOIN page p2
    ON p2.page_id = tl.tl_from
    INNER JOIN linktarget lt2
    ON lt2.lt_namespace = 4
    AND lt2.lt_title = p2.page_title
    INNER JOIN pagelinks pl
    ON pl.pl_from_namespace = 4
    AND pl.pl_target_id = lt2.lt_id
 GROUP BY
	p2.page_title

) C

ORDER BY
	C.title
SQL

Checking query status...
