Railway stations in Switzerland without geocoded images

Fork of Railway stations in Lucerne canton without geocoded images by Tacsipacsi

This query is marked as a draft This query has been published by Enhancing999.

Subcategories of https://commons.wikimedia.org/wiki/Category:Railway_stations_in_Switzerland_by_name that contain no geocoded images.

Update 2024-08 to check for "Module:Coordinates" instead of "Category:Pages with maps"

SQL

SELECT *
	FROM categorylinks INNER JOIN page ON cl_from = page_id
	WHERE cl_to = 'Railway_stations_in_Switzerland_by_name' 
    AND cl_type = 'subcat' 
    AND (
		SELECT cl1.cl_from
		FROM categorylinks AS cl1 JOIN templatelinks AS tl ON cl1.cl_from = tl.tl_from
        WHERE cl1.cl_to = page_title
        AND tl_target_id = (SELECT lt_id FROM linktarget WHERE lt_namespace = 828 AND lt_title = 'Coordinates')
        LIMIT 1
	) IS NULL;

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 Stop Query

All SQL code is licensed under CC0 License.

SQL

Checking query status...