Query Run
use dewiki_p; select ipblocks.ipb_reason_id,comment.comment_text, count(*) ... 4 years ago
use dewiki_p; select ipblocks.ipb_reason_id,comment.comment_text, count(*) ... 4 years ago
use dewiki_p; select ipblocks.ipb_reason_id,comment.comment_text, count(*) ... 4 years ago
use dewiki_p; select 'ipblocks.ipb_reason_id','comment.comment_text',... 4 years ago
use dewiki_p; select 'ipblocks.ipb_reason_id','comment.comment_text',... 4 years ago
use dewiki_p; select 'ipblocks.ipb_reason_id','comment.comment_text',... 4 years ago
use dewiki_p; select 'ipblocks.ipb_reason_id',`comment.comment_text`,... 4 years ago
use dewiki_p; desc ipblocks; 4 years ago
use dewiki_p; select `ipblocks.ipb_reason_id`,`comment.comment_text`,... 4 years ago
use dewiki_p; select ipblocks.ipb_reason_id,comment.comment_text, count(*) ... 4 years ago
use dewiki_p; select ipb_reason_id, count(*) from ipblocks GROUP... 5 years ago
use dewiki_p; select ipb_reason, count(*) from ipblocks GROUP... 6 years ago
use dewiki_p; select distinct(ipb_reason) from ipblocks; 6 years ago
use dewiki_p; select ipb_reason, count(*) from ipblocks GROUP... 6 years ago
use dewiki_p; select count(*) from ipblocks where LOWER(ipb_reason) rlike... 6 years ago
use dewiki_p; select count(*) from ipblocks where (ipb_reason) rlike... 6 years ago
use dewiki_p; select count(*) from ipblocks where (ipb_reason) rlike "GLGerman"; 6 years ago
use dewiki_p; select count(*) from ipblocks where (ipb_reason) rlike "glgerman"; 6 years ago
use dewiki_p; select count(*) from ipblocks where LOWER(ipb_reason) rlike... 6 years ago
use dewiki_p; select count(*) from ipblocks where upper(ipb_reason) rlike... 6 years ago
use dewiki_p; select count(*) from ipblocks where lower(ipb_reason) rlike... 6 years ago
use dewiki_p; select count(*) from ipblocks where ipb_reason irlike "glgerman"; 6 years ago
use dewiki_p; select count(*) from ipblocks where ipb_reason rlike "GLGerman"; 6 years ago
use dewiki_p; select distinct(ipb_reason) from ipblocks where ipb_reason... 6 years ago
use dewiki_p; select distinct(ipb_reason) from ipblocks where ipb_reason... 6 years ago
select distinct(ipb_reason) from ipblocks; 6 years ago
select ipb_address from ipblocks where ipb_reason rlike ".*glgerman.*"; 6 years ago
select ipb_address from ipblocks where ipb_reason rlike "glgerman"; 6 years ago
select ipb_address from ipblocks where "ipb_reason" rlike "glgerman"; 6 years ago
select ipb_address from ipblocks where "ipb_reason" irlike "glgerman"; 6 years ago
select ipb_address from ipblocks where "ipb_reason" rlike "Über diesen Zugang".*; 6 years ago
select ipb_address from ipblocks where "ipb_reason" rlike "Über diesen Zugang.*"; 6 years ago
select ipb_address from ipblocks where "ipb_reason" rlike "Über diesen Zugang"; 6 years ago
desc ipblocks; 6 years ago
show tables; 6 years ago
use dewiki_p; 6 years ago
user dewiki_p; 6 years ago
show tables; 6 years ago