USE zhwiki_p;

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

LEFT JOIN user_groups ON ug_user = log_user AND ug_group = 'sysop'

WHERE ug_group IS NULL AND log_action = 'delete' AND log_type = 'delete'

ORDER BY log_timestamp DESC

LIMIT 50