17,519
edits
Project:SPARQL/examples: Difference between revisions
→Maintenance queries
| Line 146: | Line 146: | ||
} | } | ||
BIND (ENCODE_FOR_URI(REPLACE(STR(?item), ".*Q", "Q")) AS ?qid) | BIND (ENCODE_FOR_URI(REPLACE(STR(?item), ".*Q", "Q")) AS ?qid) | ||
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". } | |||
} | |||
</sparql> | |||
===Items that are in a maintenance class=== | |||
<sparql tryit="1"> | |||
PREFIX pp: <https://ppsdb.wikibase.cloud/entity/> | |||
PREFIX ppt: <https://ppsdb.wikibase.cloud/prop/direct/> | |||
SELECT DISTINCT ?item ?itemLabel ?classLabel WHERE { | |||
?item ppt:P18 ?class. | |||
?class ppt:P24* pp:Q657 | |||
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". } | SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". } | ||
} | } | ||