[09:06:59] <guest_>	 hi everybody, I need help to obtain all main subjects of scientific articles, when such an article has more than one main subject. How can I do that?
[09:08:30] <Harmonia_Boulot>	 by a SPARQL query
[09:10:33] <Harmonia_Boulot>	 sorry, Wikidata is down at mine?
[09:11:22] <Harmonia_Boulot>	 guest_: and the endpoitn too...
[09:12:58] <guest_>	 Harmonia, yes using SPARQL, I did to get one main subject, but I'd like to combine the other main subjects if exist
[09:15:41] <Harmonia_Boulot>	 guest_: http://tinyurl.com/ydfpqwxg
[09:16:16] <Harmonia_Boulot>	 http://tinyurl.com/y8qnofn8 better
[09:21:09] <guest_>	 Harmonia, the query still doesn't retrieve all main subjects of a scientific article
[09:22:39] <guest_>	 It would be nice for example to have all main subjects of this item https://www.wikidata.org/wiki/Q28381075, which are three and not only one
[09:23:16] <guest_>	 which are: Wikipedia, semantic similarity and explicit semantic analysis
[09:27:22] <guest_>	 any help?
[09:28:44] <Harmonia_Boulot>	 guest_: any other day I would say yes, but Wikidata doesn't work at mine, so without seeing the items or being able to test the queries...
[09:28:52] <Harmonia_Boulot>	 my help will be very limited
[09:30:40] <guest_>	 Ah ok I see, Thank you anyway.
[09:31:22] <Harmonia_Boulot>	 guest_: does the query yield a result or a no matchings found?
[09:31:41] <Harmonia_Boulot>	 if it's a "no matching" i probably made a stupid error somewhere writing it
[09:32:39] <guest_>	 the first one -> no matching .... the second one -> times out
[09:33:04] <Harmonia_Boulot>	 if the first one doesn't work, the second won't
[09:33:10] <Harmonia_Boulot>	 probably a mistake then
[09:33:34] <Harmonia_Boulot>	 guest_: can you try this one? http://tinyurl.com/ya2c2cpx
[09:35:49] <Harmonia_Boulot>	 and this one: http://tinyurl.com/y7rgc5df
[09:37:48] <Harmonia_Boulot>	 guest_: second one should work, order it by name or Qid of articles
[09:38:13] <guest_>	 both works fine but in the output I see only one main subject and not all
[09:38:26] <Harmonia_Boulot>	 nope
[09:38:32] <Harmonia_Boulot>	 one line per subject
[09:38:44] <guest_>	 ah ok let me have a look
[09:38:46] <Harmonia_Boulot>	 so order it by article name or Qid
[09:39:16] <Harmonia_Boulot>	 for the second one, the first is a test for "only one subject articles"
[09:39:26] <Harmonia_Boulot>	 so of course you only have one subject
[09:42:54] <Harmonia_Boulot>	 hmm
[09:43:58] <Harmonia_Boulot>	 we can probably write a better query but without being to test them I won't be able to do more, I fear
[09:44:05] <Harmonia_Boulot>	 maybe someone else can help
[09:45:56] <guest_>	 As you said it is only one main subject, and I still need the rest :) .. I'll keep trying and hopefully one of us finds the solution :)
[09:46:43] <Harmonia_Boulot>	 guest_: I'll be home in seven hours, if you are still here i'll try again ^^
[09:46:59] <Harmonia_Boulot>	 what's your WD username?
[09:47:15] <Harmonia_Boulot>	 if I can write a decent query, I'll let you a message on your talk page
[11:33:15] <guest_>	 Hi Harmonia, sorry for the late answer. I had to go for lunch and left the office :)
[11:33:48] <guest_>	 my WD username is: [Sky xe]
[11:34:13] <guest_>	 thank you a lot :)
[11:34:37] <guest_>	 I'll also inform you if I get it to work
[15:56:55] <Auregann_WMDE>	 reminder: IRC office hour starts  in 2 hours, on #wikimedia-office :)
[17:35:54] <dennyvrandecic_>	 heya, is the office hour happening today?
[17:37:48] <sjoerddebruin>	 l
[17:37:51] <sjoerddebruin>	 Yes
[17:51:27] <Auregann_WMDE>	 yes, in 10min :)
[18:38:46] <sjoerddebruin>	 Who added 2 million qualifiers last week? https://grafana.wikimedia.org/dashboard/db/wikidata-datamodel-statements?refresh=30m&panelId=11&fullscreen&orgId=1&from=now-6M&to=now
[18:59:24] <multichill>	 sjoerddebruin: Wasn't me....... I think......
[19:01:13] <sjoerddebruin>	 1 million though*
[19:10:41] <Lydia_WMDE>	 multichill: "i think" :P
[19:16:40] <sjoerddebruin>	 Ugh, my watchlist is getting too big. Need sparql support for managing it. :P
[19:17:49] <Lydia_WMDE>	 sjoerddebruin: how many items on your watchlist?
[19:18:00] <sjoerddebruin>	 8780
[19:18:14] <sjoerddebruin>	 I think it's affecting loading of recent changes as well now..
[19:18:25] <Lydia_WMDE>	 Oo
[19:18:37] <Lydia_WMDE>	 you automatically watch all the items you edit?
[19:19:11] <sjoerddebruin>	 I love watching my created items.
[19:19:31] <sjoerddebruin>	 I'm removing disambiguation pages though.
[19:21:15] <Lydia_WMDE>	 *nod*
[19:33:39] <Guest37838>	 i have a wiki page i made in the past for a business. what do i have to do to my new one to be accepted. brave river solutions
[19:36:46] <Guest37838>	 anyone>
[20:19:04] <sjoerddebruin>	 Unique constraints are now included in the gadget?
[21:25:26] <nikki>	 WikidataFacts: that template query you posted to the mailing list returns 112 results for me despite the limit 100 in it o_O
[21:26:16] <sjoerddebruin>	 multiple statements on one item?
[21:26:32] <WikidataFacts>	 spoooky
[21:26:47] <WikidataFacts>	 I got 110 just now
[21:26:57] <nikki>	 I got 110 earlier when I tried, probably depends on the server
[21:27:02] <nikki>	 since they love getting out of sync >_<
[21:28:11] <WikidataFacts>	 I tried the inner query on its own and got 100 results
[21:28:21] <WikidataFacts>	 but I don’t think the outer query could add any results, it’s just label service
[21:28:27] <nikki>	 yeah, exactly
[21:30:08] <nikki>	 I tried removing [AUTO_LANGUAGE] in case that was doing something weird, but it's still the same
[21:31:37] <nikki>	 it looks like the extra 10/12 are duplicates, like I get 4 "Template:User sv-1"
[21:33:31] <WikidataFacts>	 oh yeah, I got Q5626735 (Template:Infobox) four times