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_val as "Alvo de bloqueio"
from
  ipblocks
  left join (
    SELECT
      ir_ipb_id,
      ir_type,
      GROUP_CONCAT(ir_value) as ir_val
    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...
