Find earliest block for SPI ("optimised")

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)
FROM ipblocks 
WHERE ipb_user IN (SELECT user_id
                   FROM user
                   WHERE user_name IN ('Peter.hantz', 'Physisc42', 'Cakeseed', 'Yksi11'))
AND ipb_expiry = 'infinity'

​x
 
USE enwiki_p;SELECT min(ipb_timestamp)FROM ipblocks WHERE ipb_user IN (SELECT user_id                   FROM user                   WHERE user_name IN ('Peter.hantz', 'Physisc42', 'Cakeseed', 'Yksi11'))AND ipb_expiry = 'infinity'​

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