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.

SQL

SELECT CONCAT('Category:', page_title) AS category_title
	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 categorylinks AS cl2 ON cl1.cl_from = cl2.cl_from
		WHERE cl1.cl_to = page_title AND cl2.cl_to = 'Pages_with_maps'
		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...