[14:53:19] it seems impossible but I don't find the gol property for any soccer player [15:02:42] https://www.wikidata.org/wiki/Property:P6509 ? [15:02:46] and I am not able to select a specific entity [15:02:59] I want to select cristiano ronaldo [15:03:38] phschafft: yes I found them but none of the succer players has this property, they have goal for clubs [15:03:42] from what I see [15:03:43] https://www.wikidata.org/wiki/Q11571#P6509 [15:05:05] not right [15:05:36] what do you mean with 'not right'? [15:05:42] how many goals has scrored Cristiano Ronaldo in his career ? [15:05:45] *scored [15:06:54] according to that data 2 on 12 August 2014, and 7 between 18 December 2008 and 16 December 2017 [15:07:16] it's for sure incorrect [15:07:43] you have to go to member of sport team, then look at https://www.wikidata.org/wiki/Property:P1351 and then sum them [15:07:47] then feel free to check the referenced sources and make a correction if found to be wrong. [15:09:32] I want to try with aggregate sum [15:12:24] maybe that data is just not there. [15:21:35] to be honest I am still stuck at ?item wdt:P31 wd:Q937857. [15:21:47] that gives nothing [15:23:02] this neither ?item wdt:P31 wd:Q937857. [15:23:11] ops ?item wdt:p106 wd:Q937857. [15:23:22] yes. [15:23:29] P106 is the correct one. [15:23:45] it gives nothing [15:24:04] P106 not p106 [15:24:20] ok nice thanks [15:28:24] then FILTER(?item in (wd:Q11571)). to select cristiano ronaldo... but nothing [15:31:39] VALUES ?item {wd:Q11571} [15:31:54] generally avoid using FILTER() when possible. [15:32:40] ok but what's wrong in my condition ? even ?item = wd:Q11571 doesn't work [15:40:02] I think it needs a cast or something. [15:51:39] I am stuck at this https://w.wiki/9dZn I don't know why it doesn't work [15:52:21] solved :) [15:52:50] I missed a P [15:55:21] I think I did it: number of goals in career by Cristiano Ronaldo https://w.wiki/9dZq [16:20:14] :) [21:29:57] ?item wdt:P31/wdt:P279* wd:Q11424. wd:Q41163 wdt:P175 ?item. all the films of Al Pacino why this doesn't work? [21:38:36] ?item wdt:P31/wdt:P279* wd:Q11424. wd:Q41163 wdt:P175 ?item. [21:38:37] ? [21:38:41] em. [21:39:00] ?item (wdt:P31/(wdt:P279*)) wd:Q11424; wdt:P161 wd:Q41163. [21:39:07] copy and paste didn't work. [21:40:34] I was able to do it in this way [21:40:39] but I don't get why I can't do the reverse [21:41:03] you are telling ?iteam has as actor Al Pacino [21:41:15] I was saying Al Pacino was an actor of ?item [21:41:20] it's not the same? [21:41:57] no. [21:42:18] wikidata uses a data model that is more one-directional (but you can ask both ways). [21:42:44] it's not simple [21:43:50] wd:Q41163 wdt:P175 ?item [21:43:53] it's not wrong [21:46:26] That's not what P175 is for. It is for a role, like Batman P175 Adam West and Batman P175 Michael Keaton. [21:48:07] so what to use? [21:48:21] film P161 actor [21:49:03] no [21:51:06] you can do film p161 actor [21:51:15] but no actor p161 film [21:51:54] Why would you need actor P161 film when you can just write film P161 actor? [21:52:37] I want to understand if I can do the other way [21:53:42] No, why would you need to? You can write ?item wdt:P161 wd:XXX just as easily as wd:XXX wdt:P161 ?item. [21:53:47] find all the films of Al Pacino, my logic: find item that are films or subclass of films, al pacino is an actor of this item [21:53:54] but this doesn't work [21:54:11] you have to do find item that are films or subclass of films, iteam has in the cast Al Pacino [21:55:11] ?item wdt:P161 wd:Q41163 [21:55:17] what is difficult about that? [21:55:28] it is what I did [21:56:19] nervmind just some experiments on queries [21:56:47] Works fine for me. [21:57:04] it works but you don't get my point [21:57:08] I was trying to do the other path [22:03:52] I think this is a misconception on how the data structure is modeled. [22:04:19] properties are not one way streets. [22:04:51] you can freely navigate them both ways. [22:05:21] it is just that they have only one name (not a name and an inverse name). [22:05:24] it doesn't seem [22:06:14] and having an extra propery that is a inverse property wouldn't add much as you would then have two equal two-way streets in parallel.