Untitled query #7590

SQL

use plwikisource_p;

SELECT A.title FROM (SELECT
	rev_user_text as user_name,
	count(rev_page),
    LEFT(page_title, 10) 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, 10) 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, 10) as title
FROM
	revision, page
WHERE
    rev_user_text IN ('Masti') AND
    rev_page = page_id AND
    page_namespace = 100
    group by title) as C

ON A.title = B.title AND A.title = C.title
SQL

Checking query status...
