| # Find articles that have only been edited by one human editor. Such... |
4 years ago |
| # Find articles that have only been edited by one human editor. Such... |
4 years ago |
| # Find articles that have only been edited by one human editor. Such... |
4 years ago |
| USE enwiki_p;
SELECT page_title, page_len, COUNT(rev_actor) FROM
(
SELECT... |
4 years ago |
| USE enwiki_p;
SELECT page_title, page_len, COUNT(rev_actor) FROM
(
SELECT... |
4 years ago |
| USE enwiki_p;
SELECT page_title, page_len, COUNT(rev_actor) FROM
(
SELECT... |
4 years ago |
| USE enwiki_p;
SELECT page_title, page_len, COUNT(rev_actor) FROM
(
SELECT... |
4 years ago |
| USE enwiki_p;
SELECT page_title, page_len, COUNT(rev_actor) FROM
(
SELECT... |
4 years ago |
| USE enwiki_p;
SELECT page_title, page_len, COUNT(rev_actor) FROM
(
SELECT... |
4 years ago |
| USE enwiki_p;
SELECT page_title, page_len, COUNT(rev_actor) FROM
(
SELECT... |
4 years ago |
| USE enwiki_p;
SELECT page_title, page_len, COUNT(rev_actor) FROM
(
SELECT... |
4 years ago |
| USE enwiki_p;
SELECT page_title, page_len, COUNT(rev_actor) FROM
(
SELECT... |
4 years ago |
| USE enwiki_p;
SELECT page_title, page_len, COUNT(rev_actor) FROM
(
SELECT... |
4 years ago |
| USE enwiki_p;
SELECT page_title, page_len, COUNT(rev_actor) FROM
(
SELECT... |
4 years ago |
| USE enwiki_p;
SELECT page_title, page_len, COUNT(rev_actor) FROM
(
SELECT... |
4 years ago |
| USE enwiki_p;
SELECT page_title, page_len, COUNT(rev_actor) FROM
(
SELECT... |
4 years ago |
| USE enwiki_p;
SELECT page_title, page_len, COUNT(rev_actor) FROM
(
SELECT... |
4 years ago |
| USE enwiki_p;
SELECT page_title, page_len, COUNT(rev_actor) FROM
(
SELECT... |
4 years ago |
| USE enwiki_p;
SELECT page_title, page_len, COUNT(rev_actor) FROM
(
SELECT... |
4 years ago |
| USE enwiki_p;
SELECT page_title, page_len, COUNT(rev_actor) FROM
(
SELECT... |
4 years ago |
| USE enwiki_p;
SELECT page_title, page_len, COUNT(rev_actor) FROM
(
SELECT... |
4 years ago |
| USE enwiki_p;
SELECT page_title, page_len, COUNT(rev_actor) FROM
(
SELECT... |
4 years ago |
| USE enwiki_p;
SELECT page_title, page_len, COUNT(rev_actor) FROM
(
SELECT... |
4 years ago |
| USE enwiki_p;
SELECT page_title, page_len, COUNT(rev_actor) FROM
(
SELECT... |
4 years ago |
| USE enwiki_p;
SELECT page_title, COUNT(rev_actor) FROM
(
SELECT DISTINCT... |
4 years ago |
| USE enwiki_p;
SELECT page_title, COUNT(rev_actor) FROM
(
SELECT DISTINCT... |
4 years ago |
| USE enwiki_p;
SELECT page_title, COUNT(rev_actor) FROM
(
SELECT DISTINCT... |
4 years ago |
| USE enwiki_p;
SELECT page_title, COUNT(rev_actor) FROM
(
SELECT DISTINCT... |
4 years ago |
| USE enwiki_p;
SELECT page_title, COUNT(rev_actor) FROM
(
SELECT DISTINCT... |
4 years ago |
| USE enwiki_p;
SELECT page_title, COUNT(rev_actor) FROM
(
SELECT DISTINCT... |
4 years ago |
| # TODO
# Group by page_title (subquery?) and get only those whose count is... |
4 years ago |
| # TODO
# Group by page_title (subquery?) and get only those whose count is... |
4 years ago |
| # TODO
# Group by page_title (subquery?) and get only those whose count is... |
4 years ago |
| # TODO
# Group by page_title (subquery?) and get only those whose count is... |
4 years ago |
| # TODO
# Group by page_title (subquery?) and get only those whose count is... |
4 years ago |
| # TODO
# Group by page_title (subquery?) and get only those whose count is... |
4 years ago |
| # TODO
# Group by page_title (subquery?) and get only those whose count is... |
4 years ago |
| # TODO
# Group by page_title (subquery?) and get only those whose count is... |
4 years ago |
| # TODO
# Group by page_title (subquery?) and get only those whose count is... |
4 years ago |
| # TODO
# Group by page_title (subquery?) and get only those whose count is... |
4 years ago |
| # TODO
# Group by page_title (subquery?) and get only those whose count is... |
4 years ago |
| # TODO
# Group by page_title (subquery?) and get only those whose count is... |
4 years ago |
| # TODO
# Group by page_title (subquery?) and get only those whose count is... |
4 years ago |
| # TODO
# Join with actor table to get username, in order to exclude bots
#... |
4 years ago |
| # TODO
# Join with actor table to get username, in order to exclude bots
#... |
4 years ago |
| # TODO
# Join with actor table to get username, in order to exclude bots
#... |
4 years ago |
| # TODO
# Join with actor table to get username, in order to exclude bots
#... |
4 years ago |
| # TODO
# Join with actor table to get username, in order to exclude bots
#... |
4 years ago |
| USE enwiki_p;
SELECT DISTINCT p.page_title, p.page_len , r.rev_actor #,... |
4 years ago |
| USE enwiki_p;
SELECT p.page_title, p.page_len , r.rev_actor #,... |
4 years ago |
| USE enwiki_p;
SELECT UNIQUE p.page_title, p.page_len , r.rev_actor #,... |
4 years ago |
| USE enwiki_p;
SELECT p.page_title, p.page_len , r.rev_actor #,... |
4 years ago |
| USE enwiki_p;
SELECT p.page_title, p.page_len , r.rev_actor,... |
4 years ago |
| USE enwiki_p;
SELECT p.page_title, p.page_len #, r.rev_user, r.rev_user_text... |
4 years ago |
| USE enwiki_p;
SELECT p.page_title, p.page_len, r.rev_user, r.rev_user_text #... |
4 years ago |
| USE enwiki_p;
SELECT p.page_title, p.page_len #, r.rev_user, r.rev_user_text... |
4 years ago |
| USE enwiki_p;
SELECT p.page_title, p.page_len #, r.rev_user,... |
4 years ago |
| USE enwiki_p;
SELECT p.page_title, p.page_len, r.rev_user,... |
4 years ago |
| USE enwiki_p
SELECT p.page_title, p.page_len
FROM page p
LEFT JOIN... |
4 years ago |
| USE enwiki_p
SELECT p.page_title, p.page_len
FROM page p
LEFT JOIN... |
4 years ago |
| USE enwiki_p
SELECT p.page_title, p.page_len
FROM page p
LEFT JOIN... |
4 years ago |
| USE enwiki_p
SELECT p.page_title, p.page_len
FROM page p
LEFT JOIN... |
4 years ago |
| USE enwiki_p
SELECT p.page_title, p.page_len
FROM page p
LEFT JOIN... |
4 years ago |
| USE enwiki_p
SELECT p.page_title, p.page_len #, r.rev_user,... |
4 years ago |
| USE enwiki_p
SELECT p.page_title, p.page_len #, r.rev_user,... |
4 years ago |
| USE enwiki_p; SELECT rev_user FROM revision LIMIT 100
/*SELECT p.page_title,... |
4 years ago |
| USE enwiki_p SELECT rev_user FROM revision LIMIT 100
/*SELECT p.page_title,... |
4 years ago |
| USE enwiki_p SELECT rev_userwse FROM revision LIMIT 100
/*SELECT... |
4 years ago |
| USE enwiki_p;
/*SELECT p.page_title, p.page_len//, r.rev_user,... |
4 years ago |
| USE enwiki_p;
/*SELECT p.page_title, p.page_len//, r.rev_user,... |
4 years ago |
| USE enwiki_p;
SELECT p.page_title, p.page_len//, r.rev_user,... |
4 years ago |
| USE enwiki_p;
/*SELECT p.page_title, p.page_len, r.rev_user,... |
4 years ago |
| USE enwiki_p;
/*SELECT p.page_title, p.page_len, r.rev_user,... |
4 years ago |
| USE enwiki_p;
SELECT p.page_title, p.page_len, r.rev_user,... |
4 years ago |
| USE enwiki_p;
SELECT p.page_title, p.page_len, rev_user_text
FROM page... |
4 years ago |
| USE enwiki_p;
SELECT p.page_title, p.page_len, r.rev_user_text
FROM page... |
4 years ago |
| USE enwiki_p;
SELECT p.page_title, p.page_len, r.rev_user,... |
4 years ago |
| USE enwiki_p;
SELECT page_title, page_len
FROM page p
LEFT JOIN revision... |
4 years ago |
| USE enwiki_p;
SELECT page_title, page_len
FROM page p
LEFT JOIN revision... |
4 years ago |
| USE enwiki_p;
SELECT page_title, page_len
FROM page
LIMIT 10 |
4 years ago |
| USE enwiki_p;
SELECT page_title
FROM page
LIMIT 10 |
4 years ago |
