| USE enwikinews_p;
SELECT page.* FROM page
WHERE page_namespace = 0
AND... |
4 years ago |
| USE enwikinews_p;
SELECT page.* FROM page
WHERE page_namespace = 0
AND... |
4 years ago |
| USE enwikinews_p;
SELECT * FROM page
WHERE page_namespace = 0
AND page_id... |
4 years ago |
| SELECT * FROM logging
WHERE log_type = 'massmessage'
ORDER BY log_timestamp... |
4 years ago |
| SELECT * FROM logging
WHERE log_type = 'massmessage'
AND log_action NOT IN (... |
4 years ago |
| SELECT * FROM logging
WHERE log_type = 'massmessage'
AND log_action NOT IN (... |
4 years ago |
| SELECT * FROM logging
WHERE log_type = 'massmessage'
AND log_action !=... |
4 years ago |
| SELECT * FROM logging
WHERE log_type = 'massmessage'
LIMIT 100 |
4 years ago |
| SELECT * FROM logging
LIMIT 100 |
4 years ago |
| USE nlwiki_p;
SELECT * FROM ipblocks
LIMIT 100 |
4 years ago |
| USE nlwiki_p;
SHOW tables |
4 years ago |
| SELECT page.page_id AS ID, page.page_namespace AS ns, page.page_title AS... |
4 years ago |
| SELECT page.page_id AS ID, page.page_namespace AS ns, page.page_title AS... |
4 years ago |
| SELECT page.page_id AS ID, page.page_namespace AS ns, page.page_title AS... |
4 years ago |
| USE metawiki_p;
SHOW tables |
4 years ago |
| USE metawiki_p;
SELECT * FROM translate_metadata
LIMIT 10 |
4 years ago |
| SELECT * FROM wiki |
4 years ago |
| SELECT * FROM database_meta_table |
4 years ago |
| SELECT * FROM sys |
4 years ago |
| SELECT * FROM sys.master |
4 years ago |
| SELECT * FROM master |
4 years ago |
| SELECT name FROM master.dbo.sysdatabases |
4 years ago |
| SELECT name FROM master.dbo.sysdatabases |
4 years ago |
| EXEC sp_databases; |
4 years ago |
| show tables; |
4 years ago |
| SELECT DISTINCT revision_userindex.rev_page, page.page_namespace,... |
4 years ago |
| SELECT DISTINCT revision_userindex.rev_page, page.page_namespace,... |
4 years ago |
| SELECT DISTINCT revision_userindex.rev_page, page.page_namespace,... |
4 years ago |
| SELECT DISTINCT revision_userindex.rev_page, page.page_namespace,... |
4 years ago |
| SELECT DISTINCT revision_userindex.rev_page, page.page_namespace,... |
4 years ago |
| SELECT DISTINCT revision_userindex.rev_page FROM revision_userindex
JOIN... |
4 years ago |
| SELECT DISTINCT revision_userindex.rev_page FROM revision_userindex
JOIN... |
4 years ago |
| SELECT DISTINCT revision_userindex.rev_page FROM revision_userindex
JOIN... |
4 years ago |
| SELECT revision_userindex.rev_page FROM revision_userindex
JOIN... |
4 years ago |
| SELECT revision_userindex.rev_page FROM revision_userindex
JOIN... |
4 years ago |
| DESCRIBE actor_revision |
4 years ago |
| SELECT revision_userindex.rev_page FROM revision_userindex
JOIN actor ON... |
4 years ago |
| SELECT revision_userindex.rev_page FROM revision_userindex
WHERE... |
4 years ago |
| SELECT DISTINCT page.page_namespace, page.page_title FROM... |
4 years ago |
| SELECT DISTINCT page.page_namespace, page.page_title FROM... |
4 years ago |
| SELECT page.page_namespace, page.page_title FROM revision_userindex
JOIN... |
4 years ago |
| SELECT page.page_namespace, page.page_title FROM revision_userindex
JOIN... |
4 years ago |
| SELECT page.page_namespace, page.page_title FROM revision
JOIN page ON... |
4 years ago |
| SELECT page.page_namespace, page.page_title FROM revision
LEFT JOIN page ON... |
4 years ago |
| USE wikidatawiki_p;
SELECT revs.rev_id
FROM revision revs
LEFT OUTER JOIN... |
4 years ago |
| USE wikidatawiki_p;
SELECT revs.rev_id
FROM revision revs
LEFT OUTER JOIN... |
4 years ago |
| USE wikidatawiki_p;
SELECT revs.rev_id
FROM revision revs
LEFT OUT JOIN... |
4 years ago |
| USE wikidatawiki_p;
SELECT
revs.rev_id
FROM revision revs
LEFT JOIN... |
4 years ago |
| USE wikidatawiki_p;
SELECT
revs.rev_id
FROM revision revs
LEFT JOIN... |
4 years ago |
| USE wikidatawiki_p;
SELECT
revision.rev_id
FROM revision
LEFT JOIN... |
4 years ago |
| USE wikidatawiki_p;
SELECT
revision.rev_id,
comment_text AS... |
4 years ago |
| USE wikidatawiki_p;
SELECT
revs.rev_id AS rev_id,
revs.rev_len AS... |
4 years ago |
| USE wikidatawiki_p;
SELECT
revs.rev_id AS rev_id,
revs.rev_len AS... |
4 years ago |
| USE wikidatawiki_p;
SELECT
page_title,
page_namespace,
revs.rev_id... |
4 years ago |
| USE wikidatawiki_p;
SELECT
page_title,
page_namespace,
revs.rev_id... |
4 years ago |
| USE wikidatawiki_p;
SELECT actor.actor_name AS 'User',... |
4 years ago |
| USE wikidatawiki_p;
SELECT actor.actor_name AS 'User',... |
4 years ago |
