use ruwiki_p;
#select cl_from, page_id as cl_to from categorylinks inner... |
4 years ago |
use ruwiki_p;
#select cl_from, page_id as cl_to from categorylinks inner... |
4 years ago |
use ruwiki_p;
#select cl_from, page_id as cl_to from categorylinks inner... |
4 years ago |
use ruwiki_p;
select cl_from, page_id as cl_to from categorylinks inner join... |
4 years ago |
use ruwiki_p;
select cl_from, page_id as cl_to from categorylinks inner join... |
4 years ago |
use ruwiki_p;
select cl_from, page_id as cl_to from categorylinks inner join... |
4 years ago |
use ruwiki_p;
select cl_from, page_id as cl_to from categorylinks inner join... |
4 years ago |
use ruwiki_p;
select cl_from, page_id as cl_to from categorylinks inner join... |
4 years ago |
use ruwiki_p;
select cl_from, page_id from categorylinks inner join page on... |
4 years ago |
use ruwiki_p;
select cl_from, page_id as cl_to from categorylinks inner join... |
4 years ago |
use ruwiki_p;
select cl_from, page_id as cl_to from categorylinks inner join... |
4 years ago |
use ruwiki_p;
select * from recentchanges inner join actor on rc_actor =... |
4 years ago |
use ruwiki_p;
select * from recentchanges inner join actor on rc_actor =... |
4 years ago |
use ruwiki_p;
select rc_title, rc_actor, actor_name, rc_params from... |
4 years ago |
use ruwiki_p;
select rc_title, rc_actor, actor_name, rc_log_type from... |
4 years ago |
use ruwiki_p;
select rc_title, rc_actor, actor_name, rc_ip from... |
4 years ago |
use ruwiki_p;
select rc_title, rc_actor, actor_name from recentchanges inner... |
4 years ago |
use ruwiki_p;
select rc_title, rc_actor, actor_name from recentchanges inner... |
4 years ago |
use ruwiki_p;
select rc_title, rc_actor from recentchanges where rc_new limit 10; |
4 years ago |
use ruwiki_p;
select rc_title from recentchanges where rc_new limit 10; |
4 years ago |
use ruwiki_p;
select rc_title from recentchanges where rc_new and not rc_redirect; |
4 years ago |
use ruwiki_p;
select * from recentchanges where rc_new and not rc_redirect; |
4 years ago |
use ruwiki_p;
select * from recentchanges where rc_new and not rc_redirect; |
4 years ago |
use ruwiki_p;
select * from recentchanges where rc_new and !rc_redirect; |
4 years ago |
use ruwiki_p;
select * from recentchanges where rc_new and !rc_redirect; |
4 years ago |
use ruwiki_p;
select rc_cur_id, rc_timestamp, rc_actor, rc_namespace,... |
4 years ago |
use ruwiki_p;
select cl_from, group_concat(cl_to)
from categorylinks
group... |
4 years ago |
use ruwiki_p;
select cl_from, group_concat(cl_to)
from categorylinks
limit... |
4 years ago |
use ruwiki_p;
select rc_cur_id, max(rc_timestamp), max(rc_actor),... |
4 years ago |
use ruwiki_p;
select rc_cur_id, rc_timestamp, rc_actor, rc_namespace,... |
4 years ago |
use ruwiki_p;
select rc_cur_id, rc_timestamp, rc_actor, rc_namespace,... |
4 years ago |
use ruwiki_p;
select rc_cur_id, rc_timestamp, rc_actor, rc_namespace,... |
4 years ago |
use ruwiki_p;
select rc_cur_id, rc_timestamp, rc_actor, rc_namespace,... |
4 years ago |
use ruwiki_p;
select rc_cur_id, rc_timestamp, rc_actor, rc_namespace
from... |
4 years ago |
use ruwiki_p;
select rc_cur_id, rc_timestamp, rc_actor, rc_namespace,... |
4 years ago |
use ruwiki_p;
select rc_cur_id, rc_timestamp, rc_actor, rc_namespace,... |
4 years ago |
use ruwiki_p;
select rc_id, rc_timestamp, rc_actor, rc_namespace
from... |
4 years ago |
use ruwiki_p;
select rc_id, rc_timestamp, rc_actor, rc_namespace, cl_to
from... |
4 years ago |
use ruwiki_p;
select rc_id, rc_timestamp, rc_actor, rc_namespace,... |
4 years ago |
use ruwiki_p;
select rc_id, rc_timestamp, rc_actor, rc_namespace,... |
4 years ago |
use ruwiki_p;
select rc_id, rc_timestamp, rc_actor, rc_namespace,... |
4 years ago |
use ruwiki_p;
select rc_id, rc_timestamp, rc_actor, rc_namespace,... |
4 years ago |
use ruwiki_p;
select rc_id, rc_timestamp, rc_actor, rc_namespace from... |
4 years ago |
use ruwiki_p;
select cl_from, group_concat(cl_to) from categorylinks where... |
4 years ago |
use ruwiki_p;
select group_concat(cl_to) from categorylinks where cl_from = "7"; |
4 years ago |
use ruwiki_p;
select concat(cl_to) from categorylinks where cl_from = "7"; |
4 years ago |
use ruwiki_p;
select sum(cl_to) from categorylinks where cl_from = "7"; |
4 years ago |
use ruwiki_p;
select STRING_AGG(cl_to) from categorylinks where cl_from = "7"; |
4 years ago |
use ruwiki_p;
select stringi_agg(cl_to) from categorylinks where cl_from = "7"; |
4 years ago |
use ruwiki_p;
select string_agg(cl_to) from categorylinks where cl_from = "7"; |
4 years ago |
use ruwiki_p;
select * from categorylinks where cl_from = "7"; |
4 years ago |
use ruwiki_p;
select * from categorylinks limit where cl_from = "7"; |
4 years ago |
use ruwiki_p;
select * from categorylinks limit where cl_from = 7; |
4 years ago |
use ruwiki_p;
select * from categorylinks limit 10; |
4 years ago |
use ruwiki_p;
select * from slots limit 10; |
4 years ago |
use ruwiki_p;
select * from content limit 10; |
4 years ago |
use ruwiki_p;
select * from pagecontent limit 10; |
4 years ago |
use ruwiki_p;
select * from text limit 10; |
4 years ago |
use ruwiki_p;
select * from page limit 10; |
4 years ago |
use ruwiki_p;
select rc_id, rc_timestamp, rc_actor, rc_namespace from... |
4 years ago |
use ruwiki_p;
select rc_id, rc_timestamp, rc_actor, rc_namespace from... |
4 years ago |
use ruwiki_p;
select * from recentchanges where rc_new limit 10; |
4 years ago |
use ruwiki_p;
select * from recentchanges limit 10; |
4 years ago |
use ruwiki_p;
select * from logging where log_action="create" limit 10; |
4 years ago |
use ruwiki_p;
select * from logging where log_namespace=0 and... |
4 years ago |
use ruwiki_p;
select * from logging limit 10; |
4 years ago |
use ruwiki_p;
select * from page where page_is_new limit 10; |
4 years ago |
use ruwiki_p;
select * from page limit 10; |
4 years ago |
use ruwiki_p;
select rev_id, rev_page, rev_actor, rev_deleted from revision... |
4 years ago |
use ruwiki_p;
select rev_id, rev_page, rev_actor, rev_deleted from revision... |
4 years ago |
use ruwiki_p;
select rev_id, rev_page, rev_actor, rev_deleted from revision; |
4 years ago |
use ruwiki_p;
select rev_id, rev_page, rev_actor from revision limit 10; |
4 years ago |
use ruwiki_p;
select rev_id, rev_actor, rev_timestamp from revision limit 10; |
4 years ago |
use ruwiki_p;
select * from revision limit 10; |
4 years ago |
use ruwiki_p;
select log_timestamp, log_title, log_params, comment_text
from... |
4 years ago |
use ruwiki_p;
select log_timestamp, log_title, log_params, comment_text
from... |
4 years ago |
use ruwiki_p;
select log_timestamp, log_title, log_params, comment_text
from... |
4 years ago |
use ruwiki_p;
select log_title, log_params, comment_text
from logging
inner... |
4 years ago |
use ruwiki_p;
select log_title, log_params, comment_text
from logging
inner... |
4 years ago |
use ruwiki_p;
select log_id, log_actor, log_title, log_page, log_params,... |
4 years ago |
use ruwiki_p;
select log_id, log_actor, log_title, log_params,... |
4 years ago |
use ruwiki_p;
select comment_text
from logging
inner join comment
on... |
4 years ago |
use ruwiki_p;
select comment_text
from logging_userindex
inner join... |
4 years ago |
use ruwiki_p;
select log_actor, comment_text, comment_data from... |
4 years ago |
use ruwiki_p;
select * from logging_userindex where log_type = "renameuser" limit 5; |
4 years ago |
use ruwiki_p;
select * from logging_logindex where log_type = "renameuser" limit 5; |
4 years ago |
use ruwiki_p;
select * from logging where log_type = "renameuser" limit 5; |
4 years ago |
use ruwiki_p;
select * from logging where log_type = "renameuser" limit 1000; |
4 years ago |
use ruwiki_p;
select * from logging where log_type = "renameuser" limit 100; |
4 years ago |
use ruwiki_p;
select * from logging where log_type = "renameuser"; |
4 years ago |
use ruwiki_p;
select * from logging where log_type = "renameuser" limit 10; |
4 years ago |
use ruwiki_p;
select * from logging limit 10; |
4 years ago |