Hashtags from page table

SQL

SELECT  null as rc_id,
        rev.rev_timestamp as rc_timestamp,
        rev.rev_user AS rc_user,
        rev.rev_user_text AS rc_user_text,
        page.page_namespace AS rc_namespace,
        page.page_title AS rc_title,
        rev.rev_comment AS rc_comment,
        rev.rev_minor_edit AS rc_minor,
        null AS rc_bot,
        CASE WHEN rev.rev_parent_id = 0
        THEN 1
        ELSE 0
        END AS rc_new,
        rev.rev_page AS rc_cur_id,
        rev.rev_id AS rc_this_oldid,
        rev.rev_parent_id AS rc_last_oldid,
        null AS rc_type,
        null AS rc_source,
        null AS rc_patrolled,
        null AS rc_ip,
        prev_rev.rev_len AS rc_old_len,
        rev.rev_len AS rc_new_len,
        rev.rev_deleted AS rc_deleted,
        null AS rc_logid,
        null AS rc_log_type,
        null AS rc_log_action,
        null AS rc_params
FROM svwiki_p.revision AS rev
JOIN svwiki_p.page
ON page.page_id = rev.rev_page
JOIN svwiki_p.revision AS prev_rev
ON prev_rev.rev_id = rev.rev_parent_id
WHERE rev.rev_timestamp > DATE_SUB(UTC_TIMESTAMP(), INTERVAL 180 DAY)
AND rev.rev_comment REGEXP '(^|[[:blank:]]|\\.|\\!|\\/)[#＃][[:alnum:]]+[[:>:]]'
ORDER BY rev.rev_timestamp DESC
SQL

Checking query status...
