Query Run
/* Find talk pages with a deleted mainpage */ USE iswiki_p; SELECT ... 5 years ago
/* Find talk pages with a deleted mainpage */ SELECT talk.page_title FROM... 5 years ago
/* Find talk pages with a deleted mainpage */ SELECT talk.page_title FROM... 5 years ago
/* Find talk pages with a deleted mainpage */ SELECT talk.page_title FROM... 5 years ago
/* Find talk pages with a deleted mainpage */ SELECT talk.page_title FROM... 5 years ago
/* Find talk pages with a deleted mainpage */ SELECT talk.page_title FROM... 5 years ago
/* Find all user subpages */ USE iswiki_p; SELECT page.page_title FROM... 5 years ago
/* Find all user subpages */ USE iswiki_p; SELECT page.page_title FROM... 5 years ago
/* Find all user subpages */ USE iswiki_p; SELECT page.page_title FROM... 5 years ago
/* Find all user subpages */ USE iswiki_p; SELECT page.page_title FROM... 5 years ago
/* Find all article titles */ USE iswiki_p; SELECT page.page_title FROM... 5 years ago
/* Find all article titles */ USE iswiki_p; SELECT page.page_title FROM... 5 years ago
/* Find all article titles */ USE iswiki_p; SELECT page.page_title FROM... 5 years ago
/* Find all article titles */ USE iswiki_p; SELECT page.page_title FROM... 5 years ago
/* Find all article titles */ USE iswiki_p; SELECT page.page_title FROM... 5 years ago
/* Find all article titles */ USE iswiki_p; SELECT page.page_title FROM... 5 years ago
/* Find all article titles */ USE iswiki_p; SELECT page.page_title FROM... 5 years ago
/* Find all article titles */ USE iswiki_p; SELECT page_title FROM... 5 years ago
/* Find all article titles */ USE iswiki_p; SELECT page_title FROM... 5 years ago
/* Find all article titles */ USE iswiki_p; SELECT page_title FROM... 5 years ago
/* Find all article titles */ USE iswiki_p; SELECT page_title FROM... 5 years ago
/* Find all article titles */ USE iswiki_p; SELECT page_title FROM... 5 years ago
/* Find ALL redirects */ SELECT page.page_namespace AS origin_namespace,... 5 years ago
SELECT page.page_namespace AS origin_namespace, page.page_title AS... 5 years ago
SELECT page.page_namespace AS origin_namespace, page.page_title AS... 5 years ago
USE iswiki_p; SELECT * FROM redirect AS redirect JOIN page AS table1 ON... 5 years ago
blank query 5 years ago
USE iswiki_p; SELECT * FROM redirect AS redirect JOIN page AS table1 ON... 5 years ago
USE iswiki_p; SELECT * FROM redirect AS redirect JOIN page AS table1 ON... 5 years ago
USE iswiki_p; SELECT table1.page_title AS table1_title, table2.page_title... 5 years ago
USE iswiki_p; SELECT * FROM redirect AS redirect LEFT JOIN page destination ... 5 years ago
USE iswiki_p; SELECT origin.page_title AS origin_title,... 5 years ago
USE iswiki_p; SELECT origin.page_title AS origin_title,... 5 years ago
SELECT origin.page_title AS origin_title, destination.page_title AS... 5 years ago
SELECT origin.page_title AS origin_title, destination.page_title AS... 5 years ago
SELECT from.page_title AS from_title, to.page_title AS to_title FROM... 5 years ago
SELECT page.page_title AS origin_title, destination.page_title AS... 5 years ago
/* Find ALL redirects */ SELECT page.page_namespace AS origin_namespace,... 5 years ago
/* Find ALL redirects */ SELECT page.page_namespace, page.page_title FROM... 5 years ago
/* Find ALL redirects */ SELECT origin.page_namespace, origin.page_title,... 5 years ago
/* Find ALL redirects */ SELECT * FROM iswiki_p.redirect AS redirect JOIN... 5 years ago
/* Find ALL redirects */ SELECT * FROM iswiki_p.redirect AS redirect JOIN... 5 years ago
/* Find ALL redirects */ SELECT * FROM iswiki_p.redirect AS redirect JOIN... 5 years ago
/* Find ALL redirects */ SELECT * FROM iswiki_p.redirect AS redirect JOIN... 5 years ago
/* Find ALL redirects */ SELECT origin.page_namespace, origin.page_title,... 5 years ago
/* Find ALL redirects */ SELECT destination.page_namespace,... 5 years ago
/* Find ALL redirects */ SELECT origin.page_namespace, origin.page_title,... 5 years ago
/* Find ALL redirects */ SELECT origin.page_namespace, origin.page_title,... 5 years ago
/* Redirects which point nowhere */ SELECT page.page_namespace,... 5 years ago
/* Redirects which point nowhere */ SELECT page.page_title FROM... 5 years ago
SELECT * FROM iswiki_p.redirect AS redirect LEFT JOIN iswiki_p.page... 5 years ago
SELECT * FROM iswiki_p.redirect AS redirect LEFT JOIN iswiki_p.page... 5 years ago
SELECT * FROM iswiki_p.redirect AS redirect LEFT JOIN iswiki_p.page... 5 years ago
SELECT * FROM iswiki_p.redirect AS redirect LEFT JOIN iswiki_p.page... 5 years ago
/* Redirects which point nowhere */ SELECT page.page_title FROM... 5 years ago
/* Redirects which point nowhere */ SELECT * -- page.page_title FROM... 5 years ago
/* Redirects which point nowhere */ SELECT * -- page.page_title FROM... 5 years ago
/* Redirects which point nowhere */ SELECT page.page_title FROM... 5 years ago
/* Redirects which point nowhere */ SELECT page.page_title FROM... 5 years ago
SELECT * FROM iswiki_p.redirect AS redirect LEFT JOIN iswiki_p.page article ... 5 years ago
SELECT * FROM iswiki_p.redirect AS redirect JOIN iswiki_p.page article ON... 5 years ago
SELECT * FROM iswiki_p.redirect AS redirect JOIN iswiki_p.page article ON... 5 years ago
SELECT * FROM iswiki_p.redirect AS redirect JOIN iswiki_p.page article ON... 5 years ago
SELECT * FROM iswiki_p.redirect AS rd LIMIT 10 5 years ago
SELECT * FROM iswiki_p.redirect AS rd JOIN iswiki_p.page p1 ON rd.rd_from =... 5 years ago
/* Find talk page redirects where the mainspace page is not a redirect */... 5 years ago
/* Find talk page redirects where the mainspace page is not a redirect */... 5 years ago
/* test */ SELECT article.* FROM iswiki_p.redirect AS talk_redirect JOIN... 5 years ago
SELECT article.* FROM iswiki_p.redirect AS talk_redirect JOIN iswiki_p.page... 5 years ago
/* test */ SELECT talk.* FROM iswiki_p.redirect AS talk_redirect JOIN... 5 years ago
/* test */ SELECT * FROM iswiki_p.page talk JOIN iswiki_p.page article ON... 5 years ago
/* test */ SELECT * FROM iswiki_p.page talk WHERE talk.page_title =... 5 years ago
/* test */ SELECT * FROM iswiki_p.page talk WHERE talk.page_namespace = 1 ... 5 years ago
/* test */ SELECT * FROM iswiki_p.page talk JOIN iswiki_p.page article ON... 5 years ago
/* test */ SELECT * FROM iswiki_p.page talk WHERE talk.page_namespace = 1 ... 5 years ago
/* test */ SELECT * FROM iswiki_p.page talk WHERE talk.page_namespace = 1 LIMIT 10 5 years ago
/* test */ SELECT * FROM iswiki_p.page talk WHERE talk.page_title =... 5 years ago
/* Find talk page redirects where the mainspace page is not a redirect */... 5 years ago
/* Find talk page redirects where the mainspace page is not a redirect */... 5 years ago
/* Find talk page redirects where the mainspace page is not a redirect */... 5 years ago
/* Find talk page redirects where the mainspace page is not a redirect */... 5 years ago
SELECT * FROM iswiki_p.redirect AS talk_redirect JOIN iswiki_p.page talk ON... 5 years ago
SELECT * FROM iswiki_p.redirect AS talk_redirect JOIN iswiki_p.page talk ON... 5 years ago
SELECT * FROM iswiki_p.redirect AS talk_redirect JOIN iswiki_p.page... 5 years ago
SELECT * FROM iswiki_p.redirect AS talk_redirect JOIN iswiki_p.page AS... 5 years ago
SELECT * FROM iswiki_p.page p1 WHERE p1.page_id = 147317 LIMIT 10 5 years ago
SELECT * FROM iswiki_p.redirect AS rd JOIN iswiki_p.page p1 ON rd.rd_from =... 5 years ago
SELECT * FROM iswiki_p.redirect WHERE rd_namespace = 1 LIMIT 10 5 years ago
SELECT p1.page_title FROM iswiki_p.redirect AS rd JOIN iswiki_p.page p1 ON... 5 years ago
SELECT rd.*, p1.* FROM iswiki_p.redirect AS rd JOIN iswiki_p.page p1 ON... 5 years ago
SELECT rd.*, p1.* FROM iswiki_p.redirect AS rd JOIN iswiki_p.page p1 ON... 5 years ago
SELECT rd.*, p1.* FROM iswiki_p.redirect AS rd JOIN iswiki_p.page p1 ON... 5 years ago
SELECT rd.*, p1.* FROM iswiki_p.redirect AS rd JOIN iswiki_p.page p1 ON... 5 years ago
SELECT rd.*, p1.* FROM iswiki_p.redirect AS rd JOIN page p1 ON... 5 years ago
SELECT rd.* FROM iswiki_p.redirect AS rd LIMIT 10 5 years ago
SELECT rd.rd_from FROM iswiki_p.redirect AS rd LIMIT 10 5 years ago
SHOW TABLES FROM iswiki_p; SELECT p1.page_namespace, p1.page_title FROM... 5 years ago
SHOW TABLES FROM iswiki_p; 5 years ago