SQL
AخA
select
p1.page_title,
p1.page_namespace,
concat('https://en.wikipedia.org/wiki/', p1.page_title) as url
from
page p1
left join page p2 on p2.page_title = p1.page_title
and p2.page_namespace = 1
where p1.page_namespace = 0
and exists (SELECT 1 FROM templatelinks WHERE tl_from = p1.page_id AND tl_namespace = 10 AND tl_title = 'Infobox_station')
and not exists (SELECT 1 FROM categorylinks WHERE cl_from = p2.page_id AND cl_to = 'WikiProject_Stations_articles')
and not exists (SELECT 1 FROM categorylinks WHERE cl_from = p2.page_id AND cl_to = 'WikiProject_Buses_articles')
and not exists (SELECT 1 FROM categorylinks WHERE cl_from = p2.page_id AND cl_to = 'Maritime_transport_task_force_articles')
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.