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 archive.ar_rev_id revision_id, comment.comment_text, 'archive' source
        from archive join comment 
        on comment.comment_id=archive.ar_comment_id 
        join spambot_actors
        on archive.ar_actor=spambot_actors.actor_id)
SQL

Checking query status...
