query-b03d062a09443ebcbd5c5893faee93f5

rq turtle/ttl

TODO

Use at

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

PREFIX xsd: <http://www.w3.org/2001/XMLSchema#>
PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
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 bd: <http://www.bigdata.com/rdf#>
#defaultView:ImageGrid
SELECT DISTINCT ?item ?itemLabel ?seq ?person ?personLabel (SAMPLE(?image_) AS ?image) 



WHERE {
   {
  SELECT (COUNT(DISTINCT(?item1)) AS ?seq) ?item ?person WHERE {
     {
  SELECT ?item ?person WHERE {
    ?item wdt:P5008 wd:Q117322976;    # item on focus list of the LSESuffrageInterviewsProject
      wdt:P31 wd:Q178651 .           # item is an interview
    ?item p:P710 ?statement .         # item has a participant statement
    ?statement ps:P710 ?person .      # participant is ?person
    ?statement pq:P3831 wd:Q55534929. # qualifier object has role is interviewee
    ?item wdt:P921 ?person .         # main subject is same as participant
  }
}.
    {
      SELECT (?item AS ?item1) ?person WHERE{
         {
  SELECT ?item ?person WHERE {
    ?item wdt:P5008 wd:Q117322976;    # item on focus list of the LSESuffrageInterviewsProject
      wdt:P31 wd:Q178651 .           # item is an interview
    ?item p:P710 ?statement .         # item has a participant statement
    ?statement ps:P710 ?person .      # participant is ?person
    ?statement pq:P3831 wd:Q55534929. # qualifier object has role is interviewee
    ?item wdt:P921 ?person .         # main subject is same as participant
  }
}.
      } 
    } FILTER (str(?item1) <= str(?item)) 
  } GROUP BY ?item ?person 
}  
  OPTIONAL { 
     {
  SELECT (COUNT(DISTINCT(?item1)) AS ?seq) ?item ?person WHERE {
     {
  SELECT ?item ?person WHERE {
    ?item wdt:P5008 wd:Q117322976;    # item on focus list of the LSESuffrageInterviewsProject
      wdt:P31 wd:Q178651 .           # item is an interview
    ?item p:P710 ?statement .         # item has a participant statement
    ?statement ps:P710 ?person .      # participant is ?person
    ?statement pq:P3831 wd:Q55534929. # qualifier object has role is interviewee
    ?item wdt:P921 ?person .         # main subject is same as participant
  }
}.
    {
      SELECT (?item AS ?item1) ?person WHERE{
         {
  SELECT ?item ?person WHERE {
    ?item wdt:P5008 wd:Q117322976;    # item on focus list of the LSESuffrageInterviewsProject
      wdt:P31 wd:Q178651 .           # item is an interview
    ?item p:P710 ?statement .         # item has a participant statement
    ?statement ps:P710 ?person .      # participant is ?person
    ?statement pq:P3831 wd:Q55534929. # qualifier object has role is interviewee
    ?item wdt:P921 ?person .         # main subject is same as participant
  }
}.
      } 
    } FILTER (str(?item1) <= str(?item)) 
  } GROUP BY ?item ?person 
}
    FILTER (?seq > 1) .
    ?person wdt:P18 ?img  .
    BIND( IRI('http://commons.wikimedia.org/wiki/Special:FilePath/Arrow slim right.svg') AS ?image_ ) .
  }

  OPTIONAL { ?person wdt:P18 ?image_} .

  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". } 
} GROUP BY ?item ?itemLabel ?person ?personLabel ?seq
ORDER BY xsd:integer(STRAFTER(str(?person), 'Q')) ?item

Query found at

• https://www.wikidata.org/wiki/Wikidata:Request_a_query/Archive/2024/02