SELECT actor_name, CAST(log_timestamp AS DATETIME) AS 'time', log_title, comment_text

FROM logging

JOIN actor_logging ON actor_id = log_actor

JOIN comment_logging ON comment_id = log_comment_id

WHERE log_action = 'delete'

  AND log_type = 'delete'

  AND log_timestamp >= '2024'

  AND log_namespace = 14

  AND comment_text LIKE '%C1%'

  AND comment_text NOT LIKE '%Wikipedia:Categories\_for\_discussion/Log/%'

ORDER BY log_timestamp DESC;