SELECT log_type,log_action,log_user,log_namespace,log_title,log_params,log_comment,log_id,log_deleted,log_timestamp,user_name,user_editcount,ts_tags FROM `gdnlogging` FORCE INDEX (PRIMARY) INNER JOIN `grondin`.`gdnuser` ON ((user_id=log_user)) INNER JOIN `gdnlog_search` FORCE INDEX (ls_field_val) ON ((ls_log_id=log_id)) LEFT JOIN `gdntag_summary` ON ((ts_log_id=log_id)) WHERE log_type = 'delete' AND log_action = 'event' AND ls_field = 'log_id' AND ls_value = '7' AND log_namespace = '-1' AND log_title = 'Journal/block' AND (user_id = log_user) GROUP BY ls_log_id ORDER BY log_timestamp DESC LIMIT 26