Query 1 - Quarry

SQL

use fawiki_p;
	
set @row_number = 0;
set @row_number_2 = 0;

select
  ipb.rownumber,
  ipb.ipb_address --,
--  lead.ipb_address
from
(
  select
    (@row_number:=@row_number + 1) as rownumber,
    i1.ipb_address
  from ipblocks i1
  where i1.ipb_by_actor = 1789 -- HujiBot
  order by i1.ipb_range_start 
) ipb
left join
(
  select
    (@row_number_2:=@row_number_2 + 1) as rownumber,
    i2.ipb_address
  from ipblocks i2
  where i2.ipb_by_actor = 1789 -- HujiBot
  order by i2.ipb_range_start 
) lead
  on lead.rownumber = ipb.rownumber + 1
SQL

Checking query status...
