Jump to content

User talk:RoySmith/Archive 39

Page contents not supported in other languages.
From Wikipedia, the free encyclopedia
Archive 35Archive 37Archive 38Archive 39Archive 40Archive 41Archive 45

Close some DRVs?

Hey Roy. I know you're focusing on other things these days, but there are a lot of DRVs that could use closing--too few regulars make hard closes hard. The only one where I think consensus is clear enough for a NAC and I didn't contribute is one I disagree with said consensus. Hobit (talk) 19:44, 27 April 2021 (UTC)

Hobit, No problem, I'll stop by and see what I can do. -- RoySmith (talk) 19:47, 27 April 2021 (UTC)
Thanks! Hobit (talk) 20:11, 28 April 2021 (UTC)
Hobit, No problem. It's a little frustrating that we're still arguing the same GNG vs SNG arguments that haven't been resolved after all these years. -- RoySmith (talk) 23:20, 28 April 2021 (UTC)
Went away for a while, but there has been a lot of pushing on some cricket bios and the closes have been all over the map because we don't have a resolution. Or at least not one we all agree on... Hobit (talk) 01:56, 29 April 2021 (UTC)
It's actually exceptionally frustrating because a consensus does exist regarding WP:NSPORT bios (2017 RfC) and WP:NSPORT is written in a way that requires WP:GNG. This particular argument should be resolved. If you can defeat an AfD by yelling loudly enough that a SNG is met, I don't know why I spend the time searching for sources to save the article... SportingFlyer T·C 11:53, 29 April 2021 (UTC)

DYK for Rocking the Boat

On 30 April 2021, Did you know was updated with a fact from the article Rocking the Boat, which you recently created, substantially expanded, or brought to good article status. The fact was ... that Rocking the Boat believes that kids are built by boats? The nomination discussion and review may be seen at Template:Did you know nominations/Rocking the Boat. You are welcome to check how many pageviews the nominated article or articles got while on the front page (here's how, Rocking the Boat), and if they received a combined total of at least 416.7 views per hour (i.e., 5,000 views in 12 hours or 10,000 in 24), the hook may be added to the statistics page. Finally, if you know of an interesting fact from another recently created article, then please feel free to suggest it on the Did you know talk page.

Cwmhiraeth (talk) 12:02, 30 April 2021 (UTC)

Deleted article

Hello, could you check Draft:Isak Hansen-Aarøen and Draft talk:Isak Hansen-Aarøen. I added some reliable sources to the article. I think the draft needs to be restored to normal page. --Corwin of Amber (talk) 11:15, 30 April 2021 (UTC)

Corwin of Amber, Hi. My suggestion is submitting the draft for review and seeing what one of the AfC reviewers thinks. My part in the process was strictly procedural, so I'll leave the judgement call to others. I did happen to notice, however, that the draft cites WP:RSNP#Daily Express, which "is considered generally unreliable". -- RoySmith (talk) 14:09, 30 April 2021 (UTC)

15:42, 3 May 2021 (UTC)

Sockpuppet investigations/Jenos450

Hi, You recently archived this Wikipedia:Sockpuppet investigations/Jenos450/Archive. Mz7 had closed it earlier and after closing, I reported them of an account Gotails12 in the SPI. The account very likely belongs to this master as the account was created after hours after the master was blocked and restored the sock edits in Vinayak Damodar Savarkar. Should I file another SPI about this account. Thanks SUN EYE 1 14:31, 4 May 2021 (UTC)

Suneye1, Yes, please file another SPI under the same master name. Whoever looks as the case will know to also go back and check the archives for additional information. Feel free to ping me if you have any additional questions. -- RoySmith (talk) 14:43, 4 May 2021 (UTC)
Thanks, I've filed the SPI (Wikipedia:Sockpuppet investigations/Jenos450). Could you please take a look. SUN EYE 1 15:19, 4 May 2021 (UTC)

Evidence of sockpuppetry not on Wikipedia

What can I do to report evidence of sockpuppetry that is not on Wikipedia? --BananaYesterday (talk) 18:22, 4 May 2021 (UTC)

BananaYesterday, You should contact a checkuser directly. See WP:CONTACTCU for how to do that; the tldr is to mail checkuser-en-wp@wikipedia.org. -- RoySmith (talk) 20:06, 4 May 2021 (UTC)

LTA and page protections

I'd have listed this at the SPI, but since it's already closed, I've left a request at RFPP for Romanian War of Independence. Do protect if you get there first. Cheers, RandomCanadian (talk / contribs) 23:18, 5 May 2021 (UTC)

RandomCanadian, Which SPI are we talking about? -- RoySmith (talk) 23:26, 5 May 2021 (UTC)
Thought it was obvious from the page history, but in any case: Wikipedia:Sockpuppet investigations/KızılBörü1071... RandomCanadian (talk / contribs) 23:31, 5 May 2021 (UTC)
RandomCanadian, Got it, thanks. The first time I read this, I read it at Romulan War of Independence, which had me kind of confused :-) -- RoySmith (talk) 23:39, 5 May 2021 (UTC)
May the fourth be with you.Yes I know its the wrong one but the date is so close... You might have more luck with Romulans on other wikis :) RandomCanadian (talk / contribs) 23:49, 5 May 2021 (UTC)

