Untitled query #7590

SQL

use plwikisource_p;

SELECT
	A.user_name,
    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', 'Ankry') AND
    rev_page = page_id AND
    page_namespace = 100
    group by title
 LIMIT 700) 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 ('Zdzislaw', 'Ankry') AND
    rev_page = page_id AND
    page_namespace = 100
    group by title
LIMIT 700) as B

ON A.title = B.title
SQL

Checking query status...
