Query Run
SELECT actor_name, COUNT(*) as articles_created FROM revision r ... 1 year ago
SELECT actor_name, COUNT(*) as articles_created FROM revision r ... 1 year ago
SELECT actor_name, COUNT(*) as articles_created FROM revision r ... 1 year ago
SELECT actor_name, COUNT(*) as articles_created FROM revision r ... 1 year ago
SELECT actor_name, COUNT(*) as articles_created FROM revision r ... 1 year ago
SELECT actor_name, COUNT(*) as q_user_editcount FROM revision r ... 1 year ago
SELECT actor_name, COUNT(*) as q_user_editcount FROM revision r ... 1 year ago
SELECT actor_name, COUNT(*) as q_user_editcount FROM revision r ... 1 year ago
blank query 1 year ago
use arwiki_p; 1 year ago
use arwiki_p; 3 years ago
use arwiki_p; select * from templatelinks where tl_namespace=10 and tl_from... 3 years ago
use arwiki_p; select * from templatelinks where tl_namespace=0 and tl_from =... 3 years ago
use arwiki_p; select * from templatelinks where tl_namespace=0 and tl_from =... 3 years ago
use arwiki_p; select * from templatelinks where tl_namespace=0 and tl_from =... 3 years ago
use arwiki_p; select * from templatelinks where tl_namespace=0 and tl_from =... 3 years ago
use arwiki_p; select * from templatelinks where tl_namespace=10 and tl_from... 3 years ago
use arwiki_p; select * from templatelinks where tl_namespace=10 and tl_from... 3 years ago
use arwiki_p; select * from templatelinks where tl_namespace=10 and tl_from... 3 years ago
use arwiki_p; select * from templatelinks where tl_namespace=10 and tl_from... 3 years ago
use arwiki_p; 3 years ago
use arwiki_p; SELECT * FROM page join templatelinks on page_id = tl_from and... 3 years ago
use arwiki_p; SELECT * FROM page join templatelinks on page_id = tl_from and... 3 years ago
use arwiki_p; SELECT * FROM page join templatelinks on page_id = tl_from and... 3 years ago
use arwiki_p; SELECT * FROM page join templatelinks on page_id = tl_from and... 3 years ago
use arwiki_p; SELECT page_title, page_namespace FROM page join... 3 years ago
use arwiki_p; SELECT page_title, page_namespace FROM page join... 3 years ago
use arwiki_p; SELECT page_title, page_namespace FROM page join... 3 years ago
use arwiki_p; 3 years ago
use arwiki_p; SELECT count(*) FROM templatelinks WHERE tl_title = 'تصنيف كومنز'; 3 years ago
use arwiki_p; SELECT count(*) FROM templatelinks WHERE tl_title = 'تصنيف... 3 years ago
use arwiki_p; SELECT page_id, page_is_redirect, page_title ... 3 years ago
use arwiki_p; SELECT page_id, page_is_redirect, page_title ... 3 years ago
use arwiki_p; SELECT page_id, page_is_redirect, page_title ... 3 years ago
use arwiki_p; 3 years ago
use arwiki_p; SELECT page_title FROM page JOIN templatelinks ON... 3 years ago
use arwiki_p; SELECT COUNT(*) FROM page JOIN templatelinks ON page_title... 3 years ago
use arwiki_p; SELECT COUNT(*) FROM page JOIN templatelinks ON page_title... 3 years ago
use arwiki_p; SELECT COUNT(*) FROM page JOIN templatelinks ON page_title... 3 years ago
/* use arwiki_p; SELECT COUNT(*) FROM page JOIN templatelinks ON... 3 years ago
use arwiki_p; SELECT COUNT(*) FROM page JOIN templatelinks ON page_title =... 3 years ago
use arzwiki_p; select page_id, page_namespace, page_title, page_touched ... 4 years ago
use arwikiversity_p; select page_id, page_namespace, page_title,... 4 years ago
use arwikinews_p; select page_id, page_namespace, page_title, page_touched ... 4 years ago
use arwikisource_p; select page_id, page_namespace, page_title, page_touched... 4 years ago
use arwikiquote_p; select page_id, page_namespace, page_title, page_touched ... 4 years ago
use arwikibooks_p; select page_id, page_namespace, page_title, page_touched ... 4 years ago
use arwiktionary_p; select page_id, page_namespace, page_title, page_touched... 4 years ago
use arzwiki_p; select page_id, page_namespace, page_title, page_touched ... 4 years ago
use arywiki_p; select page_id, page_namespace, page_title, page_touched ... 4 years ago
use arwiki_p; select page_id, page_namespace, page_title, page_touched from... 4 years ago
use arwiki_p; select count(*) from page where page_namespace=10 and... 4 years ago
use arwiktionary_p; select count(*) from page where page_namespace=14; 4 years ago
use arwikisource_p; select count(*) from page where page_namespace=14; 4 years ago
use arwikibooks_p; select * from page where page_id =4; 4 years ago
use arywiki_p; select * from page where page_id =114; 4 years ago
select * from cognate_sites limit 10; 4 years ago
describe cognate_sites; 4 years ago
use enwiktionary_p; describe cognate_sites; 4 years ago
SELECT p1.page_namespace, /*ns_name,*/ p1.page_title FROM redirect AS... 4 years ago
SELECT p1.page_namespace, ns_name, p1.page_title FROM redirect AS... 4 years ago
SELECT p1.page_namespace, ns_name, p1.page_title FROM redirect AS... 4 years ago
use arzwiki_p; #select concat("# [[:User talk:", actor_name, "]]") from... 4 years ago
use arzwiki_p; #select concat("# [[:User talk:", actor_name, "]]") from... 4 years ago
use arzwiki_p; select concat("# [[:User talk:", actor_name, "]]") from... 4 years ago
use arzwiki_p; select concat("# [[:User talk:", actor_name, "]]") from... 4 years ago
use arzwiki_p; select distinct * from actor where actor_user is null order... 4 years ago
use arzwiki_p; select distinct * from actor, revision #on actor_user =... 4 years ago
use arzwiki_p; select * from actor, revision #on actor_user = rev_user where... 4 years ago
use arzwiki_p; select * from actor join revision on actor_user =... 4 years ago
use arzwiki_p; select * from actor where actor_user is not null limit 50 ; 4 years ago
use arwiki_p; #describe flaggedpages; #describe flaggedrevs select * from... 5 years ago
use arwiki_p; #describe flaggedpages; describe flaggedrevs #select * from... 5 years ago
use arwiki_p; #describe flaggedpages; describe flaggedpage_pending; select *... 5 years ago
use arwiki_p; #describe flaggedpages; describe flaggedpage_pending; select *... 5 years ago
use arwiki_p; #describe flaggedpages; describe flaggedpage_pending; #select... 5 years ago
use arwiki_p; #describe flaggedpages; select * from flaggedpages join page... 5 years ago
use arwiki_p; #describe flaggedpages; select * from flaggedpages join page... 5 years ago
use arwiki_p; #describe flaggedpages; select * from flaggedpages join page... 5 years ago
use arwiki_p; #describe flaggedpages; select * from flaggedpages join page... 5 years ago
use arwiki_p; #describe flaggedpages; select * from flaggedpages join page... 5 years ago
use arwiki_p; #describe flaggedpages; select * from flaggedpages join page... 5 years ago
use arwiki_p; #describe flaggedpages; select * from flaggedpages join page... 5 years ago
use arwiki_p; #describe flaggedpages; select * from flaggedpages limit 50; 5 years ago
use arwiki_p; describe flaggedpages; 5 years ago