| # wiki: days/edits
# default: 4/0
# wikidata: 4/50
SET @days = 4;
SET @edits... |
3 months ago |
| # wiki: days/edits
# default: 4/0
# wikidata: 4/50
SET @days = 4;
SET @edits... |
3 months ago |
| # wiki: days/edits
# default: 4/0
# wikidata: 4/50
SET @days = 4;
SET @edits... |
1 year ago |
| # wiki: days/edits
# default: 4/0
# wikidata: 4/50
SET @days = 4;
SET @edits... |
1 year ago |
| SET @days = 4;
SET @edits = 50;
SELECT ug.ug_user, ug.ug_expiry, u.user_id,... |
1 year ago |
| SET @days = 4;
SET @edits = 50;
use wikidatawiki_p;
SELECT ug.ug_user,... |
3 years ago |
| SET @days = 4;
SET @edits = 50;
use wikidatawiki_p;
SELECT ug.ug_user,... |
3 years ago |
| SET @days = 4;
SET @edits = 0;
use mediawikiwiki_p;
SELECT ug.ug_user,... |
3 years ago |
| SET @days = 4;
SET @edits = 50;
use wikidatawiki_p;
SELECT ug.ug_user,... |
3 years ago |
| SET @days = 4;
SET @edits = 50;
use wikidatawiki_p;
SELECT ug.ug_user,... |
3 years ago |
| SET @days = 4;
SET @edits = 10;
use mediawikiwiki_p;
SELECT ug.ug_user,... |
3 years ago |
| SET @days = 4;
SET @edits = 50;
use mediawikiwiki_p;
SELECT ug.ug_user,... |
3 years ago |
| SET @days = 4;
SET @edits = 50;
use mediawikiwiki_p;
SELECT ug.ug_user,... |
3 years ago |
| SET @days = 4;
SET @edits = 50;
use mediawikiwiki_p;
SELECT ug.ug_user,... |
3 years ago |
| SET @days = 4;
SET @edits = 50;
use metawiki_p;
SELECT ug.ug_user,... |
3 years ago |
| SET @days = 4;
SET @edits = 50;
use metawiki_p;
SELECT ug.ug_user,... |
3 years ago |
| SET @days = 4;
SET @edits = 50;
use metawiki_p;
SELECT ug.ug_user,... |
3 years ago |
| SET @days = 4;
SET @edits = 50;
use wikidatawiki_p;
SELECT ug.ug_user,... |
3 years ago |
| SET @days = 4;
SET @edits = 50;
use wikidatawiki_p;
SELECT ug.ug_user,... |
3 years ago |
| SET @days = 4;
SET @edits = 50;
use wikidatawiki_p;
SELECT ug.ug_user,... |
3 years ago |
| SET @days = 4;
SET @edits = 50;
use wikidatawiki_p;
SELECT ug.ug_user,... |
3 years ago |
| SET @days = 4;
SET @edits = 50;
use wikidatawiki_p;
SELECT ug.ug_user,... |
3 years ago |
| SET @days = 4;
SET @edits = 50;
use wikidatawiki_p;
SELECT ug.ug_user,... |
3 years ago |
| SET @days = 4;
SET @edits = 50;
use wikidatawiki_p;
SELECT ug.ug_user,... |
3 years ago |
| SET @days = 4;
SET @edits = 50;
use wikidatawiki_p;
SELECT ug.ug_user,... |
3 years ago |
| SET @days = 4;
SET @edits = 50;
use wikidatawiki_p;
SELECT ug.ug_user,... |
3 years ago |
| SET @days = 4;
SET @edits = 50;
use wikidatawiki_p;
SELECT ug.ug_user,... |
3 years ago |
| SET @days = 4;
SET @edits = 50;
use wikidatawiki_p;
SELECT ug.ug_user,... |
3 years ago |
| SET @days = 4;
SET @edits = 0;
use mediawikiwiki_p;
SELECT ug.ug_user,... |
3 years ago |
| SET @days = 4;
SET @edits = 50;
use wikidatawiki_p;
SELECT ug.ug_user,... |
3 years ago |
| SET @days = 4;
SET @edits = 50;
use wikidatawiki_p;
SELECT ug.ug_user,... |
3 years ago |
| SET @days = 4;
SET @edits = 50
use wikidatawiki_p;
SELECT ug.ug_user,... |
3 years ago |
| SET @days = 4;
SET @edits = 0;
use mediawikiwiki_p;
SELECT ug.ug_user,... |
3 years ago |
| SET @days = 4;
SET @edits = 0;
use mediawikiwiki_p;
SELECT ug.ug_user,... |
3 years ago |
| SET @days = 4;
SET @edits = 0;
use mediawikiwiki_p;
SELECT ug.ug_user,... |
3 years ago |
| SET @days = 4;
SET @edits = 50;
use wikidatawiki_p;
SELECT ug.ug_user,... |
3 years ago |
| SET @days = 4;
SET @edits = 50;
use wikidatawiki_p;
SELECT ug.ug_user,... |
3 years ago |
| SET @days = 4;
SET @edits = 50;
use wikidatawiki_p;
SELECT ug.ug_user,... |
3 years ago |
| SET @days = 4;
SET @edits = 0;
use wikidatawiki_p;
SELECT ug.ug_user,... |
3 years ago |
| SET @days = 4;
SET @edits = 0;
use mediawikiwiki_p;
SELECT ug.ug_user,... |
3 years ago |
| SET @days = 4;
SET @edits = 0;
use enwikiquote_p;
SELECT ug.ug_user,... |
3 years ago |
| SET @days = 4;
SET @edits = 0;
use simplewiki_p;
SELECT ug.ug_user,... |
3 years ago |
| SET @days = 4;
SET @edits = 0;
use simplewiki_p;
SELECT ug.ug_user,... |
3 years ago |
| SET @days = 4;
SET @edits = 0;
use enwikiquote_p;
SELECT ug.ug_user,... |
3 years ago |
| SET @days = 4;
SET @edits = 50;
use wikidatawiki_p;
SELECT ug.ug_user,... |
3 years ago |
| SET @days = 4;
SET @edits = 50;
use wikidatawiki_p;
SELECT ug.ug_user,... |
3 years ago |
| SET @days = 4;
SET @edits = 50;
use wikidatawiki_p;
SELECT ug.ug_user,... |
3 years ago |
| SET @days = 4;
SET @edits = 50;
use wikidatawiki_p;
SELECT ug.ug_user,... |
3 years ago |
| SET @days = 4;
SET @edits = 50;
use wikidatawiki_p;
SELECT ug.ug_user,... |
3 years ago |
| SET @days = 4;
SET @edits = 50;
use wikidatawiki_p;
SELECT ug.ug_user,... |
3 years ago |
| SET @days = 4;
SET @edits = 50;
use wikidatawiki_p;
SELECT * FROM... |
3 years ago |
| SELECT pg.page_title, pg.page_is_redirect, cl_to
FROM categorylinks cl
JOIN... |
4 years ago |
| SELECT pg.page_title, pg.page_is_redirect, cl_to
FROM categorylinks cl
JOIN... |
4 years ago |
| SELECT pg.page_title, pg.page_is_redirect, cl_to
FROM categorylinks cl
JOIN... |
4 years ago |
| SELECT pg.page_title, pg.page_is_redirect, cl_to
FROM categorylinks cl
JOIN... |
4 years ago |
| SELECT pg.page_title, pg.page_is_redirect
FROM categorylinks cl
JOIN page AS... |
4 years ago |
| SELECT pg.page_title, pg.page_is_redirect
FROM categorylinks cl
JOIN page AS... |
4 years ago |
| SELECT pg.page_title, pg.page_is_redirect
FROM categorylinks cl
JOIN page AS... |
4 years ago |
| SELECT pg.page_title
FROM categorylinks cl
JOIN page AS pg ON cl_from =... |
4 years ago |
| SELECT *
FROM categorylinks cl
JOIN page AS pg ON cl_from = page_id
WHERE... |
4 years ago |
| SELECT *
FROM categorylinks cl
JOIN page AS pg ON cl_from = page_id
WHERE... |
4 years ago |
| SELECT * FROM revision
WHERE rev_page = 58422978
GROUP BY rev_actor
ORDER BY... |
4 years ago |
| SELECT * FROM revision
WHERE rev_page = 58422978
GROUP BY rev_actor |
4 years ago |
| SELECT * FROM revision
WHERE rev_page = 58422978 |
4 years ago |
| SELECT rev_page, count(*), page.page_namespace, page.page_title FROM... |
4 years ago |
| SELECT rev_page, count(*), page.page_namespace, page.page_title FROM... |
4 years ago |
| SELECT rev_page, count(*), page.page_namespace, page.page_title FROM... |
4 years ago |
| SELECT rev_page, count(*), page.page_namespace, page.page_title FROM... |
4 years ago |
| SELECT rev_page, count(*), page.page_namespace, page.page_title FROM... |
4 years ago |
| SELECT rev_page, count(*), page.page_namespace, page.page_title FROM... |
4 years ago |
| SELECT rev_page, count(*), page.page_namespace, page.page_title FROM... |
4 years ago |
| SELECT rev_page, count(*), page.page_namespace, page.page_title FROM... |
4 years ago |
| SELECT rev_page, count(*), page.page_namespace, page.page_title FROM... |
4 years ago |
| SELECT rev_page, count(*), page.page_namespace, page.page_title FROM... |
4 years ago |
| SELECT rev_page, count(*), page.page_namespace, page.page_title FROM... |
4 years ago |
| SELECT rev_page, count(*), page.page_namespace, page.page_title FROM... |
4 years ago |
| SELECT rev_page, count(*), page.page_namespace, page.page_title FROM... |
4 years ago |
| SELECT rev_page, count(*), page.page_namespace, page.page_title FROM... |
4 years ago |
| SELECT rev_page, count(*) FROM revision
GROUP BY rev_page
LIMIT 1000 |
4 years ago |
| SELECT count(*) FROM revision
GROUP BY rev_page
LIMIT 1000 |
4 years ago |
| SELECT count(*) FROM revision
GROUP BY rev_page
LIMIT 1000 |
4 years ago |
| SELECT count(*) FROM revision
GROUP BY rev_page
LIMIT 100 |
4 years ago |
| SELECT *, count(*) FROM revision
GROUP BY rev_page
LIMIT 100 |
4 years ago |
| SELECT count(*) FROM revision
GROUP BY rev_page
LIMIT 100 |
4 years ago |
| SELECT count(*) FROM revision
GROUP BY page_name
LIMIT 100 |
4 years ago |
| SELECT count(*) FROM revision
WHERE rev_page = 58845012 |
5 years ago |
| SELECT count(*) FROM revision
WHERE rev_page = 58845012 |
5 years ago |
| SELECT count(*) FROM revision
WHERE rev_page = 58845012 |
5 years ago |
| SELECT * FROM revision
WHERE rev_page = 58845012 |
5 years ago |
| SELECT * FROM revision
WHERE rev_page = 58845012 |
5 years ago |
| UPDATE rev_table SET tool = 'rollback' WHERE rev_comment RLIKE "(Reverted... |
5 years ago |
| UPDATE rev_table SET tool = 'rollback' WHERE rev_comment RLIKE "(Reverted... |
5 years ago |
| SELECT rev_table WHERE rc_comment LIKE "reply-link"; |
5 years ago |
| SELECT
page_namespace,
page_title
FROM page
LEFT JOIN pagelinks
ON... |
5 years ago |
| SELECT
page_namespace,
page_title
FROM page
LEFT JOIN pagelinks
ON... |
5 years ago |
| SELECT
page_namespace,
page_title
FROM page
LEFT JOIN pagelinks
ON... |
5 years ago |
