query-e1539cc50dcbd8b3effbc425b3547076

rq turtle/ttl

ORDER inside a GROUP_CONCAT()?I’am trying to order individual episodes inside a concatenated result. Without the GROUP_CONCAT the episodes are ordered correctly, with they start at ?nr “100″. Is there a method to order the result inside the GROUP_CONCAT?

Use at

• https://query.wikidata.org/sparql

PREFIX xsd: <http://www.w3.org/2001/XMLSchema#>
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX wd: <http://www.wikidata.org/entity/>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
PREFIX ps: <http://www.wikidata.org/prop/statement/>
PREFIX pq: <http://www.wikidata.org/prop/qualifier/>
PREFIX p: <http://www.wikidata.org/prop/>
SELECT (GROUP_CONCAT(?episode; SEPARATOR = " # ") AS ?episodelist) WHERE {
  {
    SELECT (CONCAT(?nr, " ", ?OT, "\n") AS ?episode) WHERE {
      {
        ?qid p:P179 ?series;
          wdt:P31 wd:Q21191270.
        ?series ps:P179 wd:Q728553;
          pq:P1545 ?nr.
        ?qid rdfs:label ?OT.
        FILTER((LANG(?OT)) = "en")
      }
    }
    ORDER BY xsd:integer(?nr)
  }
}

Query found at

• https://www.wikidata.org/wiki/Wikidata_talk:SPARQL_query_service/queries