Query Run
select actor_name, count(*) c from revision join page on rev_page=page_id... 10 months ago
select actor_name, count(*) c from revision join page on rev_page=page_id... 10 months ago
select actor_name, count(*) c from revision join page on rev_page=page_id... 10 months ago
select actor_name, count(*) c from revision join page on rev_page=page_id... 10 months ago
select actor_name, count(*) c from revision join page on rev_page=page_id... 10 months ago
select actor_name, count(*) c from revision join page on rev_page=page_id... 10 months ago
select actor_name, count(*) c from revision join page on rev_page=page_id... 10 months ago
select actor_name, count(*) c from revision join page on rev_page=page_id... 10 months ago
select actor_name, count(*) c from revision join page on rev_page=page_id... 10 months ago
select actor_name, count(*) c from revision join page on rev_page=page_id... 10 months ago
select actor_name, count(*) c from revision join page on rev_page=page_id... 10 months ago
select actor_name, count(*) c from revision join page on rev_page=page_id... 10 months ago
select actor_name, count(*) c from revision join page on rev_page=page_id... 10 months ago
select actor_name, count(*) c from revision join page on rev_page=page_id... 2 years ago
select actor_name, count(*) c from revision join page on rev_page=page_id... 2 years ago
select actor_name, count(*) c from revision join page on rev_page=page_id... 3 years ago
select actor_name, count(*) c from revision join page on rev_page=page_id... 3 years ago
use ruwiki_p; #select * from actor where actor_name="JukoFF"; select... 4 years ago
use ruwiki_p; #select * from actor where actor_name="JukoFF"; select... 4 years ago
use ruwiki_p; #select * from actor where actor_name="JukoFF"; select... 4 years ago
use ruwiki_p; #select * from actor where actor_name="JukoFF"; select... 4 years ago
use ruwiki_p; #select * from actor where actor_name="JukoFF"; select... 4 years ago
use ruwiki_p; #select * from actor where actor_name="JukoFF"; select count... 4 years ago
use ruwiki_p; #select * from actor where actor_name="JukoFF"; select count... 4 years ago
use ruwiki_p; #select * from actor where actor_name="JukoFF"; select count... 4 years ago
use ruwiki_p; #select * from actor where actor_name="JukoFF"; select count... 4 years ago
use ruwiki_p; #select * from actor where actor_name="JukoFF"; select... 4 years ago
use ruwiki_p; #select * from actor where actor_name="JukoFF"; select... 4 years ago
use ruwiki_p; #select * from actor where actor_name="JukoFF"; select... 4 years ago
use ruwiki_p; #select * from actor where actor_name="JukoFF"; select count... 4 years ago
use ruwiki_p; #select * from actor where actor_name="JukoFF"; select count... 4 years ago
use ruwiki_p; select * from actor where actor_name="JukoFF"; #select count... 4 years ago
show tables; 4 years ago
USE ruwiki_p; SELECT actor_name, log_timestamp from logging_userindex join... 4 years ago
USE ruwiki_p; SELECT actor_name from logging_userindex join comment_logging... 4 years ago
USE ruwiki_p; SELECT actor_name from logging_userindex join comment_logging... 4 years ago
USE ruwiki_p; SELECT actor_name from logging join comment_logging on... 4 years ago
USE ruwiki_p; SELECT * from logging join comment_logging on... 4 years ago
USE ruwiki_p; SELECT * from comment_logging join comment on... 4 years ago
USE ruwiki_p; SELECT * from logging join comment on... 4 years ago
USE ruwiki_p; SELECT * from logging where log_timestamp > 20200101000000 and... 4 years ago
USE ruwiki_p; SELECT cast(actor_name as char) user, page_namespace,... 4 years ago
USE ruwiki_p; SELECT actor_name, log_type, COUNT(DISTINCT log_title) FROM... 4 years ago
USE ruwiki_p; SELECT actor_name, log_type, log_action, COUNT(DISTINCT... 4 years ago
USE ruwiki_p; SELECT actor_name, log_type, log_action, COUNT(DISTINCT... 4 years ago
USE ruwiki_p; SELECT actor_name, log_type, log_action, COUNT(DISTINCT... 4 years ago
USE ruwiki_p; SELECT actor_name, log_type, log_action, COUNT(DISTINCT... 4 years ago
USE ruwiki_p; SELECT actor_name, log_type, log_action, COUNT(DISTINCT... 4 years ago
USE ruwiki_p; SELECT actor_name, log_type, log_action, COUNT(DISTINCT... 4 years ago
USE ruwiki_p; SELECT actor_name, log_type, log_action, COUNT(DISTINCT... 4 years ago
USE ruwiki_p; SELECT actor_name, log_type, log_action, log_namespace,... 4 years ago
USE ruwiki_p; SELECT actor_name, page_namespace, COUNT(DISTINCT rev_page) ... 4 years ago
use ruwiki_p; select * from logging where log_action="delete" and... 4 years ago
use ruwiki_p; select * from logging where log_action="delete" and... 4 years ago
use ruwiki_p; select * from logging where log_action="delete" and log_namespace=3; 4 years ago
use ruwiki_p; select * from logging where log_action="delete" and... 4 years ago
use ruwiki_p; select * from logging where log_type="delete" and... 4 years ago
use ruwiki_p; select * from logging where log_type="thanks" limit 100; 4 years ago
use ruwiki_p; select * from logging where log_type="stable" and log_action... 4 years ago
use ruwiki_p; select * from logging where log_type="stable" and log_action... 4 years ago
use ruwiki_p; select * from logging where log_type="stable" and log_action... 4 years ago
use ruwiki_p; select * from logging where log_type="stable" and log_action... 4 years ago
use ruwiki_p; select * from logging where log_type="stable" and log_action... 4 years ago
use ruwiki_p; select * from logging where log_type="stable" and log_action... 4 years ago
use ruwiki_p; select * from logging where log_type="stable" and log_action... 4 years ago
use ruwiki_p; select * from logging where log_type="protect" and log_action... 4 years ago
use ruwiki_p; select * from logging where log_type="protect" and log_action... 4 years ago
use ruwiki_p; select * from logging where log_type="protect" and log_action... 4 years ago
use ruwiki_p; select * from logging where log_type="protect" and... 4 years ago
use ruwiki_p; select * from actor join logging on actor_id=log_actor where... 4 years ago
use ruwiki_p; select * from logging join actor on actor_id=log_actor where... 4 years ago
use ruwiki_p; #select * from logging join actor on actor_id=log_actor where... 4 years ago
use ruwiki_p; #select * from logging join actor on actor_id=log_actor where... 4 years ago
use ruwiki_p; #select * from logging join actor on actor_id=log_actor where... 4 years ago
use ruwiki_p; #select * from logging join actor on actor_id=log_actor where... 4 years ago
use ruwiki_p; #select * from logging join actor on actor_id=log_actor where... 4 years ago
use ruwiki_p; #select * from logging join actor on actor_id=log_actor where... 4 years ago
use ruwiki_p; #select * from logging join actor on actor_id=log_actor where... 4 years ago
use ruwiki_p; #select * from logging join actor on actor_id=log_actor where... 4 years ago
use ruwiki_p; select * from logging join actor on actor_id=log_actor where... 4 years ago
use ruwiki_p; select * from logging join actor on actor_id=log_actor where... 4 years ago
use ruwiki_p; select * from logging join actor on actor_id=log_actor where... 4 years ago
use ruwiki_p; select * from logging join actor on actor_id=log_actor where... 4 years ago
use ruwiki_p; select * from logging join actor on actor_id=log_actor where... 4 years ago
use ruwiki_p; select * from logging join actor on actor_id=log_actor where... 4 years ago
use ruwiki_p; select * from logging join actor on actor_id=log_actor where... 4 years ago
use ruwiki_p; select * from logging join actor on actor_id=log_actor where... 4 years ago
use ruwiki_p; select * from logging join actor on actor_id=log_actor where... 4 years ago
use ruwiki_p; select * from logging join actor on actor_id=log_actor where... 4 years ago
use ruwiki_p; select * from logging join actor on actor_id=log_actor where... 4 years ago
use ruwiki_p; select * from logging join actor on actor_id=log_actor where... 4 years ago
use ruwiki_p; select * from logging join actor on actor_id=log_actor where... 4 years ago
use ruwiki_p; select * from logging join actor on actor_id=log_actor where... 4 years ago
use ruwiki_p; select * from logging join actor on actor_id=log_actor where... 4 years ago
use ruwiki_p; select * from logging join actor on actor_id=log_actor where... 4 years ago
use ruwiki_p; select * from logging join actor on actor_id=log_actor where... 4 years ago
use ruwiki_p; select * from logging join actor on actor_id=log_actor where... 4 years ago
use ruwiki_p; select * from logging join actor on actor_id=log_actor where... 4 years ago
use ruwiki_p; select * from logging join actor on actor_id=log_actor where... 4 years ago
use ruwiki_p; select * from logging where log_type="massmessage" and... 4 years ago
use ruwiki_p; select cast(rc_title as char) title, max(case when... 5 years ago
use ruwiki_p; select cast(rc_title as char) title, max(case when... 5 years ago
use ruwiki_p; select cast(rc_title as char) title, max(case when... 5 years ago
use ruwiki_p; select cast(rc_title as char) title, max(case when... 5 years ago
use ruwiki_p; select cast(rc_title as char) title, max(case when... 5 years ago
use ruwiki_p; select cast(rc_title as char) title, max(case when... 5 years ago
use ruwiki_p; select cast(rc_title as char) title, max(case when... 5 years ago
use ruwiki_p; select cast(rc_title as char) title, max(case when... 5 years ago
use ruwiki_p; select cast(rc_title as char) title, max(case when... 5 years ago
use ruwiki_p; select cast(rc_title as char) title, cast(actor_name as char)... 5 years ago
use ruwiki_p; select cast(rc_title as char) title, cast(actor_name as char)... 5 years ago
use ruwiki_p; select cast(rc_title as char) title, cast(actor_name as char)... 5 years ago
use ruwiki_p; select * from logging where log_type="move" order by... 5 years ago
use ruwiki_p; select * from logging where log_type="move" limit 100; 5 years ago
use ruwiki_p; select * from logging where log_type="move" limit 10; 5 years ago
use ruwiki_p; select cast(actor_name as char) user, page_title,... 5 years ago
use ruwiki_p; select cast(actor_name as char) user, page_title,... 5 years ago
use ruwiki_p; select cast(actor_name as char) user, page_is_redirect from... 5 years ago
use ruwiki_p; select cast(actor_name as char) user, page_is_redirect from... 5 years ago
use ruwiki_p; select * from page where page_id=1392414; select... 5 years ago
use ruwiki_p; select * from page where page_id=1392414; select... 5 years ago
use ruwiki_p; select * from page where page_id=3849755; select... 5 years ago
use ruwiki_p; #select * from logging where log_type="create" and... 5 years ago
use ruwiki_p; #select * from logging where log_type="create" and... 5 years ago
use ruwiki_p; #select * from logging where log_type="create" and... 5 years ago
use ruwiki_p; #select * from logging where log_type="create" and... 5 years ago
use ruwiki_p; #select * from logging where log_type="create" and... 5 years ago
use ruwiki_p; #select * from logging where log_type="create" and... 5 years ago
use ruwiki_p; #select * from logging where log_type="create" and... 5 years ago
use ruwiki_p; #select * from logging where log_type="create" and... 5 years ago
use ruwiki_p; #select * from logging where log_type="create" and... 5 years ago
use ruwiki_p; #select * from logging where log_type="create" and... 5 years ago
use ruwiki_p; #select * from logging where log_type="create" and... 5 years ago
use ruwiki_p; #select * from logging where log_type="create" and... 5 years ago
use ruwiki_p; #select * from logging where log_type="create" and... 5 years ago
use ruwiki_p; #select * from logging where log_type="create" and... 5 years ago
use ruwiki_p; #select * from logging where log_type="create" and... 5 years ago
use ruwiki_p; #select * from logging where log_type="create" and... 5 years ago
use ruwiki_p; #select * from logging where log_type="create" and... 5 years ago
use ruwiki_p; #select * from logging where log_type="create" and... 5 years ago
use ruwiki_p; #select * from logging where log_type="create" and... 5 years ago
use ruwiki_p; #select * from logging where log_type="create" and... 5 years ago
use ruwiki_p; #select * from logging where log_type="create" and... 5 years ago
use ruwiki_p; #select * from logging where log_type="create" and... 5 years ago
use ruwiki_p; #select * from logging where log_type="create" and... 5 years ago
use ruwiki_p; #select * from logging where log_type="create" and... 5 years ago
use ruwiki_p; #select * from logging where log_type="create" and... 5 years ago
use ruwiki_p; select * from logging where log_type="create" and... 5 years ago
use ruwiki_p; select * from logging where log_type="create" and... 5 years ago
use ruwiki_p; select * from logging where log_type="create" and... 5 years ago
use ruwiki_p; select * from logging where log_type="create" and... 5 years ago
use ruwiki_p; select * from logging where log_type="create" and... 5 years ago
use ruwiki_p; select * from logging where log_type="create" and... 5 years ago
use ruwiki_p; select * from logging where log_type="create" and... 5 years ago
use ruwiki_p; select * from logging where log_type="create" and... 5 years ago
use ruwiki_p; select * from logging where log_type="create" and... 5 years ago
use ruwiki_p; select * from logging where log_type="create" and... 5 years ago
use ruwiki_p; select * from logging where log_type="create" and... 5 years ago
use ruwiki_p; select * from logging where log_type="create" and... 5 years ago
use ruwiki_p; select * from logging where log_type="create" and... 5 years ago
use ruwiki_p; select * from logging where log_type="create" and... 5 years ago
use ruwiki_p; select * from logging where log_type="create" and... 5 years ago
use ruwiki_p; select * from logging where log_type="create" and... 5 years ago
use ruwiki_p; select user_name user from user where user_editcount >= 10000; 5 years ago
use ruwiki_p; select actor_name, page_is_redirect, min(rev_id) from revision... 5 years ago
use ruwiki_p; #select actor_name, page_is_redirect, min(rev_id) from... 5 years ago
use ruwiki_p; #select actor_name, page_is_redirect, min(rev_id) from... 5 years ago
use ruwiki_p; select actor_name, page_is_redirect, min(rev_id) from revision... 5 years ago
use ruwiki_p; select actor_name, page_is_redirect, min(rev_id) from revision... 5 years ago
use ruwiki_p; select actor_name, page_is_redirect, min(rev_id) from revision... 5 years ago
use ruwiki_p; select *, min(rev_id) from revision join page on... 5 years ago
use ruwiki_p; #select *, min(rev_id) from revision join page on... 5 years ago
use ruwiki_p; #select *, min(rev_id) from revision join page on... 5 years ago
use ruwiki_p; select *, min(rev_id) from revision join page on... 5 years ago
use ruwiki_p; select *, min(rev_id) from revision join page on... 5 years ago
use ruwiki_p; select * from revision join page on rev_page=page_id where... 5 years ago
use ruwiki_p; select * from revision join page on rev_page=page_id where... 5 years ago
use ruwiki_p; select * from revision join page on rev_page=page_id where... 5 years ago
use ruwiki_p; select * from revision join page on rev_page=page_id where... 5 years ago
use ruwiki_p; #select * from revision join page on rev_page=page_id limit... 5 years ago
use ruwiki_p; select * from revision join page on rev_page=page_id limit 15; 5 years ago
use ruwiki_p; select user_name, user_editcount from user where... 5 years ago
use ruwiki_p; #select user_name, user_editcount from user where user_id not... 5 years ago
use ruwiki_p; select user_name, user_editcount from user where user_id not... 5 years ago
use ruwiki_p; select user_name, user_editcount from user where... 5 years ago
use ruwiki_p; select * from user order by user_registration desc limit 20; 5 years ago
use ruwiki_p; select * from user limit 20; 5 years ago
use ruwiki_p; select * from user limit 50; 5 years ago
use ruwiki_p; select * from revision join actor on actor_id=rev_actor join... 5 years ago
use ruwiki_p; select * from revision join page on page_id=rev_page where... 5 years ago
use ruwiki_p; #select * from revision where rev_actor=2253472; select... 5 years ago
use ruwiki_p; select * from revision where rev_actor=2253472; #select... 5 years ago
use ruwiki_p; #select * from revision where rev_actor=2105467; select... 5 years ago
use ruwiki_p; select * from revision where rev_actor=2105467; #select... 5 years ago
use ruwiki_p; select * from revision join page on page_id=rev_page where... 5 years ago
use ruwiki_p; select * from revision join page on page_id=rev_page where... 5 years ago
use ruwiki_p; #select * from revision join page on page_id=rev_page where... 5 years ago
use ruwiki_p; select * from revision join page on page_id=rev_page where... 5 years ago
use ruwiki_p; select * from revision join page on page_id=rev_page where... 5 years ago
use ruwiki_p; select * from revision join page on page_id=rev_page where... 5 years ago
use ruwiki_p; select * from revision join page on page_id=rev_page where... 5 years ago
use ruwiki_p; select * from revision join page on page_id=rev_page where... 5 years ago
use ruwiki_p; select * from revision join page on page_id=rev_page where... 5 years ago
use ruwiki_p; #select * from revision join actor on actor_user=rev_actor... 5 years ago
use ruwiki_p; #select actor_name from actor where actor_id in (select... 5 years ago
use ruwiki_p; #select actor_name from actor where actor_id in (select... 5 years ago
use ruwiki_p; #select actor_name from actor where actor_id in (select... 5 years ago
use ruwiki_p; #select actor_name from actor where actor_id in (select... 5 years ago
use ruwiki_p; select actor_name from actor where actor_id in (select... 5 years ago
use ruwiki_p; select actor_name from actor where actor_id=(select rev_actor... 5 years ago
use ruwiki_p; select actor_name from actor where actor_id=(select rev_actor... 5 years ago