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
XXN
.
Toggle Highlighting
SQL
PREFIX schema: <http://schema.org/> PREFIX wikibase: <http://wikiba.se/ontology#> PREFIX wd: <http://www.wikidata.org/entity/> PREFIX wdt: <http://www.wikidata.org/prop/direct/> PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#> PREFIX p: <http://www.wikidata.org/prop/> PREFIX v: <http://www.wikidata.org/prop/statement/> SELECT ?item ?itemLabel WHERE { ?item wdt:P106 wd:Q937857 . ?item wdt:P27 wd:Q218 . FILTER EXISTS { ?wen schema:about ?item . ?wen schema:inLanguage "en" } FILTER NOT EXISTS { ?wro schema:about ?item . ?wro schema:inLanguage "ro" } SERVICE wikibase:label { bd:serviceParam wikibase:language "en" . } }
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...