Untitled query #82824

SQL

SELECT
	DISTINCT A.title,
	A.c1
FROM
(
SELECT
	p.page_title AS title,
	cl.cl_to AS c1
FROM
	page p
	INNER JOIN categorylinks cl
	ON cl.cl_from = p.page_id
WHERE
	p.page_namespace = 0
) A

INNER JOIN

(
SELECT
	p.page_title AS title,
	cl.cl_to AS c1,
	cl2.cl_to AS c2
FROM
	page p
	INNER JOIN categorylinks cl
	ON cl.cl_from = p.page_id
	INNER JOIN page p2
	ON p2.page_title = cl.cl_to
	AND p2.page_namespace = 14
	INNER JOIN categorylinks cl2
	ON cl2.cl_from = p2.page_id
WHERE
	p.page_namespace = 0
	AND cl.cl_to NOT LIKE '%taslak%'
) B

ON A.c1 = B.c2
AND A.title = B.title

WHERE
	A.c1 LIKE '%filmler%'
    AND A.c1 NOT LIKE 'Anlam_ayrımı_sayfaları'
	AND A.title LIKE 'B%'

LIMIT 10000
SQL

Checking query status...
