Articles using infobox rail not in TWP

SQL

select
  p1.page_title,
  p1.page_namespace,
  concat('https://en.wikipedia.org/wiki/', p1.page_title) as url
from
  page p1
  join templatelinks tl on tl.tl_from = p1.page_id
  and (tl.tl_title = "Infobox_rail")
  left join page p2 on p2.page_title = p1.page_title
  and p2.page_namespace = 1
  join categorylinks on categorylinks.cl_from=p2.page_id
where
  p1.page_namespace = 0
  and categorylinks.cl_to NOT IN ('A-Class_rail_transport_articles','B-Class_rail_transport_articles','C-Class_rail_transport_articles','Stub-Class_rail_transport_articles','Start-Class_rail_transport_articles','GA-Class_rail_transport_articles','FA-Class_rail_transport_articles','Template-Class_rail_transport_articles','AL-Class_rail_transport_articles','BL-Class_rail_transport_articles','CL-Class_rail_transport_articles','FL-Class_rail_transport_articles','List-Class_rail_transport_articles','Unassessed-Class_rail_transport_articles')
SQL

Checking query status...
