| USE ukwiki_p;
SELECT
concat('[[', page_title, ']]'),
COUNT(1) AS... |
7 years ago |
| USE ukwiki_p;
SELECT
concat('[[', page_title, ']]'),
COUNT(1) AS... |
7 years ago |
| USE ukwiki_p;
SELECT
CASE page_namespace
WHEN 0 THEN ''
WHEN 1 THEN... |
7 years ago |
| USE ukwiki_p;
SELECT
CASE page_namespace
WHEN 0 THEN ''
WHEN 1 THEN... |
7 years ago |
| USE ukwiki_p;
SELECT
CASE page_namespace
WHEN 0 THEN ''
WHEN 1 THEN... |
7 years ago |
| USE ukwiki_p;
SELECT
CASE page_namespace
WHEN 0 THEN ''
WHEN 1 THEN... |
7 years ago |
| USE ukwiki_p;
SELECT
CASE page_namespace
WHEN 0 THEN ''
WHEN 1 THEN... |
7 years ago |
| USE ukwiki_p;
SELECT page_namespace, page_title, COUNT(1) AS edits FROM... |
7 years ago |
| USE ukwiki_p;
SELECT page_title, COUNT(1) AS edits FROM revision, page... |
7 years ago |
| USE ukwiki_p;
SELECT page_title, COUNT(1) AS edits FROM revision, page... |
7 years ago |
| USE ukwikibooks_p;
SELECT page_title, COUNT(1) AS edits FROM revision, page... |
7 years ago |
| USE ukwikibooks_p;
SELECT page_title, COUNT(1) AS edits FROM revision, page... |
7 years ago |
| USE ukwikibooks_p;
SELECT page_title, count(1) from revision, page where... |
7 years ago |
| USE ukwikibooks_p;
SELECT page_title, rev_comment from revision, page where... |
7 years ago |
| USE ukwikibooks_p;
SELECT page_title, rev_comment from revision, page where... |
7 years ago |
| USE ukwikibooks_p;
SELECT page_title, rev_comment from revision, page where... |
7 years ago |
| USE ukwikibooks_p;
SELECT rev_page, rev_comment from revision where... |
7 years ago |
| USE ukwikibooks_p;
SELECT * from revision where rev_user = (
SELECT... |
7 years ago |
| USE ukwikibooks_p;
SELECT * from revision where revision.user_id =... |
7 years ago |
| USE ukwikibooks_p;
SELECT * from revision where revision.user_id =... |
7 years ago |
| USE ukwikibooks_p;
SELECT user_id FROM user where user.user_name = 'Bunyk'; |
7 years ago |
| USE ukwikibooks_p;
SELECT user_id FROM user where user.user_name == 'Bunyk'; |
7 years ago |
| SELECT * FROM ukwikibooks_p.user limit 10; |
7 years ago |
| SELECT * FROM ukwikibooks_p.page where page_namespace = 2; |
7 years ago |
| SELECT * FROM ukwikibooks_p.page; |
7 years ago |
| SELECT * FROM ukwiki_p.page; |
7 years ago |
| SELECT * FROM ukwikipedia_p.page; |
7 years ago |
