Untitled query #31416

SQL

use tewiki_p;
select count(p.page_id) from revision r, page p where r.rev_parent_id = 0 and p.page_namespace = 0 and p.page_is_redirect = 0 and r.rev_page = p.page_id and r.rev_user_text = 'Pranayraj1985';
select p.page_title from revision r, page p where r.rev_parent_id = 0 and p.page_namespace = 0 and p.page_is_redirect = 0 and r.rev_page = p.page_id and r.rev_user_text = 'Pranayraj1985';
select sum(r.rev_len) from revision r, page p where p.page_namespace = 0 and p.page_is_redirect = 0 and r.rev_page = p.page_id and r.rev_user_text = 'Pranayraj1985';
select count(r.rev_id) from revision r, page p where p.page_namespace = 0 and p.page_is_redirect = 0 and r.rev_page = p.page_id and r.rev_user_text = 'Pranayraj1985';
select count(r.rev_id) from revision r, page p where r.rev_page = p.page_id and r.rev_user_text = 'Pranayraj1985';
select distinct p.page_title from revision r, page p where p.page_namespace = 0 and p.page_is_redirect = 0 and r.rev_page = p.page_id and r.rev_user_text = 'Pranayraj1985';
use commonswiki_p;
select count(p.page_id) from revision r, page p where r.rev_parent_id = 0 and p.page_namespace = 6 and p.page_is_redirect = 0 and r.rev_page = p.page_id and r.rev_user_text = 'Pranayraj1985';
SQL

Checking query status...
