Untitled query #64778

SQL

WITH spambot_actors AS (
  SELECT actor_id FROM actor
  WHERE actor_user IN (317952, 347426, 359172, 120231, 340170, 151756, 221499, 390258, 341491, 394389, 380219, 351517))

(SELECT REGEXP_REPLACE(REGEXP_REPLACE(log_params,'.*:',''),';}','') revision_id, comment_text, 'logging' source
FROM logging
JOIN spambot_actors
ON logging.log_actor=spambot_actors.actor_id
JOIN comment
ON logging.log_comment_id=comment.comment_id
WHERE log_type='create')

UNION

(SELECT REGEXP_REPLACE(REGEXP_REPLACE(log_params,'.*:',''),';}','') revision_id, comment_text, 'logging' source
FROM logging
JOIN spambot_actors
ON logging.log_actor=spambot_actors.actor_id
JOIN comment
ON logging.log_comment_id=comment.comment_id
WHERE log_type='create')
SQL

Checking query status...
