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