Project:SPARQL/examples: Difference between revisions

Jump to navigation Jump to search
Line 322: Line 322:
FILTER(?organizerType NOT IN(wb:Q13, wb:Q23) ). # organizer type is not organization or person
FILTER(?organizerType NOT IN(wb:Q13, wb:Q23) ). # organizer type is not organization or person


SERVICE wikibase:label { bd:serviceParam wikibase:language "sv,en". }
}
</SPARQL>
==All Temporary Free Text Fields==
<SPARQL tryit="1">
PREFIX wb: <https://metabase.wikibase.cloud/entity/>
PREFIX wbt: <https://metabase.wikibase.cloud/prop/direct/>
PREFIX wbp: <https://metabase.wikibase.cloud/prop/>
PREFIX wbpq: <https://metabase.wikibase.cloud/prop/qualifier/>
SELECT DISTINCT ?item ?itemLabel ?val ?qual ?qualLabel
WHERE
{
?item wbt:P38 ?val.
OPTIONAL {?item wbp:P38 ?statement.
?statement wbpq:P41 ?qual .}
   
SERVICE wikibase:label { bd:serviceParam wikibase:language "sv,en". }
SERVICE wikibase:label { bd:serviceParam wikibase:language "sv,en". }
}
}
Line 344: Line 360:
}
}
</SPARQL>
</SPARQL>
==Subjects of Wikimedia Platforms Affected that are not Wikimedia Content Projects or Family of Wikimedia Projects==
==Subjects of Wikimedia Platforms Affected that are not Wikimedia Content Projects or Family of Wikimedia Projects==
<SPARQL tryit="1">
<SPARQL tryit="1">

Navigation menu