query-8bd50856a37a8690561e6db8e630977c

PREFIX xsd: <http://www.w3.org/2001/XMLSchema#>
PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX wd: <http://www.wikidata.org/entity/>
PREFIX ps: <http://www.wikidata.org/prop/statement/>
PREFIX pq: <http://www.wikidata.org/prop/qualifier/>
PREFIX p: <http://www.wikidata.org/prop/>
PREFIX dct: <http://purl.org/dc/terms/>
SELECT ?lexemeId ?lemma ?dicoentry ?refnumber ?startpage ?endpage WHERE {
  ?lexemeId dct:language wd:Q150 ; wikibase:lemma ?lemma ; p:P1343 ?dico.
  ?dico ps:P1343 wd:Q115664643 ; pq:P304 ?page ; pq:P958 ?ref ; pq:P1932 ?dicoentry.
  BIND(xsd:integer(?ref) AS ?refnumber)
  BIND(xsd:integer(REPLACE(?page, "-[0-9]*", "")) AS ?startpage)
  BIND(xsd:integer(REPLACE(?page, "[0-9]*-", "")) AS ?endpage) 
}
ORDER BY ASC(?refnumber)

graph TD classDef projected fill:lightgreen; classDef literal fill:orange; classDef iri fill:yellow; v4("?dico") v7("?dicoentry"):::projected v9("?endpage"):::projected v3("?lemma"):::projected v2("?lexemeId"):::projected v5("?page") v6("?ref") v8("?refnumber"):::projected v8("?startpage"):::projected c2(["wd:Q150"]):::iri c6(["wd:Q115664643"]):::iri v2 --"dct:language"--> c2 v2 --"wikibase:lemma"--> v3 v2 --"p:P1343"--> v4 v4 --"p:statement/P1343"--> c6 v4 --"p:qualifier/P304"--> v5 v4 --"p:qualifier/P958"--> v6 v4 --"p:qualifier/P1932"--> v7 bind0[/"http://www.w3.org/2001/XMLSchema#integer(?ref)"/] v6 --o bind0 bind0 --as--o v8 bind1[/"http://www.w3.org/2001/XMLSchema#integer(replace(?page,'-#91;0-9#93;*',''))"/] v5 --o bind1 bind1 --as--o v8 bind2[/"http://www.w3.org/2001/XMLSchema#integer(replace(?page,'#91;0-9#93;*-',''))"/] v5 --o bind2 bind2 --as--o v9