Re-blocking sock IP

Hi Roy,

One of the sock IPs from Wikipedia:Sockpuppet_investigations/Amfithea is active again (82.1.219.198 (talk · contribs · WHOIS)) and I'm...actually not sure how I'd go about getting them re-blocked. Do I need to re-open a case for an IP that was already judged to be the sockmaster, since the block has expired? Or is it sufficient to, you know, drop you a line since it's the same IP of the same banned user and the same behavior? –Roscelese (talkcontribs) 12:46, 7 May 2021 (UTC)

Roscelese, The best thing to do is to open a new case. I'll take a look in the meantime, but please also open the case so it gets into the archives properly. -- RoySmith (talk) 12:55, 7 May 2021 (UTC)
Thanks, done. –Roscelese (talkcontribs) 13:10, 7 May 2021 (UTC)

Administrators' newsletter – May 2021

News and updates for administrators from the past month (April 2021).

Administrator changes

removed EnchanterCarlossuarez46

Interface administrator changes

removed Ragesoss

Guideline and policy news

Technical news

  • The user group oversight will be renamed to suppress. This is for technical reasons. You can comment at T112147 if you have objections.

Arbitration


15:09, 10 May 2021 (UTC)

SPI Case

In reference to the previous SPI Investigations against User Adhithya Kiran Chekavar & Vishnu vaaish who were into the PR work of Thiyya promotion a new SPI Case was opened which is still awaiting checkuser for more than 30 days. More sock accounts are being created also desisting their stale accounts one after the other, Seems to make it harder for a checkuser to retrieve the data and will force them to close the case as lack of evidence. As I was being alleged intentionally on the recent SPI case your assistance is much appreciated whether to start a new case by myself. R.COutlander07@talk 07:47, 11 May 2021 (UTC)

Outlander07, Hi, and thanks for your note. I do feel your pain; SPI is badly backed up and it's taking far longer to work on cases than anybody is happy with. I wish I had something better to tell you. -- RoySmith (talk) 13:09, 11 May 2021 (UTC)
SPI is backed up, but checkuser specifically is not. The case in question did not have an active CU request, but I've put one in now. CMD (talk) 14:02, 11 May 2021 (UTC)

Another sock

Hi Roy. I'm afraid we have another DjdjPollard15 sock at User:DantheMad2021 at 2021 FA Cup Final (a high traffic article today). The C of E God Save the Queen! (talk) 15:26, 15 May 2021 (UTC)

The C of E, Could you open a SPI report please, so somebody can take a look at it? Thanks. -- RoySmith (talk) 16:45, 15 May 2021 (UTC)
Done. The C of E God Save the Queen! (talk) 16:18, 16 May 2021 (UTC)

13:48, 17 May 2021 (UTC)

May 19, 7pm: ONLINE WikiWednesday Salon NYC
Welcome to Wikimedia New York City!

You are invited to join the Wikimedia NYC community for our monthly "WikiWednesday" evening salon (7-8pm) and knowledge-sharing workshop. To join the meeting from your computer or smartphone, just visit this link. More information about how to connect is available on the meetup page.

