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 |