Bloqueios parciais de IP

SQL

use ptwiki_p;
select
  ipblocks.ipb_id as ID,
  ipblocks.ipb_address as IP,
  CASE
    ipblocks.ipb_anon_only
    WHEN true THEN 'Sim'
    ELSE 'Não'
  END as "Permite editar registrado",
  CASE
    ipblocks.ipb_create_account
    WHEN true THEN 'Não'
    ELSE 'Sim'
  END as "Permite criar conta",
  ipblocks.ipb_expiry as "Expira em",
  CASE
    partial.ir_type
    WHEN '2' THEN 'Domínio'
    ELSE 'Página'
  END as "Página ou domínio?",
  partial.ir_value as "Alvo de bloqueio"
from
  ipblocks
  left join (SELECT ir_ipb_id , GROUP_CONCAT(ir_value) FROM ipblocks_restrictions GROUP BY ir_ipb_id) as partial
  on ipblocks.ipb_id = partial.ir_ipb_id
where
  ipb_user = 0
  and ipb_sitewide = 0
SQL

Checking query status...