We look forward to seeing local Wikimedians, but would also like to invite folks from the greater New York metropolitan area (and beyond!) who might not typically be able to join us in person!

If there's a project you'd like to share or a question you'd like answered, just let us know by adding it to the agenda or the talk page.

7:00pm - 8:00 pm online via Zoom (optional breakout rooms from 8:00-8:30)

(You can subscribe/unsubscribe from future notifications for NYC-area events by adding or removing your name from this list.)

--Wikimedia New York City Team 03:15, 18 May 2021 (UTC)

DS 2021 Review Update

Dear RoySmith,

Thank you for participating in the recent discretionary sanctions community consultation. We are truly appreciative of the range of feedback we received and the high quality discussion which occurred during the process. We have now posted a summary of the feedback we've received and also a preview of some of what we expect to happen next. We hope that the second phase, a presentation of draft recommendations, will proceed on time in June or early July. You will be notified when this phase begins, unless you choose to to opt-out of future mailings by removing your name here.
--Barkeep49 & KevinL (aka L235) 21:05, 19 May 2021 (UTC)

Just asking one thing

So you know how you blocked Cyberfan195? I saw his contributions before he was blocked, but I don't see anything wrong with them. Can you please explain why you blocked him? Thanks,DinosaurTrexXX33 (talk) 13:04, 21 May 2021 (UTC)

DinosaurTrexXX33, See Wikipedia:Sockpuppet investigations/Cyberfan195/Archive -- RoySmith (talk) 13:18, 21 May 2021 (UTC)

A tag has been placed on Category:18th-century Belgian sculptors indicating that it is currently empty, and is not a disambiguation category, a category redirect, a featured topics category, under discussion at Categories for discussion, or a project category that by its nature may become empty on occasion. If it remains empty for seven days or more, it may be deleted under section C1 of the criteria for speedy deletion.

If you think this page should not be deleted for this reason you may contest the nomination by visiting the page and clicking the button labelled "Contest this speedy deletion". This will give you the opportunity to explain why you believe the page should not be deleted. Please do not remove the speedy deletion tag from the page yourself. Liz Read! Talk! 13:36, 22 May 2021 (UTC)

Liz, Hmmm, I see I created this cat a while ago, but if it's no longer in use, I certainly have no objection to it being deleted. Thanks for the ping. -- RoySmith (talk) 16:41, 22 May 2021 (UTC)

I removed a template you had posted

Hello, Roysmith! Wanted to inform you that I removed the photo-requested template you had added to Talk:Black Lives Matter last month. I removed it because, as you'd anticipated, the fence has been painted over by now. Still if you think someone may have taken a picture and might still upload it upon reading the request, I can restore it again. This template didn't inform me about what kind of photo was requested, however. Initially I thought it was an ancient request for any photograph at all. I had to go through the page's history (where I then also saw your post) in order to understand it. Take care. ---Sluzzelin talk 19:51, 19 May 2021 (UTC)

Sluzzelin, Sadly, I didn't know of any better way to get the attention of potential photographers. Sad, really, in so many ways. -- RoySmith (talk) 13:24, 21 May 2021 (UTC)
Oh, but you did, and Myotus responded! Only now, had I spotted Wikipedia_talk:WikiProject_Minnesota#Photo_needed_(time_sensitive). Thanks to both of you! ---Sluzzelin talk 14:43, 21 May 2021 (UTC)
Wow, I missed noticing that! Thanks Myotus! RoySmith-Mobile (talk) 16:36, 21 May 2021 (UTC)
Your welcome. Thanks for bringing it to my attention. Myotus (talk) 21:37, 22 May 2021 (UTC)
Myotus, BTW, I derived File:Black Lives Matter Fence (crop).jpg from yours, and used that in Black Lives Matter -- RoySmith (talk) 21:51, 22 May 2021 (UTC)

DYK nomination of Walter Gladwin

Hello! Your submission of Walter Gladwin at the Did You Know nominations page has been reviewed, and some issues with it may need to be clarified. Please review the comment(s) at your nomination's entry and respond there as soon as possible. Thank you for contributing to Did You Know! Carbrera (talk) 01:31, 24 May 2021 (UTC)

