Toggle navigation
Home
New Query
Recent Queries
Discuss
Database tables
Database names
MediaWiki
Wikibase
Replicas browser and optimizer
Login
History
Fork
This query is marked as a draft
This query has been published
by
Wurgl
.
Begriffsklärungsseiten ohne Vorlage Linked Coordinates aber mit Artikeln in denen die Vorlage Coordinate ist
Toggle Highlighting
SQL
SELECT P.page_title, count(DISTINCT Artikel.page_id) AS Anzahl, GROUP_CONCAT(DISTINCT Artikel.page_title SEPARATOR ' · ' LIMIT 5) AS "5 Beispiel-BKS" FROM page AS P, templatelinks AS BKL, templatelinks AS COORD, pagelinks, page AS Artikel WHERE P.page_namespace = 0 AND P.page_title = 'Aagissat' AND P.page_id = BKL.tl_from AND BKL.tl_from_namespace = P.page_namespace AND BKL.tl_title = 'Begriffsklärung' AND BKL.tl_namespace = 10 AND NOT EXISTS (SELECT 1 FROM templatelinks AS LC WHERE P.page_id = LC.tl_from AND LC.tl_from_namespace = P.page_namespace AND LC.tl_title = 'Linked_Coordinates' AND LC.tl_namespace = 10 ) AND P.page_id = pl_from AND pl_title = Artikel.page_title AND pl_namespace = 0 AND pl_namespace = Artikel.page_namespace AND Artikel.page_id = COORD.tl_from AND COORD.tl_title = 'Coordinate' AND COORD.tl_namespace = 10 GROUP BY Artikel.page_id ORDER BY Anzahl DESC
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
.
Checking query status...