USE zhwiki_p;

SELECT log_user_text, log_timestamp, log_namespace, log_title, log_comment, log_action, log_type FROM logging

LEFT JOIN user_groups ON ug_user = log_user AND ug_group = 'sysop' AND log_action = 'delete' AND log_type = 'delete'

WHERE ug_group IS NULL

LIMIT 50