USE dewiki_p;

​

select user_name, comment_text from user,ipblocks,comment,user_groups

where ipb_user=user_id 

and ug_user=user_id and ug_group='editor'

and ipb_reason_id=comment_id 

and ipb_expiry='infinity' 

and ipb_timestamp>"20190101000000" 

and ipb_timestamp<"20200101000000" 

and comment_text not like '%unsch%'

and comment_text not like '%erstorben%';