| USE enwiki_p;
SELECT * FROM revision
WHERE rev_user != 0 |
5 years ago |
| USE enwiki_p;
SELECT * FROM revision
WHERE rev_user != 0
LIMIT 40 |
5 years ago |
| USE enwiki_p;
SELECT * FROM revision
LIMIT 40 |
5 years ago |
| USE enwiki_p;
SELECT * FROM user_groups |
5 years ago |
| USE enwiki_p;
SELECT * FROM user_groups
LIMIT 40 |
5 years ago |
| USE enwiki_p;
SELECT ug_group, COUNT(*) AS Total FROM user_groups
GROUP BY... |
5 years ago |
| USE enwiki_p;
SELECT * FROM user_groups
GROUP BY ug_group
LIMIT 40 |
5 years ago |
| USE enwiki_p;
SELECT * FROM user_groups
GROUP BY ug_group
ORDER BY Total... |
5 years ago |
| USE enwiki_p;
SELECT * FROM user_groups
WHERE ug_group = "bot"
LIMIT 40 |
5 years ago |
| USE enwiki_p;
SELECT rev_id, rev_user_text, rev_timestamp FROM... |
5 years ago |
| USE enwiki_p;
SELECT * FROM user_groups
WHERE ug_user = 1
LIMIT 40 |
5 years ago |
| USE enwiki_p;
SELECT * user_groups
WHERE ug_user = 1
LIMIT 40 |
5 years ago |
| USE enwiki_p;
SELECT *, COUNT(*) FROM user_groups
GROUP BY ug_user
LIMIT 40 |
5 years ago |
| USE enwiki_p;
SELECT COUNT(*) FROM user_groups
GROUP BY ug_user
LIMIT 40 |
5 years ago |
| USE enwiki_p;
SELECT * FROM user_groups
GROUP BY ug_user
LIMIT 40 |
5 years ago |
| USE enwiki_p;
WITH DEDUPE AS (
SELECT *
, ROW_NUMBER() OVER ( PARTITION... |
5 years ago |
| USE enwiki_p;
SELECT ug_user, ug_group, ug_expiry FROM user_groups |
5 years ago |
| USE enwiki_p;
SELECT DISTINCT ug_user, ug_group, ug_expiry FROM user_groups |
5 years ago |
| USE enwiki_p;
SELECT COUNT(DISTINCT ug_user) FROM user_groups |
5 years ago |
| USE enwiki_p;
SELECT COUNT(*) FROM user_groups |
5 years ago |
| USE enwiki_p;
SELECT ug_group, COUNT(*) AS Total FROM user_groups
GROUP BY... |
5 years ago |
| USE enwiki_p;
SELECT ug_group, COUNT(*) FROM user_groups
GROUP BY ug_group
LIMIT 40 |
5 years ago |
| USE enwiki_p;
SELECT COUNT(*) FROM user_groups
GROUP BY ug_group
LIMIT 40 |
5 years ago |
| USE enwiki_p;
SELECT * FROM user_groups
LIMIT 40 |
5 years ago |
| USE enwiki_p;
SELECT rev_id, rev_user_text, rev_timestamp FROM... |
5 years ago |
| USE enwiki_p;
SELECT rev_id, rev_page, rev_user, rev_user_text,... |
5 years ago |
| USE enwiki_p;
SELECT * FROM revision
WHERE rev_user != 0
ORDER BY... |
5 years ago |
| USE enwiki_p;
SELECT * FROM revision
WHERE rev_user != 0
LIMIT 30 |
5 years ago |
| USE enwiki_p;
SELECT * FROM revision
LIMIT 30 |
5 years ago |
| USE enwiki_p
SELECT *
FROM revision
LIMIT 30 |
5 years ago |
| USE enwiki_p
SELECT *
FROM revision_userindex
LIMIT 30 |
5 years ago |
| USE enwiki_p
SELECT * FROM revision_userindex
LIMIT 30 |
5 years ago |
| USE enwiki_p
SELECT * FROM revision
LIMIT 30 |
5 years ago |
| USE enwiki_p
SELECT * FROM revision_table |
5 years ago |
| USE enwiki_p
SELECT * FROM revision_table
LIMIT 30; |
5 years ago |
| USE enwiki_p
SELECT rev_id, rev_page, rev_user, rev_timestamp FROM... |
5 years ago |
| USE enwiki_p
SELECT rev_id, rev_page, rev_user, rev_timestamp FROM... |
5 years ago |
| USE enwiki_p
SELECT * FROM revision
LIMIT 30; |
5 years ago |
| USE enwiki_p
SELECT * FROM revision
WHERE rev_id != 0
LIMIT 30; |
5 years ago |
| USE enwiki_p
SELECT rev_id, rev_page, rev_user, rev_timestamp FROM... |
5 years ago |
| USE enwiki_p
SELECT rev_id, rev_page, rev_user, rev_timestamp FROM... |
5 years ago |
| blank query |
5 years ago |