17:05, 24 May 2021 (UTC)

Sandesh9822

Reminding here about Wikipedia:Sockpuppet investigations/Sandesh9822. Maybe you didn't had my ping but nevertheless you seem really busy so you might have missed. Srijanx22 (talk) 23:04, 28 May 2021 (UTC)

Srijanx22, Unfortunately, the time I have available for SPI is quite limited these days. and this is a particularly complicated case so it'll require a substantial investment of time to look at. I'm afraid it'll need to wait for somebody else to get to it. -- RoySmith (talk) 23:12, 28 May 2021 (UTC)

There's something wrong with the above case. Can you please fix it?--Bbb23 (talk) 01:41, 30 May 2021 (UTC)

I'm clearly very tired. Nothing for you to fix. It was the filer's fault. Sorry to have bothered you.--Bbb23 (talk) 01:47, 30 May 2021 (UTC)
Bbb23, No problem. BTDT :-) -- RoySmith (talk) 02:00, 30 May 2021 (UTC)

A tag has been placed on Category:18th-century Belgian artists indicating that it is currently empty, and is not a disambiguation category, a category redirect, a featured topics category, under discussion at Categories for discussion, or a project category that by its nature may become empty on occasion. If it remains empty for seven days or more, it may be deleted under section C1 of the criteria for speedy deletion.

If you think this page should not be deleted for this reason you may contest the nomination by visiting the page and clicking the button labelled "Contest this speedy deletion". This will give you the opportunity to explain why you believe the page should not be deleted. Please do not remove the speedy deletion tag from the page yourself. Liz Read! Talk! 15:07, 30 May 2021 (UTC)

Image without license

Thanks for uploading File:Screen shot showing tag-check and spi-tools running twice.png. The image has been identified as not specifying the copyright status of the image, which is required by Wikipedia's policy on images. Even if you created the image yourself, you still need to release it so Wikipedia can use it. If you don't indicate the copyright status of the image on the image's description page, using an appropriate copyright tag, it may be deleted some time after the next seven days. If you made this image yourself, you can use copyright tags like {{PD-self}} (to release all rights), {{self|cc-by-sa-4.0}} (to require that you be credited), or any tag here - just go to the image, click edit, and add one of those. If you have uploaded other images, please verify that you have provided copyright information for them as well.

For more information on using images, see the following pages:

This is an automated notice by MifterBot. For assistance on the image use policy, see Wikipedia:Media copyright questions. NOTE: Once you correct this, please remove the tag from the image's page. --MifterBot (TalkContribsOwner) 16:45, 31 May 2021 (UTC)

17:04, 31 May 2021 (UTC)

Hello admin, Have a look at this section. I am suspected as the sock of Pheonixman. The reason nominator produced is my name. Yes, my name is Sharath Abhivadyah, there are around 1000+ Sharath Abhivadyahs in India. Actually, I don't know what's going around! I nominated some schools which fails WP:NSCHOOL user:Beccaynr claimed that is the same behaviour as the sock. You can check out all those, I stated this project as powerful karma and later renamed to AgentCody. I've nominated and voted around 97 articles. The schools I nominated as very less compared to biographies. Please solve this issue ASAP if possible. Thank you. Regards, AgentCody 01:53, 1 June 2021 (UTC)

Hello, Roy,

I was looking at a template deletion discussion and wanted to see what pages the template was used on and came across your user page. The article this page was based on was just deleted in a AFD deletion discussion. Not sure if this impacts whether or not you want it in your user space but thought I'd let you know. Liz Read! Talk! 05:06, 4 June 2021 (UTC)

Liz, That was for help in debugging T248796, but no, it's not of any use anymore. I'll delete it. -- RoySmith (talk) 12:54, 4 June 2021 (UTC)

DYK for Walter Gladwin

