use ruwiki_p;
select datediff(log_timestamp, user_registration) as days,... |
7 years ago |
use ruwiki_p;
select datediff(log_timestamp, user_registration) as days,... |
7 years ago |
use ruwiki_p;
select datediff(log_timestamp, user_registration) as days,... |
7 years ago |
use ruwiki_p;
select datediff(log_timestamp, user_registration) as days,... |
7 years ago |
use ruwiki_p;
select datediff(log_timestamp, user_registration) as days,... |
7 years ago |
use ruwiki_p;
select datediff(log_timestamp, user_registration) as days,... |
7 years ago |
use ruwiki_p;
#select datediff(log_timestamp, user_registration) as days,... |
7 years ago |
use ruwiki_p;
#select datediff(log_timestamp, user_registration) as days,... |
7 years ago |
use ruwiki_p;
#select datediff(log_timestamp, user_registration) as days,... |
7 years ago |
use ruwiki_p;
select datediff(log_timestamp, user_registration) as days,... |
7 years ago |
use ruwiki_p;
select datediff(log_timestamp, user_registration) as days,... |
7 years ago |
use ruwiki_p;
select datediff(log_timestamp, user_registration) as days,... |
7 years ago |
use ruwiki_p;
#select datediff(log_timestamp, user_registration) as days,... |
7 years ago |
use ruwiki_p;
select datediff(log_timestamp, user_registration) as days,... |
7 years ago |
use ruwiki_p;
#select datediff(log_timestamp, user_registration) as days,... |
7 years ago |
use ruwiki_p;
select datediff(log_timestamp, user_registration) as days,... |
7 years ago |
use ruwiki_p;
select datediff(log_timestamp, user_registration) as days,... |
7 years ago |
use ruwiki_p;
select datediff(log_timestamp, user_registration) as days,... |
7 years ago |
use ruwiki_p;
select datediff(log_timestamp, user_registration) as days,... |
7 years ago |
use ruwiki_p;
select datediff(log_timestamp, user_registration) as days,... |
7 years ago |
use ruwiki_p;
select datediff(log_timestamp, user_registration) as days,... |
7 years ago |
use ruwiki_p;
select datediff(log_timestamp, user_registration) as days,... |
7 years ago |
use ruwiki_p;
select datediff(log_timestamp, user_registration) as days,... |
7 years ago |
use ruwiki_p;
select days, log_params, log_title from (select... |
7 years ago |
use ruwiki_p;
select datediff(log_timestamp, user_registration) as days,... |
7 years ago |
use ruwiki_p;
select datediff(log_timestamp, user_registration) as days,... |
7 years ago |
use ruwiki_p;
select datediff(log_timestamp, user_registration) as diffdate,... |
7 years ago |
use ruwiki_p;
select datediff(log_timestamp, user_registration) as diffdate,... |
7 years ago |
use ruwiki_p;
select datediff(log_timestamp, user_registration) as diffdate,... |
7 years ago |
use ruwiki_p;
select datediff(log_timestamp, user_registration) as diffdate,... |
7 years ago |
use ruwiki_p;
select datediff(log_timestamp, user_registration) as diffdate,... |
7 years ago |
use ruwiki_p;
#select datediff(log_timestamp, user_registration) as... |
7 years ago |
use ruwiki_p;
#select datediff(log_timestamp, user_registration) as... |
7 years ago |
use ruwiki_p;
#select datediff(log_timestamp, user_registration) as... |
7 years ago |
use ruwiki_p;
#select datediff(log_timestamp, user_registration) as... |
7 years ago |
use ruwiki_p;
#select datediff(log_timestamp, user_registration) as... |
7 years ago |
use ruwiki_p;
select datediff(log_timestamp, user_registration) as diffdate,... |
7 years ago |
use ruwiki_p;
select datediff(log_timestamp, user_registration) as diffdate,... |
7 years ago |
use ruwiki_p;
select datediff(log_timestamp, user_registration) as diffdate,... |
7 years ago |
use ruwiki_p;
select datediff(log_timestamp, user_registration) as diffdate,... |
7 years ago |
use ruwiki_p;
select datediff(log_timestamp, user_registration) as diffdate,... |
7 years ago |
#use ruwiki_p;
#select log_timestamp, log_params, cast(log_title as char)... |
7 years ago |
#use ruwiki_p;
#select log_timestamp, log_params, cast(log_title as char)... |
7 years ago |
#use ruwiki_p;
#select log_timestamp, log_params, cast(log_title as char)... |
7 years ago |
#use ruwiki_p;
#select log_timestamp, log_params, cast(log_title as char)... |
7 years ago |
use ruwiki_p;
#select log_timestamp, log_params, cast(log_title as char)... |
7 years ago |
use ruwiki_p;
#select log_timestamp, log_params, cast(log_title as char)... |
7 years ago |
use ruwiki_p;
#select log_timestamp, log_params, cast(log_title as char)... |
7 years ago |
use ruwiki_p;
select log_timestamp, log_params, cast(log_title as char)... |
7 years ago |
use ruwiki_p;
select log_timestamp, log_params, cast(log_title as char)... |
7 years ago |
use ruwiki_p;
select log_timestamp, log_params, cast(log_title as char)... |
7 years ago |
use ruwiki_p;
select log_timestamp, log_params, cast(log_title as char)... |
7 years ago |
use ruwiki_p;
select log_timestamp, log_params, cast(log_title as char)... |
7 years ago |
use ruwiki_p;
select log_timestamp, log_params, cast(log_title as char)... |
7 years ago |
use ruwiki_p;
select log_timestamp, log_params, cast(log_title as char)... |
7 years ago |
use ruwiki_p;
select log_timestamp, log_params, cast(log_title as char)... |
7 years ago |
use ruwiki_p;
select log_timestamp, log_params, cast(log_title as char)... |
7 years ago |
use ruwiki_p;
select log_timestamp, log_params, cast(log_title as char)... |
7 years ago |
use ruwiki_p;
select log_timestamp, log_params, cast(log_title as char)... |
7 years ago |
use ruwiki_p;
select log_timestamp, log_params, cast(log_title as char)... |
7 years ago |
use ruwiki_p;
select log_timestamp, log_params, cast(log_title as char)... |
7 years ago |
use ruwiki_p;
select log_timestamp, log_params, cast(log_title as char)... |
7 years ago |
use ruwiki_p;
select * from logging join user on log_title = replace... |
7 years ago |
use ruwiki_p;
select * from logging where log_type = 'rights' and log_action... |
7 years ago |
use ruwiki_p;
select * from logging where log_type = 'rights' and log_action... |
7 years ago |
use ruwiki_p;
select * from logging where log_type = 'rights' and log_action... |
7 years ago |
use ruwiki_p;
select * from logging where log_type = 'rights' and log_action... |
7 years ago |
use ruwiki_p;
select * from logging where log_type = 'rights' and log_action... |
7 years ago |
use ruwiki_p;
select * from logging where log_type = 'rights' and log_action... |
7 years ago |
use ruwiki_p;
select * from logging where log_type = 'rights' and log_action... |
7 years ago |
use ruwiki_p;
select * from logging where log_type = 'rights' and log_action... |
7 years ago |
use ruwiki_p;
select * from logging where log_type = 'rights' and log_action... |
7 years ago |
use ruwiki_p;
select * from logging where log_type = 'rights' and log_action... |
7 years ago |
use ruwiki_p;
select * from logging where log_type = 'rights' and log_action... |
7 years ago |
use ruwiki_p;
select * from logging where log_type = 'rights' and log_action... |
7 years ago |
use ruwiki_p;
select * from logging where log_type = 'rights' and log_action... |
7 years ago |
use ruwiki_p;
select * from logging where log_type = 'rights' and log_action... |
7 years ago |
use ruwiki_p;
select * from logging where log_type = 'rights' and log_action... |
7 years ago |
use ruwiki_p;
select * from logging where log_type = 'rights' and log_action... |
7 years ago |
use ruwiki_p;
select * from logging where log_type = 'rights' and log_action... |
7 years ago |
use ruwiki_p;
select * from logging where log_type = 'rights' limit 10;
|
7 years ago |
use ruwiki_p;
select log_user_text, log_timestamp from logging where... |
7 years ago |
use ruwiki_p;
select log_user_text, log_timestamp from logging where... |
7 years ago |
use ruwiki_p;
select log_user_text, log_timestamp from logging where... |
7 years ago |
use ruwiki_p;
select log_user_text, log_timestamp from logging where... |
7 years ago |
use ruwiki_p;
select log_user_text, log_timestamp from logging where... |
7 years ago |
use ruwiki_p;
select log_user_text, log_timestamp from logging where... |
7 years ago |
use ruwiki_p;
select log_user_text from logging where log_type = 'newusers'... |
7 years ago |
use ruwiki_p;
select log_user_text from logging where log_type = 'newusers'... |
7 years ago |
use ruwiki_p;
select log_user_text from logging left join ipblocks on... |
7 years ago |
use ruwiki_p;
select log_title, log_user_text, log_user from logging where... |
7 years ago |
use ruwiki_p;
select log_title, log_user_text, log_user from logging where... |
7 years ago |
use ruwiki_p;
select log_title, log_user_text, log_user from logging where... |
7 years ago |
use ruwiki_p;
select cast(log_title as char) lt from logging where log_type... |
7 years ago |
use ruwiki_p;
select cast(log_title as char) lt from logging where log_type... |
7 years ago |
use ruwiki_p;
select cast(log_title as char) lt from logging where log_type... |
7 years ago |
use ruwiki_p;
select cast(log_title as char) lt from logging where log_type... |
7 years ago |
use ruwiki_p;
select cast (log_title as char) lt from logging where... |
7 years ago |
use ruwiki_p;
select cast (log_title as char) from logging where log_action... |
7 years ago |
use ruwiki_p;
select log_title from logging where log_action = 'block' and... |
7 years ago |
use ruwiki_p;
select log_title from logging where log_action = 'block' and... |
7 years ago |
use ruwiki_p;
select * from logging where log_action = 'block' and... |
7 years ago |
use ruwiki_p;
select * from logging where log_action = "block" and... |
7 years ago |
use ruwiki_p;
select * from logging where log_action = "block" and... |
7 years ago |
use ruwiki_p;
select * from logging where log_action = "block" and... |
7 years ago |
/*use wikidatawiki_p;
select coalesce(x.ips_site_page, z.ips_site_page),... |
7 years ago |
/*use wikidatawiki_p;
select coalesce(x.ips_site_page, z.ips_site_page),... |
7 years ago |
/*use wikidatawiki_p;
select coalesce(x.ips_site_page, z.ips_site_page),... |
7 years ago |
/*use wikidatawiki_p;
select coalesce(x.ips_site_page, z.ips_site_page),... |
7 years ago |
/*use wikidatawiki_p;
select coalesce(x.ips_site_page, z.ips_site_page),... |
7 years ago |
use wikidatawiki_p;
#SELECT *, count(*) FROM wb_items_per_site GROUP BY... |
7 years ago |
use wikidatawiki_p;
#SELECT *, count(*) FROM wb_items_per_site GROUP BY... |
7 years ago |
use wikidatawiki_p;
#SELECT *, count(*) FROM wb_items_per_site GROUP BY... |
7 years ago |
use wikidatawiki_p;
SELECT *, count(*) FROM wb_items_per_site GROUP BY... |
7 years ago |
use wikidatawiki_p;
SELECT *, count(*) FROM wb_items_per_site GROUP BY... |
7 years ago |
use wikidatawiki_p;
SELECT *, count(*) FROM wb_items_per_site GROUP BY... |
8 years ago |
use wikidatawiki_p;
SELECT *, count(*) FROM wb_items_per_site where... |
8 years ago |
use wikidatawiki_p;
SELECT *, count(*) FROM wb_items_per_site GROUP BY... |
8 years ago |
use wikidatawiki_p;
SELECT ips_item_id, count(*) FROM wb_items_per_site... |
8 years ago |
use wikidatawiki_p;
SELECT ips_item_id, count(*) AS cnt FROM... |
8 years ago |
use wikidatawiki_p;
select *, count(*) AS cnt from wb_items_per_site GROUP... |
8 years ago |
use wikidatawiki_p;
select *, count(*) AS cnt from wb_items_per_site order... |
8 years ago |
use wikidatawiki_p;
select *, count(*) AS cnt from wb_items_per_site order... |
8 years ago |
use ruwiki_p;
select cast(user_name as char) user_name, user_editcount from... |
8 years ago |
use ruwiki_p;
select cast(user_name as char) user_name, user_editcount from... |
8 years ago |
use ruwiki_p;
#select cast(user_name as char) user_name, user_editcount from... |
8 years ago |
use ruwiki_p;
#select cast(user_name as char) user_name, user_editcount from... |
8 years ago |
use ruwiki_p;
#select cast(user_name as char) user_name, user_editcount from... |
8 years ago |
use ruwiki_p;
select cast(user_name as char) user_name, user_editcount from... |
8 years ago |
use ruwiki_p;
select cast(user_name as char) user_name, user_editcount from... |
8 years ago |
use ruwiki_p;
select cast(user_name as char) user_name, user_editcount from... |
8 years ago |
use ruwiki_p;
select cast(user_name as char) user_name, user_editcount from... |
8 years ago |
use ruwiki_p;
select cast(user_name as char) user_name from user where... |
8 years ago |
use ruwiki_p;
select rev_user from revision where rev_timestamp > now() -... |
8 years ago |
use ruwiki_p;
select rev_user from revision where rev_timestamp > now() - 90... |
8 years ago |
use ruwiki_p;
select rev_user from revision where rev_timestamp > now() - 90... |
8 years ago |
use ruwiki_p;
select max(rev_timestamp), rev_user
from revisions
group by... |
8 years ago |
use ruwiki_p;
select rev_timestamp from revision join user on... |
8 years ago |
use ruwiki_p;
select rev_timestamp from revision join user on... |
8 years ago |
use ruwiki_p;
#select cast(user_name as char), user_editcount from user left... |
8 years ago |
use ruwiki_p;
select * from revision join user on user_id=rev_user where... |
8 years ago |
use ruwiki_p;
select * from revision join user on user_id=rev_user where... |
8 years ago |
use ruwiki_p;
select * from revision join user on user_id=rev_user where... |
8 years ago |
use ruwiki_p;
select * from revision join user on user_id=rev_user where... |
8 years ago |
use ruwiki_p;
select * from revision join user on user_id=rev_user where... |
8 years ago |
use ruwiki_p;
select * from user left join ipblocks on user_id = ipb_user... |
8 years ago |
use ruwiki_p;
select user_name, user_editcount from user left join ipblocks... |
8 years ago |
use ruwiki_p;
select user_name, user_editcount from user left join ipblocks... |
8 years ago |
use ruwiki_p;
select rev_user, rev_timestamp from revision where... |
8 years ago |
use ruwiki_p;
select rev_user, rev_timestamp from revision where... |
8 years ago |
use ruwiki_p;
select rev_user, rev_timestamp from revision where... |
8 years ago |
use ruwiki_p;
select rev_user, rev_timestamp from revision where... |
8 years ago |
use ruwiki_p;
select rev_user, rev_timestamp from revision where... |
8 years ago |
use ruwiki_p;
select rev_user, rev_timestamp from revision where... |
8 years ago |
use ruwiki_p;
select rev_user, rev_timestamp from revision where... |
8 years ago |
use ruwiki_p;
select user_name, user_editcount from user left join ipblocks... |
8 years ago |
use ruwiki_p;
select user_name, user_editcount from user left join ipblocks... |
8 years ago |
use ruwiki_p;
select user_name, user_editcount from user left join ipblocks... |
8 years ago |
use ruwiki_p;
select page_title, page_len from page where page_namespace=0 limit 100; |
8 years ago |
use ruwiki_p;
select page_title, page_len from page where page_namespace=0 limit 10; |
8 years ago |
use ruwiki_p;
select page_title, page_len from page where page_namespace=0; |
8 years ago |
use ruwiki_p;
select * from user left join ipblocks on user_id = ipb_user... |
8 years ago |
use ruwiki_p;
select user_name, user_editcount, user_touched from user left... |
8 years ago |
use ruwiki_p;
select user_name, user_editcount from user left join ipblocks... |
8 years ago |
use ruwiki_p;
select user_name, user_editcount from user left join ipblocks... |
8 years ago |
use ruwiki_p;
select user_name, user_editcount from user left join ipblocks... |
8 years ago |
use ruwiki_p;
select * from logging where (log_type = 'rights' and... |
8 years ago |
use ruwiki_p;
select * from logging where (log_type = 'rights' and... |
8 years ago |
use ruwiki_p;
select * from logging where (log_type = 'rights' and... |
8 years ago |
use ruwiki_p;
select * from logging where log_title='WebCite Archiver'; |
8 years ago |
use ruwiki_p;
select user_name, user_editcount from user left join ipblocks... |
8 years ago |
use ruwiki_p;
select user_name, user_editcount, log_params from user left... |
8 years ago |
use ruwiki_p;
select user_name, user_editcount, log_params from user left... |
8 years ago |
use ruwiki_p;
select * from user join logging on user_name = log_title where... |
8 years ago |
use ruwiki_p;
select user_name, user_editcount from user left join ipblocks... |
8 years ago |
use ruwiki_p;
select user_name, user_editcount from user left join ipblocks... |
8 years ago |
use ruwiki_p;
select user_name, user_editcount from user left join ipblocks... |
8 years ago |
use ruwiki_p;
select user_name, user_editcount from user left join ipblocks... |
8 years ago |
use ruwiki_p;
select user_name, user_editcount from user left join ipblocks... |
8 years ago |
use ruwiki_p;
select user_name, user_editcount from user left join ipblocks... |
8 years ago |
use ruwiki_p;
select user_name, user_editcount from user join ipblocks on... |
8 years ago |
use ruwiki_p;
select user_name, user_editcount from user join ipblocks on... |
8 years ago |
use ruwiki_p;
select user_name, user_editcount, ipb_expiry from user join... |
8 years ago |
use ruwiki_p;
select user_name, user_editcount, ipb_expiry from user join... |
8 years ago |
use ruwiki_p;
select user_name, user_editcount, ipb_expiry from user join... |
8 years ago |
use ruwiki_p;
select user_name, user_editcount, ipb_expiry from user join... |
8 years ago |
use ruwiki_p;
select user_name, user_editcount, ipb_expiry from user join... |
8 years ago |
use ruwiki_p;
select user_name, user_editcount from user where... |
8 years ago |
use ruwiki_p;
select user_name, user_editcount from user where... |
8 years ago |
use ruwiki_p;
select user_name, user_editcount, ug_group from user where... |
8 years ago |
use ruwiki_p;
select user_name, user_editcount from user where... |
8 years ago |
use ruwiki_p;
select user_name, user_editcount from user where (editcount >... |
8 years ago |
use ruwiki_p;
select user_name, user_editcount from user where (editcount >... |
8 years ago |
use ruwiki_p;
select user_name, user_editcount, ug_group from user where... |
8 years ago |
use ruwiki_p;
select user_name, user_editcount, ug_group from user join... |
8 years ago |
use ruwiki_p;
select user_name, user_editcount, ug_group from user join... |
8 years ago |
use ruwiki_p;
select user_name, user_editcount, ug_group from user where... |
8 years ago |
use ruwiki_p;
select user_name, user_editcount from user where... |
8 years ago |
use ruwiki_p;
select user_name, user_editcount from user where... |
8 years ago |
use ruwiki_p;
select user_name, user_editcount from user where... |
8 years ago |
use ruwiki_p;
select user_name, user_editcount from user where... |
8 years ago |
use ruwiki_p;
select user_name, user_editcount from user where... |
8 years ago |
use ruwiki_p;
select user_name, user_editcount from user where user_id not... |
8 years ago |
use ruwiki_p;
select user_name, ug_group from user join user_groups on... |
8 years ago |
use ruwiki_p;
select user_name, ug_group from user join user_groups on... |
8 years ago |
use ruwiki_p;
select rev_page, count (*) from revision group by rev_page; |
8 years ago |
use ruwiki_p;
select rev_page count (*) from revision group by rev_page; |
8 years ago |
use ruwiki_p;
count (*) from revision group by rev_page; |
8 years ago |
use ruwiki_p;
select * from user join user_properties on user.user_id =... |
8 years ago |
use ruwiki_p;
select user_name from user join user_properties on... |
8 years ago |
use ruwiki_p;
select user_name from user join user_properties on... |
8 years ago |
use ruwiki_p;
select up_value from user join user_properties on user.user_id... |
8 years ago |
use ruwiki_p;
select up_value from user join user_properties on user.user_id... |
8 years ago |
use ruwiki_p;
select count(user_id) from user join user_groups on... |
8 years ago |
use ruwiki_p;
select count (user_id) from user join user_groups on... |
8 years ago |
use ruwiki_p;
select count (user_id) from user join user_groups on... |
8 years ago |
use ruwiki_p;
select count(user_id) from user join user_groups on... |
8 years ago |
use ruwiki_p;
select count (user_id) from user join user_groups on... |
8 years ago |
use ruwiki_p;
select count user_id from user join user_groups on... |
8 years ago |
use ruwiki_p;
select up_value, user_name from user join user_properties on... |
8 years ago |
use ruwiki_p;
select up_value, user_name from user join user_properties on... |
8 years ago |
use ruwiki_p;
select up_value, ug_group, user_id, user_editcount from user... |
8 years ago |
use ruwiki_p;
select up_value, ug_group, user_id, user_editcount from user... |
8 years ago |
use ruwiki_p;
select up_value, ug_group, user_id, user_editcount from user... |
8 years ago |
use ruwiki_p;
select up_value, ug_group, user_id, user_editcount from user... |
8 years ago |
use rowiki_p;
select up_value from user_properties where... |
8 years ago |
use rowiki_p;
select up_value from user_properties where... |
8 years ago |
use rowiki_p;
select up_value from user_properties where... |
8 years ago |
use rowiki_p;
select up_value from user_properties where... |
8 years ago |
use rowiki_p;
select up_value from user_properties where... |
8 years ago |
use ruwiki_p;
select up_value from user_properties where... |
8 years ago |
use ruwiki_p;
select * from user join user_groups on user.user_id =... |
8 years ago |
use ruwiki_p;
select * from user join user_groups on user.user_id =... |
8 years ago |
use ruwiki_p;
select up_value from user join user_groups on user.user_id =... |
8 years ago |
use ruwiki_p;
select up_value from user join user_groups on user.user_id =... |
8 years ago |
use ruwiki_p;
select up_value from user join user_groups on user.user_id =... |
8 years ago |
use ruwiki_p;
select up_value from user join user_groups on user.user_id =... |
8 years ago |
use ruwiki_p;
select up_value from user join user_groups on user.user_id =... |
8 years ago |
use ruwiki_p;
select up_value from user join user_groups on user.user_id =... |
8 years ago |
use ruwiki_p;
select up_value from user join user_groups on user.user_id =... |
8 years ago |
use ruwiki_p;
select up_value from user join user_groups on user.user_id =... |
8 years ago |
use ruwiki_p;
select up_value from user join user_groups on user.user_id =... |
8 years ago |
use enwiki_p;
select up_value from user join user_groups on user.user_id =... |
8 years ago |
use enwiki_p;
#select up_value from user join user_groups on user.user_id =... |
8 years ago |
use ruwiki_p;
select up_value from user join user_groups on user.user_id =... |
8 years ago |
use ruwiki_p;
select * from user join user_groups on user.user_id =... |
8 years ago |
use ruwiki_p;
select * from user join user_groups on user.user_id =... |
8 years ago |
use ruwiki_p;
select * from user join user_groups on user.user_id =... |
8 years ago |
use ruwiki_p;
select up_value from user join user_properties on user.user_id... |
8 years ago |
use ruwiki_p;
select up_value from user join user_properties on user.user_id... |
8 years ago |
use ruwiki_p;
select up_value from user join user_properties on user.user_id... |
8 years ago |
use ruwiki_p;
select up_value from user join user_properties on user.user_id... |
8 years ago |
use ruwiki_p;
select * from user join user_properties on user.user_id =... |
8 years ago |
use ruwiki_p;
select * from user join user_properties on user.user_id =... |
8 years ago |
use ruwiki_p;
select * from user join user_properties on user.user_id =... |
8 years ago |
use ruwiki_p;
select * from user join user_properties on user.user_id =... |
8 years ago |
use ruwiki_p;
select up_value from user join user_properties on user.user_id... |
8 years ago |
use ruwiki_p;
select up_value from user join user_properties on user.user_id... |
8 years ago |
use ruwiki_p;
select up_value from user join user_properties on user.user_id... |
8 years ago |
use ruwiki_p;
select up_value from user join user_properties on user.user_id... |
8 years ago |
use ruwiki_p;
select * from user_properties where up_user = "MaxBioHazard"; |
8 years ago |
use ruwiki_p;
select up_value from user join user_properties on user.user_id... |
8 years ago |
use ruwiki_p;
select up_value from user join user_properties on user.user_id... |
8 years ago |
use ruwiki_p;
select up_value from user join user_properties on user.user_id... |
8 years ago |
use ruwiki_p;
select up_value from user join user_properties on user.user_id... |
8 years ago |
use ruwiki_p;
select up_value from user join user_properties on user.user_id... |
8 years ago |
use ruwiki_p;
select up_value from user join user_properties on user.user_id... |
8 years ago |
use ruwiki_p;
select up_value from user join user_properties on user.user_id... |
8 years ago |
use ruwiki_p;
select * from user where (user_editcount > 1000); |
8 years ago |
use ruwiki_p;
select * from user where (user_editcount = 100); |
8 years ago |
use ruwiki_p;
show tables; |
8 years ago |
use ruwiki_p;
select up_value from user join user_properties on user.user_id... |
8 years ago |
use ruwiki_p;
describe user; |
8 years ago |
use ruwiki_p;
select up_value from user join user_properties on user.user_id... |
8 years ago |
use ruwiki_p;
show columns from user; |
8 years ago |
use ruwiki_p;
select up_value from user join user_properties on user.user_id... |
9 years ago |
use ruwiki_p;
select * from user join user_properties on user.user_id =... |
9 years ago |
use ruwiki_p;
select * from user join user_properties on user.user_id =... |
9 years ago |
use ruwiki_p;
select * from user join user_properties on user.user_id =... |
9 years ago |
use ruwiki_p;
select * from user join user_properties on user.user_id =... |
9 years ago |
use ruwiki_p;
select * from user inner join user_properties on user.user_id... |
9 years ago |
use ruwiki_p;
select * from user_properties limit 100; |
9 years ago |
use ruwiki_p;
select * from user limit 100; |
9 years ago |
use ruwiki_p;
select * from users limit 100; |
9 years ago |
use ruwiki_p;
select * from tag_summary limit 100; |
9 years ago |
use ruwiki_p;
select * from tag_summary where ts_log_id = null limit 100; |
9 years ago |
use ruwiki_p;
select * from tag_summary limit 100; |
9 years ago |
use ruwiki_p;
select * from tag_summary where ts_log_id = '' limit 100; |
9 years ago |
use ruwiki_p;
select * from tag_summary limit 100; |
9 years ago |
use ruwiki_p;
select * from tag_summary where ts_rev_id != '' limit 100; |
9 years ago |
use ruwiki_p;
select * from tag_summary where ts_rc_id != '' limit 100; |
9 years ago |
use ruwiki_p;
select * from tag_summary where ts_log_id = '' limit 100; |
9 years ago |
use ruwiki_p;
select * from tag_summary where ts_log_id == '' limit 100; |
9 years ago |
use ruwiki_p;
select * from tag_summary where ts_log_id == '' limit 100; |
9 years ago |
use ruwiki_p;
select * from tag_summary where ts_log_id=='' limit 100; |
9 years ago |
use ruwiki_p;
select * from tag_summary where ts_log_id!='' limit 100; |
9 years ago |
use ruwiki_p;
select * from tag_summary limit 500; |
9 years ago |
use ruwiki_p;
select * from tag_summary limit 100; |
9 years ago |
use ruwiki_p;
describe revision; |
9 years ago |
use ruwiki_p;
describe revision_userindex; |
9 years ago |
use ruwiki_p;
show tables; |
9 years ago |
use ruwiki_p;
select user_registration from user where (user_registration !=... |
9 years ago |
use ruwiki_p;
select * from user where (user_registration != '' and... |
9 years ago |
use ruwiki_p;
select * from user where (user_registration != '' and... |
9 years ago |
use ruwiki_p;
select * from user where (user_registration != '' and... |
9 years ago |
use ruwiki_p;
select * from user where user_registration != '' limit 100; |
9 years ago |
use ruwiki_p;
select user_registration from user where user_registration !=... |
9 years ago |
use ruwiki_p;
select user_registration from user limit 100; |
9 years ago |
use ruwiki_p;
describe user; |
9 years ago |
use ruwiki_p;
show tables; |
9 years ago |
use ruwiki_p;
describe user_properties; |
9 years ago |
use ruwiki_p;
describe; |
9 years ago |
use ruwiki_p;
select * from user where user_name = 'Adavyd'; |
9 years ago |
use ruwiki_p;
select * from user where user_name = 'adavyd'; |
9 years ago |
use ruwiki_p;
select * from user limit 1000; |
9 years ago |
use ruwiki_p;
select * from user_daily_contribs limit 1000; |
9 years ago |
use ruwiki_p;
select * from user_daily_contribs limit 100; |
9 years ago |
use ruwiki_p;
select * from user_groups limit 100; |
9 years ago |
use ruwiki_p;
select * from user_groups limit 100; |
9 years ago |
use ruwiki_p;
select * from user_groups limit 100; |
9 years ago |
use ruwiki_p;
show tables; |
9 years ago |
use ruwiki_p;
select * from users limit 100; |
9 years ago |
use ruwiki_p;
select * from page where page_namespace = 0; |
9 years ago |
use ruwiki_p;
select * from page where page_namespace = 0 limit 1500; |
9 years ago |
use ruwiki_p;
select * from page where page_namespace = 0 limit 500; |
9 years ago |
use ruwiki_p;
select * from page where page_namespace = 0 limit 100; |
9 years ago |
use ruwiki_p;
select * from page limit 100; |
9 years ago |
use ruwiki_p;
select * from page where page_namespace = 0 limit 100; |
9 years ago |
use ruwiki_p;
select * from page where page_namespace == '0' limit 100; |
9 years ago |
use ruwiki_p;
select * from page where page_namespace = '0' limit 100; |
9 years ago |
use ruwiki_p;
select * from page limit 100; |
9 years ago |
use ruwiki_p;
select * from watchlist limit 100; |
9 years ago |
use ruwiki_p;
select * from log_search limit 100; |
9 years ago |
use ruwiki_p;
select * from logging where log_type != 'abusefilter' limit 100; |
9 years ago |
use ruwiki_p;
select * from logging where log_type != abusefilter limit 100; |
9 years ago |
use ruwiki_p;
select * from logging limit 100; |
9 years ago |
use ruwiki_p;
select * from l10n_cache limit 100; |
9 years ago |
use ruwiki_p;
show tables; |
9 years ago |
use ruwiki_p;
select * from user_properties limit 100; |
9 years ago |
use ruwiki_p;
select * from job limit 100; |
9 years ago |
use ruwiki_p;
select * from user_newtalk limit 100; |
9 years ago |
use ruwiki_p;
select * from user_newtalk limit 100; |
9 years ago |
use ruwiki_p;
select * from user_properties where up_property='language'; |
9 years ago |
use ruwiki_p;
select * from user_properties where up_property!='language'; |
9 years ago |
use ruwiki_p;
select * from user_properties where (up_property!='gender' and... |
9 years ago |
use ruwiki_p;
select * from user_properties where (up_property!='gender' and... |
9 years ago |
use ruwiki_p;
select * from user_properties where (up_property!='gender' and... |
9 years ago |
use ruwiki_p;
select * from user_properties where (up_property!='gender' and... |
9 years ago |
use ruwiki_p;
select * from user_properties where (up_property!='gender' and... |
9 years ago |
use ruwiki_p;
select * from user_properties where (up_property!='gender' and... |
9 years ago |
use ruwiki_p;
select * from user_properties where up_property!='gender' limit 100; |
9 years ago |
use ruwiki_p;
select * from user_properties where up_property='gender' limit 500; |
9 years ago |
use ruwiki_p;
select * from user_properties where up_user='500000' limit 500; |
9 years ago |
use ruwiki_p;
select * from user_properties where up_user='40000' limit 500; |
9 years ago |
use ruwiki_p;
select * from user_properties where up_user='21982' limit 500; |
9 years ago |
use ruwiki_p;
select * from user_properties where... |
9 years ago |
use ruwiki_p;
select * from user_properties limit 500; |
9 years ago |
use ruwiki_p;
select * from user_properties where... |
9 years ago |
use ruwiki_p;
select * from user_properties limit 500; |
9 years ago |
use ruwiki_p;
select * from user_properties where... |
9 years ago |
use ruwiki_p;
select * from user_properties where... |
9 years ago |
use ruwiki_p;
select * from user_properties where up_value != '' limit 100; |
9 years ago |
use ruwiki_p;
select * from user_properties where... |
9 years ago |
use ruwiki_p;
select * from user_properties where up_user = '529055' limit 1000; |
9 years ago |
use ruwiki_p;
select * from user_properties where... |
9 years ago |
use ruwiki_p;
select * from user_properties where... |
9 years ago |