User:Certes/Reports/Ambiguous rail links

Links to dabs called * station, * line, * railway or * metro, from quarry:query/69582

{{Database report

|sql=

SELECT lt_title AS TargetDab,

CONCAT(CASE pl_from_namespace WHEN 0 THEN "" WHEN 10 THEN "Template:" WHEN 14 THEN "Category:" WHEN 100 THEN "Portal:"

ELSE CONVERT(pl_from_namespace, CHAR) END, Pa.page_title) AS LinkedFrom

FROM linktarget

JOIN pagelinks ON pl_target_id=lt_id AND pl_from_namespace IN (0,10,14,100)

JOIN page Pd ON page_namespace=0 AND page_title=lt_title

JOIN page_props ON pp_page=Pd.page_id AND pp_propname="disambiguation"

JOIN page Pa ON Pa.page_id=pl_from AND Pa.page_is_redirect=0 AND NOT Pa.page_title REGEXP "^Did_you_know_nominations/"

WHERE lt_namespace=0 AND lt_title REGEXP "_(station{{!}}line{{!}}metro{{!}}railway)\\b"

AND NOT lt_title REGEXP "_\\(disambiguation\\)"

ORDER BY TargetDab, pl_from_namespace, LinkedFrom

|wikilinks= 1,2

|excerpts=

|comments=

|interval= 1

|table_style=

|pagination=

|max_pages=

}}

class="wikitable sortable" style="overflow-wrap: anywhere"
scope="col" \| TargetDab ! scope="col" \| LinkedFrom
Bloor station \| Bloor GO Station
Dongguan railway station \| Shilong railway station
Llanberis railway station \| Francis–Barnett
Sealdah station \| Template:Sealdah segment

class="wikitable sortable" style="overflow-wrap: anywhere"

scope="col" | TargetDab

! scope="col" | LinkedFrom

----

{{Database report/footer|count=4|query_runtime=30.56|last_updated=05:26, 6 May 2025 (UTC)}}