On 7 June 2021, Did you know was updated with a fact from the article Walter Gladwin, which you recently created, substantially expanded, or brought to good article status. The fact was ... that Walter Gladwin was the first black New York state assemblyman from the Bronx? The nomination discussion and review may be seen at Template:Did you know nominations/Walter Gladwin. You are welcome to check how many pageviews the nominated article or articles got while on the front page (here's how, Walter Gladwin), and if they received a combined total of at least 416.7 views per hour (i.e., 5,000 views in 12 hours or 10,000 in 24), the hook may be added to the statistics page. Finally, if you know of an interesting fact from another recently created article, then please feel free to suggest it on the Did you know talk page.

Cwmhiraeth (talk) 12:03, 7 June 2021 (UTC)

20:01, 7 June 2021 (UTC)

ANI

Please undo your close at AN, I was in the process of a formal proposal and I hardly think that conversation is done. PRAXIDICAE🌈 23:28, 8 June 2021 (UTC)

Praxidicae, The guy says he's retired. I don't honestly see how dragging this out will be useful. -- RoySmith (talk) 23:48, 8 June 2021 (UTC)
People often retire to escape sanctions and the conversation was far from over. PRAXIDICAE🌈 01:45, 9 June 2021 (UTC)
Praxidicae, I really can't see how anything useful will come of reopening the thread. If he stays retired, the problem is solved. If he comes back and starts being disruptive again, we can deal with it then. -- RoySmith (talk) 02:24, 9 June 2021 (UTC)

Administrators' newsletter – June 2021

News and updates for administrators from the past month (May 2021).

Administrator changes

added AshleyyoursmileLess Unless
removed HusondMattWadeMJCdetroitCariocaVague RantKingboykThunderboltzGwen GaleAniMateSlimVirgin (deceased)

Guideline and policy news

Technical news

  • Wikimedia previously used the IRC network Freenode. However, due to changes over who controlled the network with reports of a forceful takeover by several ex-staff members, the Wikimedia IRC Group Contacts decided to move to the new Libera Chat network. It has been reported that Wikimedia related channels on Freenode have been forcibly taken over if they pointed members to Libera. There is a migration guide and Wikimedia discussions about this.

Arbitration


INTSF SPI

Hi RoySmith, regarding this SPI, some of the accounts reported earlier are now old enough that they are autoconfirmed and being reactivated to bypass semi. If you don't have time to deal with the more complicated cases, it would be appreciated if you could nonetheless block the obvious ones. Best, CMD (talk) 02:09, 7 June 2021 (UTC)

Chipmunkdavis, Ugh. Yeah, I've been kind of busy lately, but I'll take a look. Thanks for the ping. -- RoySmith (talk) 02:25, 7 June 2021 (UTC)
Chipmunkdavis, Oh, yeah, ugh for sure. I'm probably not going to be able to make much headway there, but if you could compile a list of pages that would most benefit from WP:ECP, that I could probably do quickly. -- RoySmith (talk) 02:28, 7 June 2021 (UTC)
Yeah, it's a long report at the moment. If I might make a suggestion, it could help to start with the 09 May 2021 report and work backwards, as most of those are obvious attack or one-off accounts (added to since 9 May, but all obvious ones, and some are already blocked).
On protection, semi would be useful on Asbestos, Singapore Airlines, City-state, Singapore model. The two currently semied articles are Politics of the Philippines (purely for harassment against me) and Singapore passport (standard area of focus), and I suspect blocks would work fine, but both are also reasonably low traffic with not many editors or IPs so ECP probably wouldn't affect them too much if you prefer. (edit: Also my talkpage, but please don't ECP that.) CMD (talk) 03:30, 7 June 2021 (UTC)
Chipmunkdavis, I put ECP on those first four. I'll try to find some time to work through some of the SPI (but can't promise anything there). -- RoySmith (talk) 11:58, 7 June 2021 (UTC)

(@Blablubbs:) Regarding the 08 May 2021 case close (Commenting here since it was marked closed), I disagree with not blocking the "burner" accounts. There's a long history of sleepers here, and some "burner" accounts have been reactivated literally within the past couple of days to avoid semi, so they are clearly being kept track of. Not blocking makes the aggressive protection idea much less useful. CMD (talk) 10:04, 8 June 2021 (UTC)

