Untitled query #88856

SQL

-- select * from logging
-- /*inner join user on user_name = REPLACE(log_title, '_', ' ')*/
-- left join block_target on /*bt_user = user_id*/ bt_user_text = replace(log_title, '_', ' ')
-- where log_type = 'block'
-- and log_action regexp '^(re)?block$'
-- order by log_timestamp desc
-- limit 5;

select * from block_target
right join (
  select * from logging
  where log_type = 'block'
  and log_action regexp '^(re)?block$'
  order  by log_timestamp desc
  limit 500
) on bt_user_text = replace(log_title, '_', ' ');
SQL

Checking query status...
