Main Page: Difference between revisions

Line 225: Line 225:


SELECT
SELECT
   (GROUP_CONCAT(?q; separator=",") AS ?reports)
   (GROUP_CONCAT(?q; separator=",") AS ?item)
WHERE {
WHERE {
   ?report dreamst:P2 dreams:Q177 .
   {
   BIND(SUBSTR(STR(?report), 38) AS ?q)
    SELECT
      ?item ?itemLabel
    WHERE {
      ?item dreamst:P2 dreams:Q177 .
      SERVICE wikibase:label { bd:serviceParam wikibase:language "en". }
    }
    ORDER BY ?itemLabel
  }
   BIND(SUBSTR(STR(?item), 38) AS ?q)
   BIND(1 AS ?dummy)
   BIND(1 AS ?dummy)
}
}
GROUP BY ?dummy
GROUP BY ?dummy
</pre>
</pre>