Fork of
All flow borad on zhwiki
by SunAfterRain
This query is marked as a draft
This query has been published
by SunAfterRain.
SQL
AخA
SELECT
page_id as `page.page_id`,
CONCAT("[[User_talk:", page_title, "]]") AS `WIKITEXT TITLE`,
page_title as `page.page_title`
FROM
page
WHERE
page_content_model = "flow-board"
AND page_namespace = 3
AND NOT (page_title LIKE '%存档%' OR page_title LIKE '%存檔%')
ORDER BY page_id ASC;
By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.
All SQL code is licensed under CC0 License.