Find earliest block for Skibidi accounts

Fork of Find earliest block for SPI ("optimised") by Cabayi

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

Supposedly optimised, but runs slower than 39019 at first run, faster subsequently.

SQL

USE enwiki_p;
SELECT min(ipb_timestamp),
       u2.user_name
FROM ipblocks, user u2 
WHERE ipb_user IN (SELECT user_id
                   FROM user
                   WHERE user_name LIKE "Skibidi%")
AND ipb_expiry = 'infinity'
AND ipb_user = u2.user_id

​x
 
USE enwiki_p;SELECT min(ipb_timestamp),       u2.user_nameFROM ipblocks, user u2 WHERE ipb_user IN (SELECT user_id                   FROM user                   WHERE user_name LIKE "Skibidi%")AND ipb_expiry = 'infinity'AND ipb_user = u2.user_id​

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...