Query Run
SET @ip_address = '78.31.67.68'; -- Enter the IP address you want to check... 1 year ago
SET @ip_address = '78.31.67.68'; -- Enter the IP address you want to check... 1 year ago
SET @ip_address = '78.31.67.68'; -- Enter the IP address you want to check... 1 year ago
SET @ip_address = '78.31.67.68'; -- Enter the IP address you want to check... 1 year ago
SET @ip_address = '78.31.67.68'; /*Enter the IP address you want to check... 2 years ago
SET @ip_address = '207.204.252.59'; /*Enter the IP address you want to check... 2 years ago
SET @ip_address = '207.204.252.59'; /*Enter the IP address you want to check... 2 years ago
SET @ip_address = '207.204.252.59'; /*Enter the IP address you want to check... 2 years ago
SET @ip_address = '207.204.252.59'; /*Enter the IP address you want to check... 2 years ago
SET @ip_address = '207.204.252.59'; /*Enter the IP address you want to check... 2 years ago
SET @ip_address = '207.204.252.59'; /*Enter the IP address you want to check... 2 years ago
SET @ip_address = '207.204.252.59'; /*Enter the IP address you want to check... 2 years ago
SET @ip_address = '207.204.252.59'; /*Enter the IP address you want to check... 2 years ago
SET @ip_address = '207.204.252.59'; /*Enter the IP address you want to check... 2 years ago
SET @ip_address = '207.204.252.59'; /*Enter the IP address you want to check... 2 years ago
SET @ip_address = '207.204.252.59'; /*Enter the IP address you want to check... 2 years ago
SET @ip_address = '207.204.252.59'; /*Enter the IP address you want to check... 2 years ago
SET @ip_address = '207.204.252.59'; /*Enter the IP address you want to check... 2 years ago
SET @ip_address = '207.204.252.59'; /*Enter the IP address you want to check... 2 years ago
SET @ip_address = '207.204.252.59'; /*Enter the IP address you want to check... 2 years ago
SET @ip_address = '207.204.252.59'; /*Enter the IP address you want to check... 2 years ago
SET @ip_address = '207.204.252.59'; /*Enter the IP address you want to check... 2 years ago
SET @ip_address = '161.45.254.242'; /*Enter the IP address you want to check... 2 years ago
SET @ip_address = '161.45.254.242'; /*Enter the IP address you want to check... 2 years ago
SET @ip_address = '161.45.254.242'; /*Enter the IP address you want to check... 2 years ago
SET @ip_address = '1.136.109.244'; /*Enter the IP address you want to check... 2 years ago
SET @ip_address = '1.136.109.244'; /*Enter the IP address you want to check... 2 years ago
SET @ip_address = '1.136.109.244'; select case when count(*) > 0 then 'is... 2 years ago
SET @ip_address = '161.45.254.242'; select case when count(*) > 0 then 'is... 2 years ago
SET @var = 'Testing'; select case when count(*) > 0 then @var else 'not... 2 years ago
SET @var = 0; select case when count(*) > 0 then @var else 'not blocked'... 2 years ago
select case when count(*) > 0 then 'is blocked' else 'not blocked' end from... 2 years ago
DECLARE @TestVariable AS VARCHAR(100) SET @TestVariable = 'One Planet One... 2 years ago
select case when count(*) > 0 then true else false end from ipblocks where... 2 years ago
select * from ipblocks where ipb_user = 0 and ipb_address =... 2 years ago
select * from ipblocks where ipb_user = 0 and... 2 years ago
select * from ipblocks where ipb_user = 0 and ipb_address =... 2 years ago
select * from ipblocks where ipb_user = 0 and ipb_address =... 2 years ago
select *, HEX(INET6_ATON(ipb_address)) from ipblocks where ipb_user = 0 and... 2 years ago
select * from ipblocks where ipb_user = 0 and ipb_address =... 2 years ago
select * from ipblocks where ipb_user = 0 and ipb_address =... 2 years ago
select HEX(INET6_ATON('161.45.0.0')); 2 years ago
select HEX(INET6_ATON('161.45.0.0/16')); 2 years ago
select * from ipblocks where ipb_user = 0 and ipb_address =... 2 years ago
select * from ipblocks where ipb_user = 0 and ipb_address = '161.45.254.242'; 2 years ago
select * from ipblocks where ipb_user = 0 and ipb_address = '1.136.109.244'; 2 years ago
select * from ipblocks where ipb_user = 0 and ipb_address = '161.45.254.242'; 2 years ago
select case when count(*) = 1 then true else false end from ipblocks where... 2 years ago
select case when count(*) = 1 then true else false end from ipblocks where... 2 years ago
select case when count(*) = 1 then true else false end from ipblocks where... 2 years ago
select case when count(*) = 1 then true else false end from ipblocks where... 2 years ago
select case when count(*) = 1 then true else false end from ipblocks where... 2 years ago
select case when count(*) = 1 then true else false end from ipblocks where... 2 years ago
select case when count(*) = 1 then 'true' else 'false' end from... 2 years ago
select case when count(*) = 1 then true else false end from ipblocks where... 2 years ago
select case when count(*) = 1 then true else false end from ipblocks where... 2 years ago
select case when count(*) = 1 then true else false end from ipblocks where... 2 years ago
select case when count(*) = 1 then true else false end from ipblocks where... 2 years ago
select case when count(*) = 1 then true else false end from ipblocks where... 2 years ago
select case when count(*) = 1 then true else false end from ipblocks where... 2 years ago
select case when count(*) = 1 then true else false end from ipblocks where... 2 years ago
select case when count(*) = 1 then true else false end from ipblocks where... 2 years ago
select case when ipb_timestamp is null then false else true end from... 2 years ago
select case when ipb_timestamp is null or ipb_timestamp = 0 then false else... 2 years ago
select case when ipb_timestamp is null then false else true end from... 2 years ago
select case when ipb_timestamp is null then false else true end from... 2 years ago
select * from ipblocks where ipb_user = 0 and ipb_address = '203.94.130.78'; 2 years ago
select * from ipblocks where ipb_user = 0 and ipb_address = '121.208.212.82'; 2 years ago
select case when 'No data available in table' then false else true end from... 2 years ago
select case when null then false else true end from ipblocks where ipb_user... 2 years ago
select * from ipblocks where ipb_user = 0 and ipb_address = '121.208.212.82'; 2 years ago