Chipmunkdavis, I understand your frustration here, but SPI is badly backed up and we just don't have the time to give every case the attention it deserves. We're doing the best we can.
When we ask filers to give us more information or diffs, it's not that we're pushing back, it's that you know stuff that we don't and we're just trying to discover what it is. For example, when you wrote, Even if there wasn't an IP, there's some clear aspects of those edits which catch my attention, that really doesn't advance the case because you haven't told us what those aspects are. If it's something you'd rather not disclose in public, just note that and offer to mail the details to whoever is investigating the case. -- RoySmith (talk) 11:57, 8 June 2021 (UTC)
I was referring above to the 08 May 2021 section, not the 02 April 2021 one. Happy to provide more 08 May 2021 diffs, or further explain the aspects relating to 02 April 2021 if that would help. CMD (talk) 12:14, 8 June 2021 (UTC)
Chipmunkdavis, The more information you can provide, the easier it is to make progress. And the best information is pairs of specific diffs. As another example, in 13 April, you wrote, Mindandaeno's only edit is to restore previous LTA. Look at that from the point of view of a clerk working the case. You haven't identified the specific edit that was being restored. You haven't even identified which sock made the edit. So, the clerk needs to go hunting to find it. You already have that information. You obviously have found some previous edit which was restored. So just put the link to the diff in the SPI report. That makes the clerk's job trivial. If the clerk has to go hunting to rediscover the information that you've already found but haven't shared, well, that's how SPI gets backed up so badly. -- RoySmith (talk) 12:45, 8 June 2021 (UTC)
Noted, I'll take another look through the various reports in a bit. I think that at the time I was trying to keep a record of the sudden proliferation of socks, so the per-sock report quality dropped. CMD (talk) 13:12, 8 June 2021 (UTC)
Now done, including for 08 May 2021, which I hope you will be able to take another look at even though it was technically closed. I tried to make it very clear what the relationship of each account was to previous ones, and/or mention various behavioural details. (I even uncovered a previously missed account, although I didn't detail it.) I hope I am not sounding ungrateful for the work you have done, or sounding too frustrated. I appreciate very much the backlog, and only brought it up here because some of the accounts had gotten autoconfirmed and re-activated. I hope that what I've written now can make the remaining assessments very easy, and I expanded on a report by another user too which should make that one even clearer. Let me know again if there is more i could help with. CMD (talk) 11:29, 9 June 2021 (UTC)
Chipmunkdavis, I've worked my way through the INTSF backlog. Thank you for providing the specific diffs, that made it easy. If any of the accounts left unblocked start being disruptive again, please open a new report, and as always, it's going to be specific diff pairs that will make it possible for a clerk to make any progress.
Given the extensive use of proxies and volume of new accounts, page protection will almost certainly be a better tool than blocking in this case, not to mention that WP:RFPP is always faster to respond than SPI. Given the history here, my recommendation would be to ask for ECP of at least 6 months right off the bat, and refer to the SPI and/or this note if the RFPP folks are hesitant to do that. -- RoySmith (talk) 16:48, 9 June 2021 (UTC)
Thanks, this is noted. I'll try it now. How do I provide diffs for harassment accounts though? Diff my edit and their revert or something? I find it a bit odd they were the ones left unblocked, it feels they'd be the most obvious to determine. CMD (talk) 00:42, 10 June 2021 (UTC)
Chipmunkdavis, I remember looking at those and not being clear on why it was harrassment. So, basically you need to walk the clerk through it. "I did this edit, then the sock reverted it here, and then I did..., and the sock did...". Keep in mind that by the time you file an SPI report, you're much more familiar with the case than the processing clerk is. The clerk knows the procedures, and is authorized to perform certain actions, but you're the one who knows the history. And given how badly backed up SPI is, when a clerk is faced with a difficult or complex case, they're likely to just move onto a simpler case. So it's in your best interest to make it as simple for them as possible. -- RoySmith (talk) 00:55, 10 June 2021 (UTC)

An IP you range blocked recently

Greetings RoySmith. An IP you range blocked recently, 183.90.36.0/23, is actually not a proxy. It's a dynamic range of one of the main telecommunications providers of Singapore. That would mean there's potentially up to ten of thousands of unique users on that IP range within any given time, and some might be enthusiastic users of Wikipedia unrelated as being a sockpuppet. As we can see, the last time this IP was blocked for only a month, there were three occasions (1, 2 and 3) where innocent individuals were caught by the block, and couldn't edit as a result. I also don't think ineedotstopforgetting would even use this IP range as they are probably smarter than that, especially considering that they are not a new investigation and that this would cause instant detection.

My point is that we shouldn't be quick to assume and associate every edit related to Singapore as being the doing of ineedtostopforgetting, as this could negatively affect many other potential users from Singapore or the region from editing its WikiProject. For starters, when the IP was re-blocked again just days after the end of its month-long block due to Chipmunkdavis' reporting its possibility of it being a sock for one of the IP's editing on Singapore Airlines, it shouldn't be far fetched that it was probably just the work of a local aviation enthusiast editing the airline from their country, and not a malicious sockpuppet of ineedtostopforgetting. There's probably many more examples but I'm pointing this recent one out as it was the cause of it getting blocked once more. Cheers.

Also no before anyone asks, I'm not a sockpuppet of anyone, just an observer that desires anonymity who was previously affected by a similar but unrelated situation. SantiniXER (talk) 05:20, 10 June 2021 (UTC)

IP user and the current sockpuppet block

Hello @RoySmith:!, This IP user 49.149.72.236 has been currently adding some pictures again and the same edits of the current blocked sockpuppet account, Philippine 1812, of Cathay Pacific and Cathay Pacific fleet. I don't know what to say but I kinda stress with that IP user or anyone that adds more airline pictures. I mean, it's really not important to add more, but WP:EW it is. What's your opinion about this IP user? Cornerstone2.0 (talk) 15:19, 11 June 2021 (UTC)

Cornerstone2.0, Could you please open a new SPI report, that'll make it easier to process. Thanks. -- RoySmith (talk) 16:01, 11 June 2021 (UTC)
PS. the correct case is Mark Maglasang -- RoySmith (talk) 16:02, 11 June 2021 (UTC)

@RoySmith: sure thing. Thanks! Cornerstone2.0 (talk) 16:03, 11 June 2021 (UTC)

Hello there @RoySmith:, It says "An automated filter has identified this edit as potentially unconstructive, so it has been disallowed. If this edit is constructive, please report this error. Disruptive editing may result in a block from editing." What should I do? Cornerstone2.0 (talk) 16:25, 11 June 2021 (UTC)

Cornerstone2.0, Hmmm, not sure what you did to get that, but don't sweat it. I can generate the report myself, in a few minutes. -- RoySmith (talk) 16:27, 11 June 2021 (UTC)

@RoySmith: okay, thank you very much! Cornerstone2.0 (talk) 16:28, 11 June 2021 (UTC)

This is my first time of reporting a user, so please bear with me. I commented in below (comment by others) with the links of his/her edit. Cornerstone2.0 (talk) 17:27, 11 June 2021 (UTC)

SQL

I saw your Quarry 55807 at WP:ANI#Review of indefinitely salted article titles & had a go at adding wiki links. My effort Quarry 55915 is not pretty, and could do with some workaround to avoid using UNIONs. Just pointing you there in the hope you're up for further improving it. No worries if not. Cabayi (talk) 12:47, 12 June 2021 (UTC)

Cabayi, Thanks, but SQL is really not my strong suit. I putter around with simple queries, but that's about it. I guess what you're doing here is looking up the namespace names, but I'm not following the details and why you need the unions.
I'm still trying to figure out why Quarry 55882 times out. If I leave off the join with change_tag_def, it's fine. Something about that join obviously makes it unable to use an index, but beats me why. -- RoySmith (talk) 13:25, 12 June 2021 (UTC)
Looking for answers I just stumbled across this :-)
The query needs UNIONs (unless there's a better way) because the links need handling in different ways.
A previous way I was formatting the query (with a leading :w:en:) meant articles were coming out with a leading ::, without that, and looking at it again, articles are OK with a single leading colon. For categories, category:page would attempt to categorise the page rather than link to the category. It needs a distinct way of presenting the pages as wikilinks. Down to two queries, one UNION, hooray!
For Quarry 55882, (from my ever-more-distant memory of how Oracle used to handle queries)
order by rev_id desc
limit 10
it needs to retrieve all the rows for ordering, then it'll discard all but the 10 rows you want, the 10 with the highest rev_id. The ORDER ensures that the LIMIT is meaningless in terms of restricting the processing needed. Cabayi (talk) 14:15, 12 June 2021 (UTC)

If you restrict the query to the latest 1000 rows of change_tag (assuming ct_rev_id is sequential) rather than its full complement of 145 million rows it works...

SELECT   rv.rev_id, ct.ct_rev_id, cmt.comment_text, ctd.ctd_name
FROM     revision rv, comment cmt, change_tag_def ctd, change_tag ct
WHERE    rv.rev_id > (SELECT max(ct_rev_id) - 1000
                      FROM   change_tag )
AND      rv.rev_comment_id = cmt.comment_id
AND      rv.rev_id = ct.ct_rev_id
AND      ctd.ctd_id = ct.ct_tag_id
ORDER BY rev_id DESC
LIMIT 10

-- Cabayi (talk) 14:59, 12 June 2021 (UTC)

Cabayi, Ah, yeah, I've run into that before, thanks. See, I told you SQL isn't my strong suit :-) -- RoySmith (talk) 15:00, 12 June 2021 (UTC)
And I've got Quarry 55915 down to a single query :-) Oh happy days! Cabayi (talk) 15:28, 12 June 2021 (UTC)
Cabayi, It's really annoying that there's no namespace table in the database. If only there was some way of embedding the number:name mapping in enwiki_p.in a way you could parse out the information you needed with string functions... Quarry 55923. -- RoySmith (talk) 16:19, 12 June 2021 (UTC)
Even better, Quarry 55924 -- RoySmith (talk) 16:34, 12 June 2021 (UTC)
A not-clever, brute force version - Quarry 22971.
However, the {{ns:3}} → User talk magic word method has the merit of not being tied to any specific language wiki, and (plus point or minus point, depending on your need) has the wiki software do the work. Cabayi (talk) 20:36, 12 June 2021 (UTC)
Cabayi, See also Wikipedia:Village_pump_(technical)#Quarry_namespace_mapping. -- RoySmith (talk) 21:14, 12 June 2021 (UTC)
Not sure if it helps - but revision_userindex (and logging_userindex) are indexed tables - and will be likely to go much faster than using revision or logging. See: wikitech:Help:Toolforge/Database#Tables_for_revision_or_logging_queries_involving_user_names_and_IDs. I've also always found MusikAnimal's SQL Optimizer super helpful. !ɘM γɿɘυϘ⅃ϘƧ 23:03, 12 June 2021 (UTC)
June 16, 7pm: ONLINE WikiWednesday Salon NYC
Welcome to Wikimedia New York City!

