Untitled query #7590

SQL

use plwikisource_p;

SELECT A.title FROM (SELECT
	rev_user_text as user_name,
	count(rev_page),
    LEFT(page_title, 20) as title
FROM
	revision, page
WHERE
    rev_user_text IN ('Zdzislaw') AND
    rev_page = page_id AND
    page_namespace = 100
    group by title) as A
JOIN
(SELECT
	rev_user_text as user_name,
	count(rev_page),
    LEFT(page_title, 20) as title
FROM
	revision, page
WHERE
    rev_user_text IN ('Ankry') AND
    rev_page = page_id AND
    page_namespace = 100
    group by title) as B
JOIN
(SELECT
	rev_user_text as user_name,
	count(rev_page),
    LEFT(page_title, 12) as title
FROM
	revision, page
WHERE
    rev_user_text IN ('Bonvol') AND
    rev_page = page_id AND
    page_namespace = 100
    group by title) as C
JOIN
(SELECT
	rev_user_text as user_name,
	count(rev_page),
    LEFT(page_title, 20) as title
FROM
	revision, page
WHERE
    rev_user_text IN ('Ashaio') AND
    rev_page = page_id AND
    page_namespace = 100
    group by title) as D
    JOIN
(SELECT
	rev_user_text as user_name,
	count(rev_page),
    LEFT(page_title, 20) as title
FROM
	revision, page
WHERE
    rev_user_text IN ('Wieralee') AND
    rev_page = page_id AND
    page_namespace = 100
    group by title) as E
        JOIN
(SELECT
	rev_user_text as user_name,
	count(rev_page),
    LEFT(page_title, 20) as title
FROM
	revision, page
WHERE
    rev_user_text IN ('Nostrix') AND
    rev_page = page_id AND
    page_namespace = 100
    group by title) as F
ON A.title = B.title AND A.title = C.title AND A.title = D.title AND A.title = E.title AND A.title = F.title
SQL

Checking query status...
