SELECT DATE_FORMAT(log_timestamp, '%Y-%m-%d %H:%i:%s') AS timestamp,

       CONCAT(CASE log_namespace

              WHEN 100 THEN 'Portal:'

              WHEN 101 THEN 'Portal talk:'

              END, log_title) AS pagename,

       actor_name,

       comment_text

FROM logging_logindex

JOIN comment_logging ON comment_id = log_comment_id

JOIN actor_logging ON actor_id = log_actor

WHERE log_type = 'delete' AND log_action = 'delete'

  AND log_namespace IN (100, 101)

  AND comment_text RLIKE '\\bP[12]\\b'

ORDER BY log_id DESC;