SELECT

    en_page.page_title AS en_title

FROM

    page AS en_page  -- 英文维基百科页面表

INNER JOIN

    page_assessments AS en_assessment ON en_assessment.pa_page_id = en_page.page_id

INNER JOIN

    page_assessments_projects AS en_project ON en_project.pap_project_id = en_assessment.pa_project_id

LEFT JOIN

    langlinks AS ll ON ll.ll_from = en_page.page_id AND ll.ll_lang = 'zh' -- 连接到中文维基百科的链接

WHERE

    en_page.page_namespace = 0  -- 只查询文章页面

    AND en_project.pap_project_title = 'Ships' -- 筛选船舶专题的条目

    AND ll.ll_from IS NOT NULL -- 确保存在中文链接

GROUP BY

    en_page.page_title

ORDER BY

    en_page.page_title;