Closed KonradHoeffner closed 2 years ago
ThomasPause
commented
5 years ago SPARQL Query to investigate chapter-page-data:
select distinct STR(?chapter) AS ?chapter ?chapterNumber xsd:int(?firstPage) AS ?firstPage xsd:int(?lastPage) AS ?lastPage
from sniko:bb
{
?chapter a meta:Chapter;
meta:chapterNumber ?chapterNumber;
meta:firstPage ?firstPage;
meta:lastPage ?lastPage.
} ORDER BY(xsd:int(?firstPage))
KonradHoeffner
commented
2 years ago The original SPARQL query does not return any results anymore. Adapt to the current meta model:
SELECT DISTINCT(?left) ?lpage STR(?lchapter) AS ?lchapter ?rpage STR(?rchapter) AS ?rchapter ?right
FROM sniko:bb
{
?left a [rdfs:subClassOf meta:Top];
bb:page ?lpage;
meta:chapter ?lchapter.
?right a [rdfs:subClassOf meta:Top];
bb:page ?rpage;
meta:chapter ?rchapter.
FILTER(xsd:integer(?lpage)<xsd:integer(?rpage))
FILTER(xsd:integer(?lchapter)>xsd:integer(?rchapter))
} ORDER BY ASC(xsd:integer(?lpage))Still no results, but many appear when removing the filter, so this seems to be resolved.
See also #296. See also https://github.com/IMISE/snik-cytoscape.js/issues/214.
The following SPARQL query selects pairs of classes where the left one has a smaller page number but a larger chapter than the right one, there must be an error in one of them for each such pair.