This query is marked as a draft This query has been published by For Each element In group ... Next.

SQL

AخA
 
WITH wpvg_page AS (
  SELECT
    page_title,
    page_id
  FROM
    page_assessments
    JOIN page_assessments_projects ON pa_project_id = pap_project_id
    JOIN page ON pa_page_id = page_id
  WHERE
    pap_project_title = '电子游戏'
)
SELECT
  CONCAT(
    "# {{class/icon|bplus}} [[:",
    REPLACE(page_title, "_", " "),
    "]]"
  ) AS result
FROM
  page_assessments
  JOIN page_assessments_projects ON pa_project_id = pap_project_id
  JOIN wpvg_page ON pa_page_id = wpvg_page.page_id
WHERE
  pap_project_title = '通用評級'
  AND pa_class = '乙上'
ORDER BY
  page_title;
By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.
Submit Query
All SQL code is licensed under CC0 License.

Checking query status...