query-c26e499259f078eb0b7aeb2f82849414

rq turtle/ttl

title: Find statements with references containing external links to wipo.int

Description: Find item statements with references containing external links to wipo.int using http and https protocols

Author: Dipsacus fullonum

Date: 2021-09-17

SELECT ?item ?itemLabel ?property ?propertyLabel ?value ?valueLabel ?reference_URL WITH { SELECT DISTINCT ?item WHERE { { # Find items with https URLs SERVICE wikibase:mwapi { bd:serviceParam wikibase:endpoint "www.wikidata.org" . bd:serviceParam wikibase:api "Generator" . bd:serviceParam mwapi:generator "exturlusage" . bd:serviceParam mwapi:geuprop "title" . bd:serviceParam mwapi:geunamespace "0" . bd:serviceParam mwapi:geuprotocol "https" . bd:serviceParam mwapi:geuquery ".wipo.int" . bd:serviceParam mwapi:geulimit "max" . ?item wikibase:apiOutputItem mwapi:title . } } UNION { # Find items with http URLs SERVICE wikibase:mwapi { bd:serviceParam wikibase:endpoint "www.wikidata.org" . bd:serviceParam wikibase:api "Generator" . bd:serviceParam mwapi:generator "exturlusage" . bd:serviceParam mwapi:geuprop "title" . bd:serviceParam mwapi:geunamespace "0" . bd:serviceParam mwapi:geuprotocol "http" . bd:serviceParam mwapi:geuquery ".wipo.int" . bd:serviceParam mwapi:geulimit "max" . ?item wikibase:apiOutputItem mwapi:title . } } } } AS %get_items WHERE { INCLUDE %get_items ?item ?prop ?statement . ?property wikibase:claim ?prop . ?property wikibase:statementProperty ?ps . ?statement ?ps ?value . ?statement prov:wasDerivedFrom ?reference . ?reference ?refprop ?reference_URL . FILTER CONTAINS(STR(?reference_URL), "wipo.int/") SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en" . } } title: Find statements with references containing external links to wipo.int

Description: Find item statements with references containing external links to wipo.int using http and https protocols

Author: Dipsacus fullonum

Date: 2021-09-17

SELECT ?item ?itemLabel ?property ?propertyLabel ?value ?valueLabel ?reference_URL WITH { SELECT DISTINCT ?item WHERE { { # Find items with https URLs SERVICE wikibase:mwapi { bd:serviceParam wikibase:endpoint "www.wikidata.org" . bd:serviceParam wikibase:api "Generator" . bd:serviceParam mwapi:generator "exturlusage" . bd:serviceParam mwapi:geuprop "title" . bd:serviceParam mwapi:geunamespace "0" . bd:serviceParam mwapi:geuprotocol "https" . bd:serviceParam mwapi:geuquery ".wipo.int" . bd:serviceParam mwapi:geulimit "max" . ?item wikibase:apiOutputItem mwapi:title . } } UNION { # Find items with http URLs SERVICE wikibase:mwapi { bd:serviceParam wikibase:endpoint "www.wikidata.org" . bd:serviceParam wikibase:api "Generator" . bd:serviceParam mwapi:generator "exturlusage" . bd:serviceParam mwapi:geuprop "title" . bd:serviceParam mwapi:geunamespace "0" . bd:serviceParam mwapi:geuprotocol "http" . bd:serviceParam mwapi:geuquery ".wipo.int" . bd:serviceParam mwapi:geulimit "max" . ?item wikibase:apiOutputItem mwapi:title . } } } } AS %get_items WHERE { INCLUDE %get_items ?item ?prop ?statement . ?property wikibase:claim ?prop . ?property wikibase:statementProperty ?ps . ?statement ?ps ?value . ?statement prov:wasDerivedFrom ?reference . ?reference ?refprop ?reference_URL . FILTER CONTAINS(STR(?reference_URL), "wipo.int/") SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en" . } } title: Find statements with references containing external links to wipo.int

Description: Find item statements with references containing external links to wipo.int using http and https protocols

Author: Dipsacus fullonum

Date: 2021-09-17

SELECT ?item ?itemLabel ?property ?propertyLabel ?value ?valueLabel ?reference_URL WITH { SELECT DISTINCT ?item WHERE { { # Find items with https URLs SERVICE wikibase:mwapi { bd:serviceParam wikibase:endpoint "www.wikidata.org" . bd:serviceParam wikibase:api "Generator" . bd:serviceParam mwapi:generator "exturlusage" . bd:serviceParam mwapi:geuprop "title" . bd:serviceParam mwapi:geunamespace "0" . bd:serviceParam mwapi:geuprotocol "https" . bd:serviceParam mwapi:geuquery ".wipo.int" . bd:serviceParam mwapi:geulimit "max" . ?item wikibase:apiOutputItem mwapi:title . } } UNION { # Find items with http URLs SERVICE wikibase:mwapi { bd:serviceParam wikibase:endpoint "www.wikidata.org" . bd:serviceParam wikibase:api "Generator" . bd:serviceParam mwapi:generator "exturlusage" . bd:serviceParam mwapi:geuprop "title" . bd:serviceParam mwapi:geunamespace "0" . bd:serviceParam mwapi:geuprotocol "http" . bd:serviceParam mwapi:geuquery ".wipo.int" . bd:serviceParam mwapi:geulimit "max" . ?item wikibase:apiOutputItem mwapi:title . } } } } AS %get_items WHERE { INCLUDE %get_items ?item ?prop ?statement . ?property wikibase:claim ?prop . ?property wikibase:statementProperty ?ps . ?statement ?ps ?value . ?statement prov:wasDerivedFrom ?reference . ?reference ?refprop ?reference_URL . FILTER CONTAINS(STR(?reference_URL), "wipo.int/") SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en" . } } title: Find statements with references containing external links to wipo.int

Description: Find item statements with references containing external links to wipo.int using http and https protocols

Author: Dipsacus fullonum

Date: 2021-09-17

SELECT ?item ?itemLabel ?property ?propertyLabel ?value ?valueLabel ?reference_URL WITH { SELECT DISTINCT ?item WHERE { { # Find items with https URLs SERVICE wikibase:mwapi { bd:serviceParam wikibase:endpoint "www.wikidata.org" . bd:serviceParam wikibase:api "Generator" . bd:serviceParam mwapi:generator "exturlusage" . bd:serviceParam mwapi:geuprop "title" . bd:serviceParam mwapi:geunamespace "0" . bd:serviceParam mwapi:geuprotocol "https" . bd:serviceParam mwapi:geuquery ".wipo.int" . bd:serviceParam mwapi:geulimit "max" . ?item wikibase:apiOutputItem mwapi:title . } } UNION { # Find items with http URLs SERVICE wikibase:mwapi { bd:serviceParam wikibase:endpoint "www.wikidata.org" . bd:serviceParam wikibase:api "Generator" . bd:serviceParam mwapi:generator "exturlusage" . bd:serviceParam mwapi:geuprop "title" . bd:serviceParam mwapi:geunamespace "0" . bd:serviceParam mwapi:geuprotocol "http" . bd:serviceParam mwapi:geuquery ".wipo.int" . bd:serviceParam mwapi:geulimit "max" . ?item wikibase:apiOutputItem mwapi:title . } } } } AS %get_items WHERE { INCLUDE %get_items ?item ?prop ?statement . ?property wikibase:claim ?prop . ?property wikibase:statementProperty ?ps . ?statement ?ps ?value . ?statement prov:wasDerivedFrom ?reference . ?reference ?refprop ?reference_URL . FILTER CONTAINS(STR(?reference_URL), "wipo.int/") SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en" . } } title: Find statements with references containing external links to wipo.int

Description: Find item statements with references containing external links to wipo.int using http and https protocols

Author: Dipsacus fullonum

Date: 2021-09-17

SELECT ?item ?itemLabel ?property ?propertyLabel ?value ?valueLabel ?reference_URL WITH { SELECT DISTINCT ?item WHERE { { # Find items with https URLs SERVICE wikibase:mwapi { bd:serviceParam wikibase:endpoint "www.wikidata.org" . bd:serviceParam wikibase:api "Generator" . bd:serviceParam mwapi:generator "exturlusage" . bd:serviceParam mwapi:geuprop "title" . bd:serviceParam mwapi:geunamespace "0" . bd:serviceParam mwapi:geuprotocol "https" . bd:serviceParam mwapi:geuquery ".wipo.int" . bd:serviceParam mwapi:geulimit "max" . ?item wikibase:apiOutputItem mwapi:title . } } UNION { # Find items with http URLs SERVICE wikibase:mwapi { bd:serviceParam wikibase:endpoint "www.wikidata.org" . bd:serviceParam wikibase:api "Generator" . bd:serviceParam mwapi:generator "exturlusage" . bd:serviceParam mwapi:geuprop "title" . bd:serviceParam mwapi:geunamespace "0" . bd:serviceParam mwapi:geuprotocol "http" . bd:serviceParam mwapi:geuquery ".wipo.int" . bd:serviceParam mwapi:geulimit "max" . ?item wikibase:apiOutputItem mwapi:title . } } } } AS %get_items WHERE { INCLUDE %get_items ?item ?prop ?statement . ?property wikibase:claim ?prop . ?property wikibase:statementProperty ?ps . ?statement ?ps ?value . ?statement prov:wasDerivedFrom ?reference . ?reference ?refprop ?reference_URL . FILTER CONTAINS(STR(?reference_URL), "wipo.int/") SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en" . } } title: Find statements with references containing external links to wipo.int

Description: Find item statements with references containing external links to wipo.int using http and https protocols

Author: Dipsacus fullonum

Date: 2021-09-17

SELECT ?item ?itemLabel ?property ?propertyLabel ?value ?valueLabel ?reference_URL WITH { SELECT DISTINCT ?item WHERE { { # Find items with https URLs SERVICE wikibase:mwapi { bd:serviceParam wikibase:endpoint "www.wikidata.org" . bd:serviceParam wikibase:api "Generator" . bd:serviceParam mwapi:generator "exturlusage" . bd:serviceParam mwapi:geuprop "title" . bd:serviceParam mwapi:geunamespace "0" . bd:serviceParam mwapi:geuprotocol "https" . bd:serviceParam mwapi:geuquery ".wipo.int" . bd:serviceParam mwapi:geulimit "max" . ?item wikibase:apiOutputItem mwapi:title . } } UNION { # Find items with http URLs SERVICE wikibase:mwapi { bd:serviceParam wikibase:endpoint "www.wikidata.org" . bd:serviceParam wikibase:api "Generator" . bd:serviceParam mwapi:generator "exturlusage" . bd:serviceParam mwapi:geuprop "title" . bd:serviceParam mwapi:geunamespace "0" . bd:serviceParam mwapi:geuprotocol "http" . bd:serviceParam mwapi:geuquery ".wipo.int" . bd:serviceParam mwapi:geulimit "max" . ?item wikibase:apiOutputItem mwapi:title . } } } } AS %get_items WHERE { INCLUDE %get_items ?item ?prop ?statement . ?property wikibase:claim ?prop . ?property wikibase:statementProperty ?ps . ?statement ?ps ?value . ?statement prov:wasDerivedFrom ?reference . ?reference ?refprop ?reference_URL . FILTER CONTAINS(STR(?reference_URL), "wipo.int/") SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en" . } } title: Find statements with references containing external links to wipo.int

Description: Find item statements with references containing external links to wipo.int using http and https protocols

Author: Dipsacus fullonum

Date: 2021-09-17

SELECT ?item ?itemLabel ?property ?propertyLabel ?value ?valueLabel ?reference_URL WITH { SELECT DISTINCT ?item WHERE { { # Find items with https URLs SERVICE wikibase:mwapi { bd:serviceParam wikibase:endpoint "www.wikidata.org" . bd:serviceParam wikibase:api "Generator" . bd:serviceParam mwapi:generator "exturlusage" . bd:serviceParam mwapi:geuprop "title" . bd:serviceParam mwapi:geunamespace "0" . bd:serviceParam mwapi:geuprotocol "https" . bd:serviceParam mwapi:geuquery ".wipo.int" . bd:serviceParam mwapi:geulimit "max" . ?item wikibase:apiOutputItem mwapi:title . } } UNION { # Find items with http URLs SERVICE wikibase:mwapi { bd:serviceParam wikibase:endpoint "www.wikidata.org" . bd:serviceParam wikibase:api "Generator" . bd:serviceParam mwapi:generator "exturlusage" . bd:serviceParam mwapi:geuprop "title" . bd:serviceParam mwapi:geunamespace "0" . bd:serviceParam mwapi:geuprotocol "http" . bd:serviceParam mwapi:geuquery ".wipo.int" . bd:serviceParam mwapi:geulimit "max" . ?item wikibase:apiOutputItem mwapi:title . } } } } AS %get_items WHERE { INCLUDE %get_items ?item ?prop ?statement . ?property wikibase:claim ?prop . ?property wikibase:statementProperty ?ps . ?statement ?ps ?value . ?statement prov:wasDerivedFrom ?reference . ?reference ?refprop ?reference_URL . FILTER CONTAINS(STR(?reference_URL), "wipo.int/") SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en" . } } title: Find statements with references containing external links to wipo.int

Description: Find item statements with references containing external links to wipo.int using http and https protocols

Author: Dipsacus fullonum

Date: 2021-09-17

SELECT ?item ?itemLabel ?property ?propertyLabel ?value ?valueLabel ?reference_URL WITH { SELECT DISTINCT ?item WHERE { { # Find items with https URLs SERVICE wikibase:mwapi { bd:serviceParam wikibase:endpoint "www.wikidata.org" . bd:serviceParam wikibase:api "Generator" . bd:serviceParam mwapi:generator "exturlusage" . bd:serviceParam mwapi:geuprop "title" . bd:serviceParam mwapi:geunamespace "0" . bd:serviceParam mwapi:geuprotocol "https" . bd:serviceParam mwapi:geuquery ".wipo.int" . bd:serviceParam mwapi:geulimit "max" . ?item wikibase:apiOutputItem mwapi:title . } } UNION { # Find items with http URLs SERVICE wikibase:mwapi { bd:serviceParam wikibase:endpoint "www.wikidata.org" . bd:serviceParam wikibase:api "Generator" . bd:serviceParam mwapi:generator "exturlusage" . bd:serviceParam mwapi:geuprop "title" . bd:serviceParam mwapi:geunamespace "0" . bd:serviceParam mwapi:geuprotocol "http" . bd:serviceParam mwapi:geuquery ".wipo.int" . bd:serviceParam mwapi:geulimit "max" . ?item wikibase:apiOutputItem mwapi:title . } } } } AS %get_items WHERE { INCLUDE %get_items ?item ?prop ?statement . ?property wikibase:claim ?prop . ?property wikibase:statementProperty ?ps . ?statement ?ps ?value . ?statement prov:wasDerivedFrom ?reference . ?reference ?refprop ?reference_URL . FILTER CONTAINS(STR(?reference_URL), "wipo.int/") SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en" . } } title: Find statements with references containing external links to wipo.int

Description: Find item statements with references containing external links to wipo.int using http and https protocols

Author: Dipsacus fullonum

Date: 2021-09-17

SELECT ?item ?itemLabel ?property ?propertyLabel ?value ?valueLabel ?reference_URL WITH { SELECT DISTINCT ?item WHERE { { # Find items with https URLs SERVICE wikibase:mwapi { bd:serviceParam wikibase:endpoint "www.wikidata.org" . bd:serviceParam wikibase:api "Generator" . bd:serviceParam mwapi:generator "exturlusage" . bd:serviceParam mwapi:geuprop "title" . bd:serviceParam mwapi:geunamespace "0" . bd:serviceParam mwapi:geuprotocol "https" . bd:serviceParam mwapi:geuquery ".wipo.int" . bd:serviceParam mwapi:geulimit "max" . ?item wikibase:apiOutputItem mwapi:title . } } UNION { # Find items with http URLs SERVICE wikibase:mwapi { bd:serviceParam wikibase:endpoint "www.wikidata.org" . bd:serviceParam wikibase:api "Generator" . bd:serviceParam mwapi:generator "exturlusage" . bd:serviceParam mwapi:geuprop "title" . bd:serviceParam mwapi:geunamespace "0" . bd:serviceParam mwapi:geuprotocol "http" . bd:serviceParam mwapi:geuquery ".wipo.int" . bd:serviceParam mwapi:geulimit "max" . ?item wikibase:apiOutputItem mwapi:title . } } } } AS %get_items WHERE { INCLUDE %get_items ?item ?prop ?statement . ?property wikibase:claim ?prop . ?property wikibase:statementProperty ?ps . ?statement ?ps ?value . ?statement prov:wasDerivedFrom ?reference . ?reference ?refprop ?reference_URL . FILTER CONTAINS(STR(?reference_URL), "wipo.int/") SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en" . } } title: Find statements with references containing external links to wipo.int

Description: Find item statements with references containing external links to wipo.int using http and https protocols

Author: Dipsacus fullonum

Date: 2021-09-17

SELECT ?item ?itemLabel ?property ?propertyLabel ?value ?valueLabel ?reference_URL WITH { SELECT DISTINCT ?item WHERE { { # Find items with https URLs SERVICE wikibase:mwapi { bd:serviceParam wikibase:endpoint "www.wikidata.org" . bd:serviceParam wikibase:api "Generator" . bd:serviceParam mwapi:generator "exturlusage" . bd:serviceParam mwapi:geuprop "title" . bd:serviceParam mwapi:geunamespace "0" . bd:serviceParam mwapi:geuprotocol "https" . bd:serviceParam mwapi:geuquery ".wipo.int" . bd:serviceParam mwapi:geulimit "max" . ?item wikibase:apiOutputItem mwapi:title . } } UNION { # Find items with http URLs SERVICE wikibase:mwapi { bd:serviceParam wikibase:endpoint "www.wikidata.org" . bd:serviceParam wikibase:api "Generator" . bd:serviceParam mwapi:generator "exturlusage" . bd:serviceParam mwapi:geuprop "title" . bd:serviceParam mwapi:geunamespace "0" . bd:serviceParam mwapi:geuprotocol "http" . bd:serviceParam mwapi:geuquery ".wipo.int" . bd:serviceParam mwapi:geulimit "max" . ?item wikibase:apiOutputItem mwapi:title . } } } } AS %get_items WHERE { INCLUDE %get_items ?item ?prop ?statement . ?property wikibase:claim ?prop . ?property wikibase:statementProperty ?ps . ?statement ?ps ?value . ?statement prov:wasDerivedFrom ?reference . ?reference ?refprop ?reference_URL . FILTER CONTAINS(STR(?reference_URL), "wipo.int/") SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en" . } }

Use at

PREFIX mwapi: <http://wikiba.se/ontology#>
PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX prov: <http://www.w3.org/ns/prov#>
PREFIX bd: <http://www.bigdata.com/rdf#>
#title: Find statements with references containing external links to wipo.int
# Description: Find item statements with references containing external links to wipo.int using http and https protocols
# Author: Dipsacus fullonum
# Date: 2021-09-17
SELECT ?item ?itemLabel ?property ?propertyLabel ?value ?valueLabel ?reference_URL
WHERE
{

{
  SELECT DISTINCT ?item
  WHERE
  {
    {
      # Find items with https URLs
      SERVICE wikibase:mwapi
      {
        bd:serviceParam wikibase:endpoint "www.wikidata.org" .
        bd:serviceParam wikibase:api "Generator" .
        bd:serviceParam mwapi:generator "exturlusage" .
        bd:serviceParam mwapi:geuprop "title" .
        bd:serviceParam mwapi:geunamespace "0" .
        bd:serviceParam mwapi:geuprotocol "https" .
        bd:serviceParam mwapi:geuquery "*.wipo.int" .
        bd:serviceParam mwapi:geulimit "max" .
        ?item wikibase:apiOutputItem mwapi:title .
      }
    }
    UNION
    {
      # Find items with http URLs
      SERVICE wikibase:mwapi
      {
        bd:serviceParam wikibase:endpoint "www.wikidata.org" .
        bd:serviceParam wikibase:api "Generator" .
        bd:serviceParam mwapi:generator "exturlusage" .
        bd:serviceParam mwapi:geuprop "title" .
        bd:serviceParam mwapi:geunamespace "0" .
        bd:serviceParam mwapi:geuprotocol "http" .
        bd:serviceParam mwapi:geuquery "*.wipo.int" .
        bd:serviceParam mwapi:geulimit "max" .
        ?item wikibase:apiOutputItem mwapi:title .
      }
    }
  }
}  ?item ?prop ?statement .
  ?property wikibase:claim ?prop .
  ?property wikibase:statementProperty ?ps .
  ?statement ?ps ?value .
  ?statement prov:wasDerivedFrom ?reference .
  ?reference ?refprop ?reference_URL .
  FILTER CONTAINS(STR(?reference_URL), "wipo.int/")
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en" . }
}

Query found at

graph TD classDef projected fill:lightgreen; classDef literal fill:orange; classDef iri fill:yellow; v2("?item"):::projected v3("?prop") v5("?property"):::projected v6("?ps") v8("?reference") v1("?reference_URL"):::projected v9("?refprop") v4("?statement") v7("?value"):::projected c11(["title"]):::literal c17(["*.wipo.int"]):::literal c3(["bd:serviceParam"]):::iri c15(["https"]):::literal c5(["www.wikidata.org"]):::literal c19(["max"]):::literal c13(["0"]):::literal c9(["exturlusage"]):::literal c22(["http"]):::literal c28(["#91;AUTO_LANGUAGE#93;,en"]):::literal c21(["mwapi:title"]):::iri c7(["Generator"]):::literal f0[["contains(str(?reference_URL),'wipo.int/')"]] f0 --> v1 subgraph union0[" Union "] subgraph union0l[" "] style union0l fill:#abf,stroke-dasharray: 3 3; subgraph s1["http://wikiba.se/ontology#mwapi"] style s1 stroke-width:4px; c3 --"mwapi:endpoint"--> c5 c3 --"mwapi:api"--> c7 c3 --"mwapi:generator"--> c9 c3 --"mwapi:geuprop"--> c11 c3 --"mwapi:geunamespace"--> c13 c3 --"mwapi:geuprotocol"--> c22 c3 --"mwapi:geuquery"--> c17 c3 --"mwapi:geulimit"--> c19 v2 --"mwapi:apiOutputItem"--> c21 end end subgraph union0r[" "] style union0r fill:#abf,stroke-dasharray: 3 3; subgraph s1["http://wikiba.se/ontology#mwapi"] style s1 stroke-width:4px; c3 --"mwapi:endpoint"--> c5 c3 --"mwapi:api"--> c7 c3 --"mwapi:generator"--> c9 c3 --"mwapi:geuprop"--> c11 c3 --"mwapi:geunamespace"--> c13 c3 --"mwapi:geuprotocol"--> c15 c3 --"mwapi:geuquery"--> c17 c3 --"mwapi:geulimit"--> c19 v2 --"mwapi:apiOutputItem"--> c21 end end union0r <== or ==> union0l end v2 -->v3--> v4 v5 --"mwapi:claim"--> v3 v5 --"mwapi:statementProperty"--> v6 v4 -->v6--> v7 v4 --"prov:wasDerivedFrom"--> v8 v8 -->v9--> v1 subgraph s2["http://wikiba.se/ontology#label"] style s2 stroke-width:4px; c3 --"mwapi:language"--> c28 end