User talk:Cryptic

Request for help with a query

Last year, you helped me by creating this query. I tried to copy it and run it myself to get an updated report, but it appears that the database schema (or whatever the lingo is) has changed, making your query fail to run. I tried to use the documentation and T299417 and a bit of logical thinking to create an updated query, and I got a query that doesn't give error messages, but it never finishes running. I know very little about SQL, so parsing exactly what the query is doing and how to update it is beyond my skills. I have left my new query running for hours with no results. If you have a minute, could you please take a look at the two queries and try to figure out how to update your query from last year to account for the database table changes? Thanks. – Jonesey95 (talk) 14:12, 18 August 2023 (UTC)

JOIN linktarget ON lt_id = tl_target_id

Also, the "fork" button works more cleanly than cutting-and-pasting the query. —Cryptic 14:47, 18 August 2023 (UTC)

Thanks, that worked well. I wasn't sure about using "Fork"; I thought it might create a query in "your" space or modify your query in some way, which I wanted to avoid. I will use it in the future. – Jonesey95 (talk) 15:51, 18 August 2023 (UTC)

Re:Block

Why you left no block notice?

Your block came without any warning per WP:BEFOREBLOCK.

I am already trying to resolve this issue here. The block is unnecessary and you should overturn it. Aman Kumar Goel ^(Talk) 18:16, 18 August 2023 (UTC)