[12:35:59] Hi! I was wondering if there is a tool for adding the same description to many items? [13:02:03] Ivi104: You could use quick statements [13:02:24] Or ask one of the bot operators to do it in one of their next runs [13:24:31] multichill thanks! [13:38:22] Ivi104: What are you trying to add? [17:19:05] SPARQL: Anybody can tell what I did wrong with "description" column ! See query here: http://tinyurl.com/gp9tv63 [17:20:31] Benoit-Rochon: you need ?item schema:description ?description in line 11 – http://tinyurl.com/jd4b3jz [17:21:15] or you can use the default names for those variables, then you don’t need to specify them in the SERVICE wikibase:label block: http://tinyurl.com/zu6mmky [17:24:23] WikidataFacts: MAGNIFIQUE. Much better like this. Thanks a lot. [17:24:29] you’re welcome :) [17:26:59] Is it easy to add a column "wp" and add languages where these items have articles? Example: "en, es, fr". [17:27:16] WikidataFacts: I'm at https://github.com/sparcopen/open-research-doathon and I'm showing https://twitter.com/WikidataFacts/status/830872600603684866 as an introduction to wikidata: people love it! [17:27:45] pintoch: awesome, glad to hear it! [17:30:08] Benoit-Rochon: http://tinyurl.com/juz5zp4 [17:30:55] WikidataFacts: C'est parfait. You're my man! Merci beaucoup. [17:30:56] (note that this counts all sitelinks, which may include Wikisource, Wikivoyage etc., not just Wikipedias) [17:31:10] it's even beter [17:31:30] ah yes, I even see Marie-Victorin has two «fr»s in the list, that must be the reason :) [17:33:48] Not I understand why two "fr" [17:33:53] *Not sure [17:34:08] fr Wikipedia and fr Wikisource [17:34:22] https://www.wikidata.org/wiki/Q2596174 [17:34:37] Oh... [17:34:58] but actually there’s an easy fix for that: http://tinyurl.com/gqazhq6 [17:38:18] What will happen if an item have no article at all in any languages, will it show in the list but column "languages" will be empty ? [17:38:35] it should, yes [17:38:44] because of the OPTIONAL {} [17:44:05] WikidataFacts: Sorry, I broke the query by adding point on time (P585) http://tinyurl.com/jkpnlzp [17:45:26] yes, you need to mention the extra variable ?date in the GROUP BY clause as well [17:45:35] but there aren’t any results anyways: http://tinyurl.com/jlr6jsv [17:45:59] the point in time would be a qualifier on the award received statement, right? [17:46:06] Exact [17:46:12] okay [17:46:23] and it should probably be optional, I assume? or do you only want results where it exists? [17:47:23] here’s the query for that: http://tinyurl.com/hj97hsm [17:47:35] (Winston Churchill is now included, which distorts the results table a bit :/ ) [17:49:34] Lollll. I don't think Winston Churchill won that prize [17:50:35] according to Wikidata, he did [17:50:41] though there’s no reference on the statement [17:50:59] http://www.acfas.ca/prix-concours/prix-acfas/therese-gouin-decarie [17:51:33] Winston Churchill is not French Canadian ! [17:53:03] https://www.wikidata.org/w/index.php?title=Q8016&diff=204698168&oldid=204660162