use plwiki_p;
select distinct(rev_actor), actor_user from revision
... |
5 years ago |
use plwiki_p;
select 'pl' as lang, user_id, user_name, user_registration,... |
5 years ago |
use plwiki_p;
select distinct(rev_actor), actor_user from revision
join... |
5 years ago |
use plwiki_p;
select distinct(rev_actor) from revision
... |
5 years ago |
use plwiki_p;
select distinct(rev_actor), actor_user from revision
... |
5 years ago |
use fawiki_p;
select distinct(rev_actor) from revision
... |
5 years ago |
use fawiki_p;
select distinct(rev_actor) from revision
... |
5 years ago |
use fawiki_p;
select distinct(rev_actor) from revision
... |
5 years ago |
use fawiki_p;
select distinct(log_actor) from revision
... |
5 years ago |
use fawiki_p;
select distinct(rev_user) from revision
... |
5 years ago |
use enwiki_p;
select thank_timestamp, receiver, ru.user_id as receiver_id,... |
5 years ago |
use enwiki_p;
select thank_timestamp, receiver, ru.user_id as receiver_id,... |
5 years ago |
use enwiki_p;
select thank_timestamp, receiver, ru.user_id as receiver_id,... |
5 years ago |
use enwiki_p;
select thank_timestamp, receiver, ru.user_id as receiver_id,... |
5 years ago |
use fawiki_p;
select thank_timestamp, sender_actor_id, receiver, ru.user_id... |
5 years ago |
use fawiki_p;
select log_actor, actor_user as blocking_user_id, actor_name... |
5 years ago |
use fawiki_p;
select log_actor, actor_user, actor_name, log_title as... |
5 years ago |
use fawiki_p;
select log_actor, actor_user, actor_text, log_title as... |
5 years ago |
use fawiki_p;
select log_actor, actor_user, log_title as blocked_user_name... |
5 years ago |
use fawiki_p;
select log_actor, log_title as blocked_user_name from... |
5 years ago |
use fawiki_p;
select log_actor, log_title as blocked_user_name from logging... |
5 years ago |
use fawiki_p;
select log_actor, log_title as blocked_user_name from logging... |
5 years ago |
use fawiki_p;
select log_actor, log_title as blocked_user_name from logging... |
5 years ago |
use fawiki_p;
-- describe logging;
en ene
select log_actor, log_title as... |
5 years ago |
use fawiki_p;
-- describe logging;
select log_actor, log_title as... |
5 years ago |
use fawiki_p;
-- describe logging;
select log_actor as blocking_user_id,... |
5 years ago |
use fawiki_p;
describe logging;
-- select log_user as blocking_user_id,... |
5 years ago |
use fawiki_p;
select log_user as blocking_user_id, log_user_text as... |
5 years ago |
use arwiki_p;
select ug_user as user_id, ug_group='bot' as is_official_bot... |
5 years ago |
use arwiki_p;
select * from user_properties limit 1; |
5 years ago |
user arwiki_p;
select * from user_properties; |
5 years ago |
user arwiki_p;
select * from user_properties; |
5 years ago |