There was an error running the query [Unknown column 'rev_user' in 'where clause'] select page_namespace,count(*) AS cnt from revision_userindex,page WHERE page_id=rev_page and rev_user=141 group by page_namespace order by cnt desc