[09:21:11] Hi, is it possible to define limitations (P2302) for authority data for "conflict with" (Q21502838) with boolean expressions? [12:01:30] Hi, is it possible to define limitations (P2302) for authority data for "conflict with" (Q21502838) with boolean expressions? [12:09:13] Hi, Arch2all :) [12:09:15] For example? [15:04:09] I find it confusing that forms have the text first and language code second and senses have the language code first and text second >_< [15:24:50] hi everyone [15:25:00] im in need of some question regarding wd queries [15:25:08] a query in particular im creating [15:25:23] if someone is keen to those, please let me know :) [15:25:40] just ask, if someone can help, they will [15:26:01] great [15:26:12] im trying to put some values in a map with layers [15:26:30] (and if nobody can help, there's always https://www.wikidata.org/wiki/Wikidata:Request_a_query) [15:26:31] the layers are divided by "instance of" property [15:27:13] but some entities have more than one 'instance of', and i dont want those labels to appear in the layer menu [15:27:37] i though i could use 'bind' to select which 'instance of' i want to use in that menu [15:27:47] but i havent been able to do the trick [15:29:12] do you have a link to the query you have so far? [15:29:25] sure [15:29:51] https://query.wikidata.org/#%23defaultView%3AMap%0ASELECT%20%3Fitem%20%3FitemLabel%20%3Flugar%20%3Fimagen%20%3Flayer%20%7B%0A%20%20%7B%3Fitem%20wdt%3AP31%20wd%3AQ8343784%7D%20UNION%20%7B%3Fitem%20wdt%3AP31%20wd%3AQ57165555%7D.%0A%20%20%3Fitem%20wdt%3AP17%20wd%3AQ77.%0A%20%20%3Fitem%20wdt%3AP31%20%3Ftipo.%0A%20%20OPTIONAL%20%7B%3Fitem%20wdt%3AP18%20 [15:29:51] %3Fimagen%7D.%0A%20%20OPTIONAL%20%7B%3Fitem%20wdt%3AP625%20%3Flugar%7D.%0A%20%20%20%20%20%20%20%20%20%20SERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%22%5BAUTO_LANGUAGE%5D%2Ces%22.%20%3Ftipo%20rdfs%3Alabel%20%3Flayer%20%7D%0A%7D [15:30:34] i dont want 'prison' to show in the layers menu [15:32:32] does changing the line with P31 to " ?item wdt:P31 ?tipo filter (?tipo != wd:Q40357) ." do what you want? [15:33:38] let me check [15:34:19] yes it does [15:34:23] thank you a lot [15:34:55] you're filtering out those values, right? [15:35:51] oh, another option: replace the lines which use P31 with "values ?tipo { wd:Q8343784 wd:Q57165555 }" and "?item wdt:P31 ?tipo ." [15:35:52] yes [15:36:08] that way you will only get those two values, instead of having to filter out any other values [15:42:32] is there a better way to abbreviate this?: [15:42:33] {?item wdt:P31 ?tipo filter (?tipo = wd:Q8343784)} UNION {?item wdt:P31 ?tipo filter (?tipo = wd:Q57165555)}. [15:42:58] im trying to understand what you meant in 'oh, another option.. ' [15:46:53] like this: https://tinyurl.com/y7g4qa7l [15:47:34] excelent [15:47:51] thank you [15:47:57] :) [16:00:27] nikki, ill bother you with another question.. [16:01:04] in that same query, when you use 'table' visualization, sometimes youll get the same entity several times (because some of them have two or more images) [16:01:24] can i do something so i get only one result per entity? [16:07:22] I think https://tinyurl.com/yc3zwpyw should work [16:08:47] sample() selects one of them, if there's one particular image which would always be best, you could edit the image on the item and mark it as preferred (there's a little arrow to the left) [16:10:11] great! [16:21:43] and.. i promise its the last.. [16:21:57] do you know why i dont see the labels in the table query? [16:22:20] the second column should show me the label of the items.. [16:54:58] Zeroth_: it seems you need to add "?item rdfs:label ?itemLabel" inside the service {} line [16:55:54] I'm not very familiar with the label service, but it seems if you assign some labels manually, it wants you to assign them all manually [16:58:50] ahhh [16:58:52] ok [16:58:56] ill try that [17:00:09] thanks [17:00:13] again [17:00:28] its a preety good visualization we ended up with [17:07:22] cool :) [17:56:28] PROBLEM - High lag on wdqs1003 is CRITICAL: 3602 ge 3600 https://grafana.wikimedia.org/dashboard/db/wikidata-query-service?orgId=1&panelId=8&fullscreen [18:18:18] o/ addshore (IRC) sorry to keep you bugging you! Is there anything I can do to move https://gerrit.wikimedia.org/r/#/c/mediawiki/extensions/Wikibase/+/465547/ along? [18:43:14] niedzielski: sorry, at tech conf all of this week, but ill try to fit in another round of review or poke someone else toward it [18:47:06] thanks addshore (IRC) ! [21:00:06] RECOVERY - High lag on wdqs1003 is OK: (C)3600 ge (W)1200 ge 284 https://grafana.wikimedia.org/dashboard/db/wikidata-query-service?orgId=1&panelId=8&fullscreen [21:56:15] PROBLEM - High lag on wdqs1003 is CRITICAL: 3652 ge 3600 https://grafana.wikimedia.org/dashboard/db/wikidata-query-service?orgId=1&panelId=8&fullscreen [23:04:36] RECOVERY - High lag on wdqs1003 is OK: (C)3600 ge (W)1200 ge 191 https://grafana.wikimedia.org/dashboard/db/wikidata-query-service?orgId=1&panelId=8&fullscreen