When did Jclemens register?

This query is marked as a draft This query has been published by Cryptic.

(More precisely, the usernames and user_registration fields of users with user_id's surrounding Jclemens' user_id.)

Answer: likely 27 February 2005, probably between 2:47:41 and 2:53:48 UTC, but.

Why some users have NULL user_registration, and why some have user_registration's out of sequence with their user_id's, is mysterious.  I had previously guessed both are because user_registration wasn't recorded at the time, and was backfilled at some point with the timestamp of the user's first edit - that's consistent with a couple spot checks in these results, i.e. the others with NULL registration have no edits - but then, how come Jclemens' user_registration never got backfilled?  (Maybe his first edit was oversighted?  Maybe the backfilling happened between his registration and eventual first edit on 24 August 2006?)

For [[Wikipedia:Deletion review/Log/2024 May 31]].

SQL

SET @jcid = (SELECT user_id FROM user WHERE user_name = 'Jclemens');

SELECT user_id, user_name, CAST(user_registration AS DATETIME)
FROM user
WHERE user_id BETWEEN @jcid - 49 AND @jcid + 49
ORDER BY user_id ASC;

​x
 
SET @jcid = (SELECT user_id FROM user WHERE user_name = 'Jclemens');​SELECT user_id, user_name, CAST(user_registration AS DATETIME)FROM userWHERE user_id BETWEEN @jcid - 49 AND @jcid + 49ORDER BY user_id ASC;

By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.

Submit Query Stop Query

All SQL code is licensed under CC0 License.

SQL

Checking query status...