| select page_title, COUNT(*) from iwlinks
inner join page on iwl_from =... |
3 years ago |
| #select iwl_from, COUNT(*) from iwlinks
#inner join page on iwl_from =... |
3 years ago |
| select iwl_from, COUNT(*) from iwlinks
inner join page on iwl_from =... |
3 years ago |
| select iwl_from, COUNT(*) from iwlinks
inner join page on iwl_from =... |
3 years ago |
| select iwl_from, COUNT(*) from iwlinks
inner join page on iwl_from =... |
3 years ago |
| #select iwl_from, COUNT(*) from iwlinks group by iwl_from... |
3 years ago |
| #select iwl_from, COUNT(*) from iwlinks group by iwl_from... |
3 years ago |
| select iwl_from, COUNT(*) from iwlinks group by iwl_from... |
3 years ago |
| #select iwl_from, COUNT(*) from iwlinks group by iwl_from... |
3 years ago |
| select iwl_from, COUNT(*) from iwlinks group by iwl_from... |
3 years ago |
| select iwl_from, COUNT(*) from iwlinks group by iwl_from having(Count(*)>1000); |
3 years ago |
| select iwl_from, COUNT(*) from iwlinks group by iwl_from having(Count(*)>100); |
3 years ago |
| select * from iwlinks where iwl_from=1758750; |
3 years ago |
| select * from iwlinks limit 10; |
3 years ago |
| show databases; |
3 years ago |
| show databases; |
3 years ago |
| show databases; |
3 years ago |
| show databases; |
3 years ago |
| select * from iwl_from limit 10; |
3 years ago |
| USE ruwiki_p;
select count(rev_page)
from revision
#group by rev_page... |
3 years ago |
| SELECT actor_name, COUNT(*) edits
FROM user_groups
INNER JOIN... |
3 years ago |
| USE ruwiki_p;
SELECT actor_name, COUNT(*) edits
FROM... |
3 years ago |
| USE ruwiki_p;
SELECT rev_actor, COUNT(*) edits
FROM revision_userindex
INNER... |
3 years ago |
| USE ruwiki_p;
/*
SELECT rev_actor, COUNT(*) edits
FROM... |
3 years ago |
| USE ruwiki_p;
/*
SELECT actor_name, COUNT(*) edits
FROM... |
3 years ago |
| USE ruwiki_p;
/*
SELECT actor_name, COUNT(*) edits
FROM... |
3 years ago |
| USE ruwiki_p;
SELECT actor_name, COUNT(*) edits
FROM... |
3 years ago |
| USE ruwiki_p;
SELECT log_actor, log_type, log_action, log_namespace,... |
3 years ago |
| USE ruwiki_p;
SELECT * from logging_userindex LIMIT 10; |
3 years ago |
| SELECT *
FROM ruwiki_p.categorylinks
INNER JOIN ruwiki_p.page ON cl_from... |
4 years ago |
| use ;
SELECT *
FROM ruwiki_p.categorylinks
INNER JOIN ruwiki_p.page ON... |
4 years ago |
| use ruwiki_p;
SELECT *
FROM wikidatawiki_p.wb_items_per_site WHERE... |
4 years ago |
| use ruwiki_p;
SELECT *
FROM wikidatawiki_p.wb_items_per_site LIMIT 10;
-- ... |
4 years ago |
| use ruwiki_p;
SELECT *
FROM categorylinks
INNER JOIN page ON cl_from =... |
4 years ago |
| use ruwiki_p;
SELECT *
FROM categorylinks
INNER JOIN page ON cl_from =... |
4 years ago |
| use ruwiki_p;
SELECT *
FROM categorylinks
INNER JOIN page ON cl_from =... |
4 years ago |
| use ruwiki_p;
SELECT *
FROM categorylinks
WHERE cl_to =... |
4 years ago |
| use ruwiki_p;
SELECT *
FROM categorylinks LIMIT 10;
-- INNER JOIN... |
4 years ago |
| USE wikidatawiki_p;
#show tables;
SELECT * FROM wbt_item_terms limit... |
4 years ago |
| use ruwiki_p;
SELECT *
FROM (SELECT rev_page, MIN(rev_id) AS rev_id FROM... |
4 years ago |
| use ruwiki_p;
SELECT *
FROM (SELECT rev_page, MIN(rev_id) AS rev_id FROM... |
4 years ago |
| use ruwiki_p;
SELECT * FROM page p
INNER JOIN (SELECT rev_page, MIN(rev_id)... |
4 years ago |
| use ruwiki_p;
SELECT * FROM page p
INNER JOIN (SELECT rev_page, MIN(rev_id)... |
4 years ago |
| use ruwiki_p;
#select * from revision where rev_actor=2105467;
#select... |
4 years ago |
| use ruwiki_p;
#select * from revision where rev_actor=2105467;
#select... |
4 years ago |
| use ruwiki_p;
#select * from revision where rev_actor=2105467;
#select... |
4 years ago |
| show columns from logging_userindex;
#show tables;
#select * from... |
4 years ago |
| show columns logging_userindex;
#show tables;
#select * from... |
4 years ago |
| show columns logging_userindex;
#show tables;
#select * from... |
4 years ago |
| #show tables;
#select * from logging_userindex limit 10;
show columns... |
4 years ago |
| #show tables;
#select * from logging_userindex limit 10;
show columns... |
4 years ago |
| #show tables;
#select * from logging_userindex limit 10;
show columns... |
4 years ago |
| #show tables;
#select * from logging_userindex limit 10;
show columns... |
4 years ago |
| #show tables;
#select * from logging_userindex limit 10;
show columns... |
4 years ago |
| #show tables;
#select * from logging_userindex limit 10;
show columns... |
4 years ago |
| #show tables;
#select * from logging_userindex limit 10;
show table... |
4 years ago |
| #show tables;
#select * from logging_userindex limit 10;
show table... |
4 years ago |
| #show tables;
#select * from logging_userindex limit 10;
describe table... |
4 years ago |
| #show tables;
select * from logging_userindex limit 10;
#SHOW INDEX FROM logging;
|
4 years ago |
| #show tables;
#select * from logging_logindex limit 10;
SHOW INDEX FROM logging;
|
4 years ago |
| #show tables;
#select * from logging_logindex limit 10;
SHOW INDEX FROM... |
4 years ago |
| #show tables;
select * from logging_logindex limit 10; |
4 years ago |
| show tables; |
4 years ago |
| select * from logging_userindex limit 10; |
4 years ago |
