User talk:Sean.hoyland
Khirbet 'Ein Karzaliyah (Arabic: خربة عين كرزلية), Jordan Valley: December 2013 - January 2014
Id'eis (Arabic: ادعيس), Jordan Valley: May 2014
_by_Ron.jpg) | This user talk page might be watched by friendly talk page stalkers which means that someone other than me might reply to your query. Their input is welcome and their help with messages that I cannot reply to quickly is appreciated. |
|
Archives
|
|
This page has archives. Sections older than 5 days may be automatically archived by Lowercase sigmabot III. |
Extended confirmed blocked
Curious how your 2024 numbers compare to 2022 (so as to remove any of the current Israel/Palestine conflict) if this is something you could run. Best, Barkeep49 (talk) 18:23, 5 November 2024 (UTC)
- If you mean the numbers I posted at SPI (that I seem to have got a bit wrong at first because my understanding of the data model is apparently still full of holes), I'm still thinking about what to do. I was just curious whether there is any relationship between how long an account takes to become EC and whether they are eventually blocked for ban evasion. I wasn't expecting to see so few accounts even making it to EC. I'll try to have a look at the stats over the years when I get a chance. Sean.hoyland (talk) 19:00, 5 November 2024 (UTC)
- Barkeep49, well, this has turned into a bit of a rabbit hole, but in the meantime, here's some data for interest.
- This is for all of Wikipedia rather than the PIA topic area. I'll try to see if stats for the subset of accounts with edits in PIA are different from Wikipedia in general when I have time.
- These are monthly stats for accounts that were granted the EC privilege. The block_sock_count column gives the number that were blocked as socks (based on the presence of one of the following terms in the block log - "checkuser", "sock", "multiple accounts", "evasion", "proxy").
- Just looking at accounts that registered this year skews the picture as it seems that most grants for extendedconfirmed are to accounts that took more than a year to acquire the privilege.
- 2016 is unusual presumably because that was the year the privilege was rolled out.
- The percentage of EC accounts blocked as socks seems to vary quite a lot.
Extended content
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
massacres
Hi, I think that there are 1783 articles with "massacre" in the title, but how do I restrict it to ARBPIA articles? I know a little bit of SQL but I'm a novice on the WP database. Zerotalk 07:22, 8 November 2024 (UTC)
- I have the data for that already - I can upload it in a couple of hours unless Sean also has it handy. BilledMammal (talk) 07:24, 8 November 2024 (UTC)
- I never have anything handy including my hands. Sean.hoyland (talk) 07:29, 8 November 2024 (UTC)
- I ended up doing it slightly differently than I planned, and adapted an old quarry query. Results are here BilledMammal (talk) 07:45, 8 November 2024 (UTC)
- Different SQL, same results, plus the 3 redirects. Disappointing. Sean.hoyland (talk) 08:16, 8 November 2024 (UTC)
- I ended up doing it slightly differently than I planned, and adapted an old quarry query. Results are here BilledMammal (talk) 07:45, 8 November 2024 (UTC)
- I never have anything handy including my hands. Sean.hoyland (talk) 07:29, 8 November 2024 (UTC)
<- Still, I can never miss the opportunity presented by 2 people doing the same thing and potentially producing inconsistent results. This is what I get, limited to article namespace but including redirects.
- Much obliged. Zerotalk 11:11, 8 November 2024 (UTC)
- Missed 3 redirects because of the binary collation that I always forget. Sean.hoyland (talk) 11:20, 8 November 2024 (UTC)
- Much obliged. Zerotalk 11:11, 8 November 2024 (UTC)
Extended content
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
I added a column for years and victims. I removed redirects and the one about assassinations as that only incidentally had massacre in the title (but feel free to put it back). There are two about Palestinians killing Syrians or Lebanese and I'm not sure they belong but I left them in. Zerotalk 11:53, 8 November 2024 (UTC)
- No problem. You can update the table any way you like. For future reference, about restricting selections to the topic area, the SQL (without formatting) I ran is below. You can see there are a couple of common table expressions, 'pia_titles' and 'pia', to get all of the article titles in the approximation of the topic area, then you can join to 'pia' selection. The query takes 0.422 sec to execute through an SSH tunnel to the enwiki.analytics.db.svc.wikimedia.cloud database server from my laptop.
with pia_titles as (
select
p.page_title
from linktarget lt
join templatelinks tl on tl.tl_target_id = lt.lt_id
join page p on p.page_id = tl.tl_from
where lt.lt_namespace = 10 -- Template
and lt.lt_title in ("ArbCom_Arab-Israeli_enforcement", "Contentious_topics/Arab-Israeli_talk_notice")
and page_namespace = 1
union
select page_title
from page
join categorylinks israel on page_id = israel.cl_from and israel.cl_to = "WikiProject_Israel_articles"
join categorylinks palestine on page_id = palestine.cl_from and palestine.cl_to = "WikiProject_Palestine_articles"
where
page_namespace = 1
),
pia as (
select p1.page_id, p1.page_title, p1.page_namespace
from
pia_titles pt
join page p1 on p1.page_title = pt.page_title and p1.page_namespace = 0
)
select
concat('[[',convert(replace(p.page_title, '_',' ') using utf8mb4),']]') page_title,
p.page_namespace,
p.page_is_redirect
from page p
join pia on p.page_title = pia.page_title
where
p.page_namespace = 0
and convert(p.page_title using utf8mb4) like '%massacre%'
order by 1
Historic cu data
Hi - I've come here because that particular SPI probably isn't the best place to discuss general stuff about cu data - better to keep the archive uncluttered.
The short answer is that there is no way for non CUs to tell how much historic data is available, if any. Even administrators and SPI clerks can't see it - you need the CU flag in order to have any access to the places where it's visible. I won't go into too much detail about the types of info that are available, but in broad terms there is almost always some information available about accounts which have been checked in the past.
If you have suspicions about an account, I'd urge you not to factor whether the old accounts are likely to be stale into your decision about whether or not to report - if you have behavioural evidence, report it. We would need that evidence anyway to justify a check if the data is available, and if it's not, behavioural evidence can be strong enough to block an account without the need for a cu hit. Hope that's helpful. Girth Summit (blether) 13:48, 8 November 2024 (UTC)
- Thanks, yes, that's very helpful. Sean.hoyland (talk) 14:27, 8 November 2024 (UTC)
- Can we make Sean an admin just so he can better explore CU stuff? BilledMammal (talk) 14:58, 8 November 2024 (UTC)
- @BilledMammal: - Sean can request adminship in the usual way (or I guess I should say one of the usual ways, now that we're in the era of admin elections), if he's interested, of course. As I said though, admins can't see any of this stuff either unless they have the CU bit. The fastest way for anyone to get that just now would probably be to get elected onto Arbcom, the candidates list is rather short at the moment...
- @Sean.hoyland: - as an afterthought, I'd like to add that the possibility of them running multiple accounts in parallel did occur to me. I always check for them, but I looked more carefully than I might otherwise have done, in light of the previous cases. All I can say is that some of their editing (but not the majority) comes from a shared IP address, and there are a few other accounts on that IP, any of which might be them, but based on a combination of technical and behavioural observations, I think that unlikely. Certainly, none of them are interested in any of the same subject matter, none of them get involved in discussions or articles that the others are involved in, and it looks for all the world to me like they're all innocently using an institutional internet connection that multiple people have access to. Most of their editing is coming from private IPs, which do not have any other traffic on them. Now, there's no way that CU could detect someone using multiple accounts if they are careful to use different devices and internet connections for each one; all I can say is that if they're doing that, they're being a lot more careful about it now than they have been in the past. Girth Summit (blether) 15:27, 8 November 2024 (UTC)
- The way I look at it is that if I'm willing to waive anonymity, I should have access to the private information currently redacted from the databases for the other 48 million accounts. There might be a flaw in this logic, but I'm just not seeing it. Thanks for the extra details, interesting. Sean.hoyland (talk) 15:46, 8 November 2024 (UTC)
- Me too! Unfortunately, it's not unfettered access. Every time I run a check on an account, or an IP, that action is permanently logged, and other CUs can see what I'm up to. They even audit my activity (the cheek!) If I run inappropriate checks, some pesky ombud or arb will come along and take my fancy permissions away. It's so unreasonable! Girth Summit (blether) 22:45, 8 November 2024 (UTC)
- The way I look at it is that if I'm willing to waive anonymity, I should have access to the private information currently redacted from the databases for the other 48 million accounts. There might be a flaw in this logic, but I'm just not seeing it. Thanks for the extra details, interesting. Sean.hoyland (talk) 15:46, 8 November 2024 (UTC)