[10:34:16] Hi folks, Quarry-ish question. I'd like to figure out how many users have used the Flickr2Commons tool so far, and preferably also their user names + number of files uploaded through Flickr2Commons. We unfortunately do NOT have a Flickr2Commons related category on Wikimedia Commons; but uploads do have a tag: https://commons.wikimedia.org/wiki/Special:OAuthListConsumers/view/151e [10:34:17] da39f933bebf7375cf338558d1cc ... would it possible to retrieve such a list / number via Quarry and if so, what would that query look like? [10:57:48] I think I made a similar query a while ago: https://quarry.wmcloud.org/query/66237 (re @trnstlntk: Hi folks, Quarry-ish question. I'd like to figure out how many users have used the Flickr2Commons tool so far, and preferably al...) [10:58:10] "ct_tag_id = 22" refers to the edit tag I was interested in (mobile app edit). [11:02:32] Thank you! Where can I find the tag ID? Currently looking for it 😊 [11:03:33] you can look in the... [11:04:13] select ct_id from change_tag where ct_tag = 'TagName'; [11:04:16] tag name as per https://commons.wikimedia.org/wiki/Special:Tags [11:04:23] so flickr2commons [11:04:27] select ct_id from change_tag where ct_tag = 'flickr2commons'; [11:04:48] gah, no [11:04:51] normalisation [11:05:19] select ctd_id from change_tag_def where ctd_name = 'flickr2commons'; [11:05:25] 381 [11:05:35] Thank you !!! [11:06:30] Aren't you looking for "OAuth CID 1771" judging by https://commons.wikimedia.org/w/index.php?hidebots=1&translations=filter&hidecategorization=1&hideWikibase=1&tagfilter=OAuth+CID%3A+1771&limit=500&days=30&enhanced=1&title=Special:RecentChanges&urlversion=2 [11:07:15] In that case, the number is 469. [11:14:15] just write the join with `change_tag_def` into the main quarry query please [11:14:37] instead of having weird inscrutable constants in there [11:14:42] heh [11:14:46] the “OAuth CID” isn’t much better but at least you can see it in Special:Tags [11:16:53] I adjusted Yusuke's query slightly and now have this - https://quarry.wmcloud.org/query/74803 but is it possible to have usernames rather than their IDs? And also have a count of uploads per users rather than the individual uploads? I'm not a dev, hence my asking. I'm trying to compare with https://quarry.wmcloud.org/query/17556 but that seems to use a different database table... am I correct? [11:17:55] I’m trying it here https://quarry.wmcloud.org/query/74806 [11:19:36] I could be wrong, but I remember hitting some kind of limit (the result set was very large) and managed to avoid it by skipping the one join. (re @lucaswerkmeister: just write the join with change_tag_def into the main quarry query please) [11:21:06] yay, it finished (re @lucaswerkmeister: I’m trying it here https://quarry.wmcloud.org/query/74806) [11:21:57] and seeing @IVeertje in the list makes me think it’s probably not completely wrong at least ;) [11:31:33] It looks realistic to me too! [11:31:44] Thanks so much! You are all fantastic! [11:40:37] just let us know where to send the invoice ;)