Untitled query #32455

SQL

use dewiki_p;
select distinct  (select distinct user_name from user where user_id = rev_user) as name from revision_userindex
    where rev_user > 0 and rev_page in
    	(select distinct rev_page from revision_userindex
            where rev_user = (select user_id from user where user_name="Austriantraveler")
    	)
    limit 100;
    
   #count(user.user_name) as rev_count, 2138077,6333912,2272994
select distinct rev_page from revision_userindex2138077,6333912,2272994
   where rev_user > 0 and rev_user = (select user_id from user where user_name="Austriantraveler")
   limit 100;
SQL

Checking query status...