You are invited to join the Wikimedia NYC community for our monthly "WikiWednesday" evening salon (7-8pm) and knowledge-sharing workshop. To join the meeting from your computer or smartphone, just visit this link. More information about how to connect is available on the meetup page.

We look forward to seeing local Wikimedians, but would also like to invite folks from the greater New York metropolitan area (and beyond!) who might not typically be able to join us in person!

If there's a project you'd like to share or a question you'd like answered, just let us know by adding it to the agenda or the talk page.

7:00pm - 8:00 pm online via Zoom (optional breakout rooms from 8:00-8:30)

(You can subscribe/unsubscribe from future notifications for NYC-area events by adding or removing your name from this list.)

--Wikimedia New York City Team 16:20, 14 June 2021 (UTC)

20:25, 14 June 2021 (UTC)

Moved to archive

Hello @RoySmith:! Maybe we can moved to archive of the previous sockpuppet investigation last week of Wikipedia:Sockpuppet investigations/Mark Maglasang..? Hope someone can moved it. Cornerstone2.0 (talk) 13:35, 15 June 2021 (UTC)

Cornerstone2.0, It's in the queue to get archived. Somebody will get to it when they have time. -- RoySmith (talk) 13:43, 15 June 2021 (UTC)

RoySmith, oh.. well okay then.. I understand that.. thanks for your response! :)) Cornerstone2.0 (talk) 13:47, 15 June 2021 (UTC)