| SELECT
page.page_id AS id,
CASE
page.page_namespace
WHEN 0 THEN... |
1 year ago |
| SELECT
page.page_id AS id,
CASE
page.page_namespace
WHEN 0 THEN... |
1 year ago |
| SELECT
page.page_id AS id,
CASE
page.page_namespace
WHEN 0 THEN... |
1 year ago |
| SELECT
page.page_id AS id,
CASE
page.page_namespace
WHEN 0 THEN... |
1 year ago |
| SELECT
page.page_id AS id,
CASE
page.page_namespace
WHEN 0 THEN... |
1 year ago |
| SELECT
page.page_id AS id,
CASE
page.page_namespace
WHEN 0 THEN... |
1 year ago |
| SELECT
page.page_id AS id,
CASE
page.page_namespace
WHEN 0 THEN... |
1 year ago |
| SELECT
page.page_id AS id,
CASE
page.page_namespace
WHEN 0 THEN... |
1 year ago |
| SELECT
page.page_id AS id,
CASE
page.page_namespace
WHEN 0 THEN... |
1 year ago |
| SELECT
page.page_id AS id,
CASE
page.page_namespace
WHEN 0 THEN... |
1 year ago |
| USE zhwiki_p;
SELECT
page.page_id AS id,
CASE
page.page_namespace
... |
1 year ago |
| USE zhwiki_p;
SELECT
page.page_id AS id,
CASE
page.page_namespace
... |
1 year ago |
| USE zhwiki_p;
SELECT
page.page_id AS id,
CASE
page.page_namespace
... |
1 year ago |
| USE zhwiki_p;
SELECT
CASE
page.page_namespace
WHEN 0 THEN... |
1 year ago |
| USE zhwiki_p;
SELECT
CASE
page.page_namespace
WHEN 0 THEN... |
1 year ago |
| USE zhwiki_p;
SELECT
CASE
page.page_namespace
WHEN 0 THEN... |
1 year ago |
| USE zhwiki_p;
SELECT
CASE
page.page_namespace
WHEN 0 THEN... |
1 year ago |
| USE zhwiki_p;
SELECT
CASE
page.page_namespace
WHEN 0 THEN... |
1 year ago |
| USE zhwiki_p;
SELECT
page.page_id AS id,
CASE
page.page_namespace
... |
1 year ago |
| USE zhwiki_p;
SELECT
page.page_id AS id,
CASE
page.page_namespace
... |
1 year ago |
| USE zhwiki_p;
SELECT
page.page_id AS id,
CASE
page.page_namespace
... |
2 years ago |
| USE zhwiki_p;
SELECT
page.page_id AS id,
CASE
page.page_namespace
... |
2 years ago |
| USE zhwiki_p;
SELECT
page.page_id AS id,
CASE
page.page_namespace
... |
2 years ago |
| USE zhwiki_p;
SELECT
page.page_id AS id,
CASE
page.page_namespace
... |
2 years ago |
| USE zhwiki_p;
SELECT
page.page_id AS id,
CASE
page.page_namespace
... |
2 years ago |
| USE zhwiki_p;
SELECT
page.page_id AS id,
CASE
page.page_namespace
... |
2 years ago |
| USE zhwiki_p;
SELECT
page.page_id AS id,
CASE
page.page_namespace
... |
2 years ago |
| USE zhwiki_p;
SELECT
page.page_id AS id,
CASE
page.page_namespace
... |
2 years ago |
| USE zhwiki_p;
SELECT
page.page_id AS id,
CASE
page.page_namespace
... |
2 years ago |
| USE zhwiki_p;
SELECT
page.page_id AS id,
CASE
page.page_namespace
... |
2 years ago |
| USE zhwiki_p;
SELECT
page.page_id AS id,
CASE
page.page_namespace
... |
2 years ago |
| USE zhwiki_p;
SELECT
page.page_id AS id,
CASE
page.page_namespace
... |
2 years ago |
| USE zhwiki_p;
SELECT
page.page_id AS id,
CASE
page.page_namespace
... |
2 years ago |
| USE zhwiki_p;
SELECT
page.page_id AS id,
CASE
page.page_namespace
... |
2 years ago |
| USE zhwiki_p;
SELECT
page.page_id AS id,
CASE
page.page_namespace
... |
2 years ago |
| USE zhwiki_p;
SELECT
page.page_id AS id,
CASE
page.page_namespace
... |
2 years ago |
| USE zhwiki_p;
SELECT
page.page_id AS id,
CASE
page.page_namespace
... |
2 years ago |
| USE zhwiki_p;
SELECT
page.page_id AS id,
CASE
page.page_namespace
... |
2 years ago |
| USE zhwiki_p;
SELECT
page.page_id AS id,
CASE
page.page_namespace
... |
2 years ago |
| USE zhwiki_p;
SELECT
page.page_id AS id,
CASE
page.page_namespace
... |
2 years ago |
| USE zhwiki_p;
SELECT
page.page_id AS id,
CASE
page.page_namespace
... |
2 years ago |
| USE zhwiki_p;
SELECT
page.page_id AS id,
CASE
page.page_namespace
... |
2 years ago |
| USE zhwiki_p;
SELECT
page.page_id AS id,
CASE
page.page_namespace
... |
2 years ago |
| USE zhwiki_p;
SELECT
page.page_id AS id,
CASE
page.page_namespace
... |
2 years ago |
| USE zhwiki_p;
SELECT
page.page_id AS id,
CASE
page.page_namespace
... |
2 years ago |
| USE zhwiki_p;
SELECT
page.page_id AS id,
CASE
page.page_namespace
... |
2 years ago |
| USE zhwiki_p;
SELECT
page.page_id AS id,
CASE
page.page_namespace
... |
2 years ago |
| USE zhwiki_p;
SELECT
page.page_id AS id,
CASE
page.page_namespace
... |
2 years ago |
| USE zhwiki_p;
SELECT
page.page_id AS id,
CASE
page.page_namespace
... |
3 years ago |
| USE zhwiki_p;
SELECT
page.page_id AS id,
CASE
page.page_namespace
... |
3 years ago |
| USE zhwiki_p;
SELECT
page.page_id AS id,
CASE
page.page_namespace
... |
3 years ago |
| USE zhwiki_p;
SELECT
page.page_id AS id,
CASE
page.page_namespace
... |
3 years ago |
| USE zhwiki_p;
SELECT
page.page_id AS id,
CASE
page.page_namespace
... |
3 years ago |
| USE zhwiki_p;
SELECT
page.page_id AS id,
CASE
page.page_namespace
... |
3 years ago |
| USE zhwiki_p;
SELECT
page.page_id AS id,
CASE
page.page_namespace
... |
3 years ago |
| USE zhwiki_p;
SELECT
page.page_id AS id,
CASE
page.page_namespace
... |
3 years ago |
| USE zhwiki_p;
SELECT
page.page_id AS id,
CASE
page.page_namespace
... |
3 years ago |
| USE zhwiki_p;
SELECT
page.page_id AS id,
CASE
page.page_namespace
... |
3 years ago |
| USE zhwiki_p;
SELECT
page.page_id AS id,
CASE
page.page_namespace
... |
3 years ago |
| USE zhwiki_p;
SELECT
page.page_id AS id,
CASE
page.page_namespace
... |
3 years ago |
| USE zhwiki_p;
SELECT
page.page_id AS id,
CASE
page.page_namespace
... |
3 years ago |
| USE zhwiki_p;
SELECT
page.page_id AS id,
CASE
page.page_namespace
... |
3 years ago |
| USE zhwiki_p;
SELECT
page.page_id AS id,
CASE
page.page_namespace
... |
3 years ago |
| USE zhwiki_p;
SELECT
page.page_id AS id,
CASE
page.page_namespace
... |
3 years ago |
| USE zhwiki_p;
SELECT
page.page_id AS id,
CASE
page.page_namespace
... |
3 years ago |
| USE zhwiki_p;
SELECT
page.page_id AS id,
CASE
page.page_namespace
... |
3 years ago |
| USE zhwiki_p;
SELECT
page.page_id AS id,
CASE
page.page_namespace
... |
3 years ago |
| USE zhwiki_p;
SELECT
page.page_id AS id,
CASE
page.page_namespace
... |
3 years ago |
| USE zhwiki_p;
SELECT
page.page_id AS id,
CASE
page.page_namespace
... |
3 years ago |
| USE zhwiki_p;
SELECT
page.page_id AS id,
CASE
page.page_namespace
... |
3 years ago |
| USE zhwiki_p;
SELECT
page.page_id AS id,
CASE
page.page_namespace
... |
3 years ago |
| USE zhwiki_p;
SELECT
page.page_id AS id,
CASE
page.page_namespace
... |
3 years ago |
| USE zhwiki_p;
SELECT
page.page_id AS id,
CASE
page.page_namespace
... |
4 years ago |
| USE zhwiki_p;
SELECT
page.page_id AS id,
CASE
page.page_namespace
... |
4 years ago |
| USE zhwiki_p;
SELECT
page.page_id AS id,
CASE
page.page_namespace
... |
4 years ago |
| USE zhwiki_p;
SELECT
page.page_id AS id,
CASE
page.page_namespace
... |
4 years ago |
| USE zhwiki_p;
SELECT
page.page_id AS id,
CASE
page.page_namespace
... |
4 years ago |
| USE zhwiki_p;
SELECT
page.page_id AS id,
CASE
page.page_namespace
... |
4 years ago |
| USE zhwiki_p;
SELECT
page.page_id AS id,
CASE
page.page_namespace
... |
4 years ago |
| USE zhwiki_p;
SELECT
page.page_id AS id,
CASE
page.page_namespace
... |
4 years ago |
| USE zhwiki_p;
SELECT
page.page_id AS id,
CASE
... |
4 years ago |
| USE zhwiki_p;
SELECT
page.page_id AS id,
CASE
... |
4 years ago |
| USE zhwiki_p;
SELECT
page.page_id AS id,
CASE
... |
4 years ago |
| USE zhwiki_p;
SELECT
page.page_id AS id,
CASE
... |
4 years ago |
| USE zhwiki_p;
SELECT
page.page_id AS id,
CASE
page.page_namespace
... |
4 years ago |
| USE zhwiki_p;
SELECT
page.page_id AS id,
CASE
... |
4 years ago |
| USE zhwiki_p;
SELECT
page.page_id AS id,
CASE
... |
4 years ago |
| USE zhwiki_p;
SELECT
page.page_id AS id,
CASE
... |
4 years ago |
| USE zhwiki_p;
SELECT
page.page_id AS id,
CASE
... |
4 years ago |
| USE zhwiki_p;
SELECT
page.page_id AS id,
CASE
... |
4 years ago |
| USE zhwiki_p;
SELECT
page.page_id AS id,
CASE
... |
4 years ago |
| USE zhwiki_p;
SELECT
page_id AS id,
CASE
page_namespace -... |
4 years ago |
| SELECT
CASE
p0.page_namespace
WHEN 0 THEN ''
WHEN 2 THEN... |
4 years ago |
| SELECT
CASE
p0.page_namespace
WHEN 0 THEN ''
WHEN 2 THEN... |
4 years ago |
| SELECT
CASE
p0.page_namespace
WHEN 0 THEN ''
WHEN 2 THEN... |
4 years ago |
| SELECT
CASE
p0.page_namespace
WHEN 0 THEN ''
WHEN 2 THEN... |
4 years ago |
| SELECT
CASE
p0.page_namespace
WHEN 0 THEN ''
WHEN 2 THEN... |
4 years ago |
| SELECT
CASE
p1.page_namespace
WHEN 0 THEN ''
WHEN 2 THEN... |
4 years ago |
| SELECT
CASE
p1.page_namespace
WHEN 0 THEN ''
WHEN 2 THEN... |
4 years ago |
| SELECT
CASE
p1.page_namespace
WHEN 0 THEN ''
WHEN 2 THEN... |
4 years ago |
| SELECT
CASE
p1.page_namespace
WHEN 0 THEN ''
WHEN 2 THEN... |
4 years ago |
| USE zhwiki_p;
SELECT
CASE
p1.page_namespace
WHEN 0 THEN... |
4 years ago |
| USE zhwiki_p;
SELECT
page_id AS id,
CASE
page_namespace -... |
4 years ago |
| USE zhwiki_p;
SELECT
page_id AS id,
CASE
page_namespace -... |
4 years ago |
| USE zhwiki_p;
SELECT
page_id AS id,
CASE
page_namespace -... |
4 years ago |
| USE zhwiki_p;
SELECT
page_id AS id,
CASE
page_namespace - 1
WHEN 0... |
4 years ago |
| USE zhwiki_p;
SELECT
page_id AS id,
CASE
page_namespace - 1
WHEN 0... |
4 years ago |
| USE zhwiki_p;
SELECT
page_id AS id,
CASE page_namespace - 1
WHEN 0... |
4 years ago |
| USE zhwiki_p;
SELECT
page_id AS id,
CASE page_namespace - 1
WHEN 0... |
4 years ago |
| USE zhwiki_p;
SELECT
page_id AS id,
CASE page_namespace - 1
WHEN 0... |
4 years ago |
| USE zhwiki_p;
SELECT
page_id AS id,
CASE page_namespace - 1
WHEN 0... |
4 years ago |
| USE zhwiki_p;
SELECT
page_id AS id,
CASE page_namespace - 1
WHEN 0... |
4 years ago |
| USE zhwiki_p;
SELECT
page_id AS id,
case page_namespace - 1
when 0... |
4 years ago |
| USE zhwiki_p;
SELECT
page_id AS id,
page_namespace - 1 = case
when 0... |
4 years ago |
| USE zhwiki_p;
SELECT
page_id AS id,
case page_namespace - 1 when
0... |
4 years ago |
| USE zhwiki_p;
SELECT
page_id AS id,
page_namespace - 1 AS... |
4 years ago |
| USE zhwiki_p;
SELECT
page_id AS id,
page_namespace - 1 AS namespace,
... |
4 years ago |
| USE zhwiki_p;
SELECT
page.id AS id,
page_namespace - 1 AS namespace,
... |
4 years ago |
| USE zhwiki_p;
SELECT
page.*,
CONCAT(
'[[',
IF(page.page_namespace =... |
4 years ago |
| USE zhwiki_p;
SELECT
page.*
CONCAT(
'[[',
IF(page.page_namespace = 1,... |
4 years ago |
| USE zhwiki_p;
SELECT
CONCAT('[[', IF(page.page_namespace = 1, '',... |
4 years ago |
| USE zhwiki_p;
SELECT
CONCAT('[[:', '{{subst:ns:', page.page_namespace -... |
4 years ago |
| USE zhwiki_p;
SELECT
CONCAT('[[:', IF( page.page_namespace - 1 = 0, '' , ... |
4 years ago |
| USE zhwiki_p;
SELECT
CONCAT('[[:', IF( page.page_namespace - 1 = 0, '' , ... |
4 years ago |
| USE zhwiki_p;
SELECT
CONCAT('[[:', IF(page.page_namespace - 1 = 0, "",... |
4 years ago |
| USE zhwiki_p;
SELECT
CONCAT('[[:{{subst:ns:', page.page_namespace - 1,... |
4 years ago |
| USE zhwiki_p;
SELECT
CONCAT('[[:{{subst:ns:', page.page_namespace, '}}:',... |
4 years ago |
| USE zhwiki_p;
SELECT
CONCAT('[[:{{subst:ns:', page.page_namespace, '}}:',... |
4 years ago |
| USE zhwiki_p;
SELECT
CONCAT(page.page_namespace, 'dd', 'ee'),
... |
4 years ago |
| USE zhwiki_p;
SELECT
CONCAT(page.page_namespace, 'dd'),
page.*
FROM
... |
4 years ago |
| USE zhwiki_p;
SELECT
page.page_namespace + 'dd',
page.*
FROM
page
... |
4 years ago |
| USE zhwiki_p;
SELECT
page.page_namespace || '1',
page.*
FROM
page
... |
4 years ago |
| USE zhwiki_p;
SELECT
page.page_namespace - 1,
page.*
FROM
page
JOIN... |
4 years ago |
| USE zhwiki_p;
SELECT
page.page_namespace - 1,
page.*
FROM
page
JOIN... |
4 years ago |
| USE zhwiki_p;
SELECT
*
FROM
page
JOIN categorylinks ON cl_from =... |
4 years ago |
| USE zhwiki_p;
SELECT
page_namespace,
page_title
FROM
page
JOIN... |
4 years ago |
| USE zhwiki_p;
SELECT
page_namespace,
page_title
FROM
page
JOIN... |
4 years ago |
| USE zhwiki_p;
SELECT
page_namespace,
page_title
FROM
page
JOIN... |
4 years ago |
| USE zhwiki_p;
SELECT
page_namespace,
page_title
FROM
page
JOIN... |
4 years ago |
| USE zhwiki_p;
SELECT
page_namespace,
page_title,
FROM
page
JOIN... |
4 years ago |
| USE zhwiki_p;
SELECT
page_title
FROM
page
JOIN categorylinks ON cl_from... |
4 years ago |
| USE zhwiki_p
SELECT
page_title
FROM
page
JOIN categorylinks ON cl_from =... |
4 years ago |
| USE zhwiki_p
SELECT
page_title
FROM
page
JOIN categorylinks ON cl_from =... |
4 years ago |
| USE zhwiki_p
SELECT
page_title
FROM
page
JOIN categorylinks ON cl_from =... |
4 years ago |
| USE zhwiki_p
SELECT
page.page_namespace, page.page_title
FROM
page
JOIN... |
4 years ago |
| USE zhwiki_p
SELECT
page_namespace, page_title
FROM
page
JOIN... |
4 years ago |
