| USE bgwiki_p;
SELECT user_id, user_editcount, rev_page, rev_user,... |
6 years ago |
| USE huwiki_p;
SELECT user_id, user_editcount, rev_page, rev_user,... |
6 years ago |
| USE huwiki_p;
SELECT user_id, user_editcount, rev_page, rev_user
FROM user... |
6 years ago |
| USE ruwiki_p;
SELECT user_id, user_editcount, rev_page, rev_user
FROM user... |
6 years ago |
| USE ruwiki_p;
SELECT user_id, user_editcount, rev_page, rev_user,... |
6 years ago |
| USE ruwiki_p;
SELECT user_id, user_editcount, rev_page, rev_user,... |
6 years ago |
| USE ruwiki_p;
SELECT user_id, user_editcount, rev_page, rev_user,... |
6 years ago |
| USE ruwiki_p;
SELECT page_id, page_touched, rc_timestamp FROM page
JOIN... |
6 years ago |
| USE ruwiki_p;
SELECT page_id, page_touched, rc_timestamp FROM page
JOIN... |
6 years ago |
| USE huwiki_p;
SELECT ll_from, COUNT(DISTINCT ll_title) AS links, rev_page,... |
6 years ago |
| USE ruwiki_p;
SELECT ll_from, COUNT(DISTINCT ll_title) AS links, rev_page,... |
6 years ago |
| USE ruwiki_p;
SELECT ll_from, COUNT(DISTINCT ll_title) AS links, rev_page,... |
6 years ago |
| USE ruwiki_p;
SELECT ll_from, COUNT(DISTINCT ll_title) AS links, rev_page,... |
6 years ago |
| USE ruwiki_p;
SELECT ll_from, COUNT(DISTINCT ll_title) AS links, rev_page,... |
6 years ago |
| USE ruwiki_p;
SELECT ll_from, COUNT(DISTINCT ll_title) AS links, rev_page,... |
6 years ago |
| USE ruwiki_p;
SELECT ll_from, COUNT(DISTINCT ll_title) AS links, rev_page,... |
6 years ago |
| USE ruwiki_p;
SELECT ll_from, COUNT(DISTINCT ll_title) AS links, rev_page,... |
6 years ago |
| USE ruwiki_p;
SELECT ll_from, COUNT(DISTINCT ll_title) AS links, rev_page,... |
6 years ago |
| USE ruwiki_p;
SELECT ll_from, COUNT(DISTINCT ll_title) AS links, rev_page,... |
6 years ago |
| USE ruwiki_p;
SHOW TABLES;
DESCRIBE user;
#SELECT ll_from, COUNT(DISTINCT... |
6 years ago |
| USE ruwiki_p;
SHOW TABLES;
DESCRIBE user
#SELECT ll_from, COUNT(DISTINCT... |
6 years ago |
| USE ruwiki_p;
SHOW TABLES;
#SELECT ll_from, COUNT(DISTINCT ll_title) AS... |
6 years ago |
| USE ruwiki_p;
DESCRIBE TABLES;
#SELECT ll_from, COUNT(DISTINCT ll_title) AS... |
6 years ago |
| USE ruwiki_p;
SELECT ll_from, COUNT(DISTINCT ll_title) AS links, rev_page,... |
6 years ago |
| USE ruwiki_p;
SELECT ll_from, COUNT(DISTINCT ll_title) AS links, rev_page,... |
6 years ago |
| USE ruwiki_p;
SELECT ll_from, COUNT(DISTINCT ll_title) AS links, rev_page,... |
6 years ago |
| USE ruwiki_p;
SELECT ll_from, COUNT(DISTINCT ll_title) AS links, rev_page,... |
6 years ago |
| USE ruwiki_p;
SELECT ll_from, COUNT(DISTINCT ll_title) FROM langlinks GROUP... |
6 years ago |
| USE ruwiki_p;
select count(*), ll_lang from langlinks limit 10;
|
6 years ago |
| USE ruwiki_p;
SELECT ll_from, COUNT(ll_title) FROM langlinks LIMIT 10;
|
6 years ago |
| USE ruwiki_p;
SELECT COUNT(ll_title) AS links FROM langlinks LIMIT 10;
|
6 years ago |
| USE ruwiki_p;
SELECT COUNT(DISTINCT ll_title) AS links FROM langlinks LIMIT 10;
|
6 years ago |
| USE ruwiki_p;
SELECT COUNT(DISTINCT ll_title) AS links, rev_page,... |
6 years ago |
| USE ruwiki_p;
SELECT rev_page, COUNT(DISTINCT rev_user) AS editors,... |
6 years ago |
| USE ruwiki_p;
SELECT rev_page, COUNT(DISTINCT rev_user) AS editors,... |
6 years ago |
| USE ruwiki_p;
SELECT rev_page, COUNT(DISTINCT rev_user) AS editors,... |
6 years ago |
| USE ruwiki_p;
SELECT rev_page, rev_user, COUNT(DISTINCT rev_user) AS editors... |
6 years ago |
| USE ruwiki_p;
SELECT ll_from, ll_lang FROM langlinks LIMIT 10; |
6 years ago |
| USE ruwiki_p;
SELECT ll_from, ll_lang FROM langlinks JOIN page on page_id =... |
6 years ago |
| USE ruwiki_p;
SELECT ll_from, ll_lang FROM langlinks LIMIT 10; |
6 years ago |
| USE ruwiki_p;
SELECT ll_from, ll_lang FROM langlinks; |
6 years ago |
| USE ruwiki_p;
DESCRIBE langlinks;
SELECT * FROM langlinks LIMIT 10; |
6 years ago |
| USE ruwiki_p;
DESCRIBE page;
SELECT page_id, page_counter FROM page LIMIT 10; |
6 years ago |
| USE ruwiki_p;
DESCRIBE page;
SELECT page_counter FROM page LIMIT 10; |
6 years ago |
| USE ruwiki_p;
DESCRIBE pagelinks;
SELECT page_counter FROM page LIMIT 10; |
6 years ago |
| USE ruwiki_p;
DESCRIBE pagelinks;
SELECT * FROM pagelinks LIMIT 10; |
6 years ago |
| USE ruwiki_p;
DESCRIBE pagelinks; |
6 years ago |
| USE ruwiki_p;
SHOW TABLES; |
6 years ago |
| USE ruwiki_p;
SELECT * from revision; |
6 years ago |
| USE ruwiki_p;
DESCRIBE revision; |
6 years ago |
| USE ruwiki_p;
DESCRIBE ep_articles; |
6 years ago |
| USE ruwiki_p;
SHOW TABLES;
DESCRIBE ep_articles; |
6 years ago |
| USE ruwiki_p;
SHOW TABLES;
DESCRIBE ep_articles.article_id; |
6 years ago |
| USE ruwiki_p;
SHOW TABLES;
DESCRIBE article_id; |
6 years ago |
| USE ruwiki_p;
SHOW TABLES;
DESCRIBE article_id from ep_articles; |
6 years ago |
| USE ruwiki_p;
SHOW TABLES;
DESCRIBE ep_articles; |
6 years ago |
| USE ruwiki_p;
SHOW TABLES |
6 years ago |
| USE ruwiki_p; |
6 years ago |
