SELECT redirect.rd_namespace AS "名前空間1", LEFT(redirect.rd_title,60) AS... |
2 years ago |
SELECT redirect.rd_namespace AS "名前空間1", LEFT(redirect.rd_title,60) AS... |
2 years ago |
SELECT redirect.rd_namespace, LEFT(redirect.rd_title,60) AS "リダイレクト先",... |
2 years ago |
SELECT redirect.rd_namespace, LEFT(redirect.rd_title,60) AS "リダイレクト先",... |
2 years ago |
SELECT redirect.rd_namespace, LEFT(redirect.rd_title,60) AS "リダイレクト元",... |
2 years ago |
SELECT LEFT(redirect.rd_title,60), redirect.rd_namespace, redirect.rd_from,... |
2 years ago |
SELECT LEFT(redirect.rd_title,30), redirect.rd_namespace, redirect.rd_from,... |
2 years ago |
SELECT redirect.rd_title, redirect.rd_namespace, redirect.rd_from,... |
2 years ago |
SELECT redirect.rd_title, redirect.rd_namespace, redirect.rd_from,... |
2 years ago |
SELECT redirect.rd_title, redirect.rd_from, page.page_title
FROM redirect,... |
2 years ago |
SELECT redirect.rd_title, redirect.rd_from, page.page_title
FROM redirect,... |
2 years ago |
SELECT redirect.rd_title, redirect.rd_from, page.page_id
FROM redirect,... |
2 years ago |
SELECT redirect.rd_title,redirect.rd_from
FROM redirect, page
WHERE... |
2 years ago |
SELECT rd_title,rd_from
FROM redirect
WHERE rd_namespace = 0
ORDER BY... |
2 years ago |
SELECT rd_title
FROM redirect
WHERE rd_namespace = 0
ORDER BY rd_title
LIMIT 1000; |
2 years ago |
SELECT rd_title
FROM redirect ;
WHERE rd_namespace = 0
HAVING COUNT(*) =... |
2 years ago |
SELECT rd_title
FROM redirect
WHERE rd_namespace = 0
HAVING COUNT(*) =... |
2 years ago |
SELECT rd_title
FROM redirect
WHERE rd_namespace=0
HAVING COUNT(*)=1
ORDER... |
2 years ago |
SELECT *
FROM redirect
WHERE rd_namespace='0'
HAVING COUNT(*)=1
ORDER BY... |
2 years ago |
SELECT *
FROM redirect
WHERE rd_namespace='0'
GROUP BY rd_namespace
HAVING... |
2 years ago |
SELECT *
FROM redirect
WHERE rd_namespace IN (0, 4)
GROUP BY... |
2 years ago |
SELECT *
FROM redirect
WHERE page_namespace IN (0, 4)
GROUP BY... |
2 years ago |
SELECT CONCAT(CASE page_namespace WHEN 4 THEN "Wikipedia:" ELSE "" END,... |
2 years ago |
SELECT CONCAT(CASE page_namespace WHEN 4 THEN "Wikipedia:" ELSE "" END,... |
2 years ago |
SELECT CONCAT(CASE page_namespace WHEN 4 THEN "Wikipedia:" ELSE "" END,... |
2 years ago |
select dbname from wiki; |
2 years ago |