Wikipedia talk:Database reports/Range blocks/Configuration

To help centralise discussions and keep related topics together, please start new conversations at Wikipedia talk:Database reports.

ipb_reason isn't really used anymore. You need to join ipb_reason_id to comment. E.g.:

/* rangeblocks.py SLOW_OK */ 
SELECT ipb_address, 
       ipb_by_text, 
       ipb_timestamp, 
       ipb_expiry, 
       comment_text 
FROM   ipblocks 
       JOIN comment 
         ON ipb_reason_id = comment_id 
WHERE  ipb_address LIKE '%/%';

Hope it helps. SQL ^{Query me!} 22:02, 24 February 2019 (UTC)[reply]

Erm, MZMcBride - meant to ping! SQL ^{Query me!} 22:03, 24 February 2019 (UTC)[reply]