Project:SPARQL/examples: Difference between revisions

Jump to navigation Jump to search
Line 295: Line 295:
?item wbt:P5 wb:Q12.
?item wbt:P5 wb:Q12.
MINUS {?item wbt:P1 []}
MINUS {?item wbt:P1 []}
SERVICE wikibase:label { bd:serviceParam wikibase:language "sv,en". }
}
</SPARQL>
==Organizers who are not Organizations or Persons==
<SPARQL tryit="1">
PREFIX wb: <https://metabase.wikibase.cloud/entity/>
PREFIX wbt: <https://metabase.wikibase.cloud/prop/direct/>
SELECT DISTINCT ?item ?itemLabel ?organizer ?organizerLabel
WHERE {
?item wbt:P14 ?organizer.
?organizer wbt:P5 ?organizerType.
FILTER(?organizerType NOT IN(wb:Q13, wb:Q23) ). # organizer type is not organization or person
SERVICE wikibase:label { bd:serviceParam wikibase:language "sv,en". }
SERVICE wikibase:label { bd:serviceParam wikibase:language "sv,en". }
}
}
</SPARQL>
</SPARQL>