Template talk:Wikidata list

More examples

Could we have example's for other lists? For example, when I am improving a group of people of things I like to have a listeria on a talk page so I can see what's missing

for example

Members of the conservative party in the UK

      ?item wdt:P102 wd:Q9626.
      ?item p:P2171 ?statement0.
      ?statement0 (ps:P2171) _:anyValueP2171.
 } LIMIT 100
|columns=label:Article,description,P214,P213,P102,P10849,P10632,p6213,P4527,P4789,P646,p2671,P10849,P5297,P11619

All the series of a given television franchise

{{Wikidata list
|sparql=SELECT ?item WHERE {
   ?item wdt:P179 wd:Q556444
  }
|columns=label:Article,description,P580,P582,P276,P625,P18,P1346,P646,P2671,P371,P364,P1113,P6262

Back ache (talk) 14:04, 5 June 2023 (UTC)

Statements

Is it possible to use Listeria bot to return statements? It would be very useful if it was possible :-) As an example, I am currently trying to reformulate a sparql question for use with Listeria that list people that has been member of a sports club (currently there are a lot of these type of lists on Wikipedia, but they easily become outdated):

Url for the question: https://query.wikidata.org/#SELECT%20%3Fhuman%20%3FhumanLabel%20%3FstartTime%20%3FendTime%20%3FmembershipStatement%20WHERE%20%7B%0A%20%20%3Fhuman%20wdt%3AP31%20wd%3AQ5%3B%0A%20%20%20%20p%3AP54%20%3FmembershipStatement.%0A%20%20%3FmembershipStatement%20ps%3AP54%20wd%3AQ3149147%3B%0A%20OPTIONAL%20%7B%0A%20%20%20%20%3FmembershipStatement%20pq%3AP580%20%3FstartTime.%20%20%20%23%20retrieve%20start%20time%20if%20available%0A%20%20%7D%0A%20%20OPTIONAL%20%7B%0A%20%20%20%20%3FmembershipStatement%20pq%3AP582%20%3FendTime.%20%20%20%20%20%23%20retrieve%20end%20time%20if%20available%0A%20%20%7D%20%20SERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%22en%22.%20%7D%0A%7D%20order%20by%20%3FstartTime

Syntax for the question.

SELECT ?human ?humanLabel ?startTime ?endTime ?membershipStatement WHERE {
  ?human wdt:P31 wd:Q5;
    p:P54 ?membershipStatement.
  ?membershipStatement ps:P54 wd:Q3149147;
 OPTIONAL {
    ?membershipStatement pq:P580 ?startTime.   # retrieve start time if available
  }
  OPTIONAL {
    ?membershipStatement pq:P582 ?endTime.     # retrieve end time if available
  }  SERVICE wikibase:label { bd:serviceParam wikibase:language "en". }
} order by ?startTime

Gunnar Larsson (talk) 13:55, 14 July 2023 (UTC)

Number of items in list - have I made a mistake?

Hello,

In https://tr.wiki.x.io/wiki/T%C3%BCrkiye%27deki_k%C3%B6m%C3%BCr_yak%C4%B1tl%C4%B1_elektrik_santralleri_listesi we can see the number of rows at the bottom of the table.

But I cannot get it to work in https://tr.wiki.x.io/wiki/T%C3%BCrkiye%27deki_enerji_santralleri_listesi

Can anyone see if I have made a mistake? Chidgk1 (talk) 12:28, 17 December 2023 (UTC)