use ptwiki_p;
select user_name as bot, up_value as gender from user,... |
6 years ago |
use enwiki_p;
select user_name as bot, up_value as gender from user,... |
6 years ago |
use dewiki_p;
select user_name as bot, up_value as gender from user,... |
6 years ago |
use ptwiki_p;
select user_name, up_value from user, user_properties where... |
6 years ago |
use ptwiki_p;
select user_name, up_value from user, user_properties where... |
6 years ago |
use ptwiki_p;
select user_name from user where user_id in (
select... |
6 years ago |
use ptwiki_p;
select user_name_text from user where user_id in (
select... |
6 years ago |
use ptwiki_p;
select ug_user from user_groups where ug_group = 'bot' and... |
6 years ago |
use ptwiki_p;
#select * from user_properties where up_property =... |
6 years ago |
use ptwiki_p;
select * from user_properties where up_property = 'bot';
#... |
6 years ago |
use ptwiki_p;
select up_value as gender, count(*) as users from... |
6 years ago |