Untitled query #62311

SQL

/*SELECT * FROM comment
WHERE comment_text LIKE 'Added link to [trwiki]%'

LIMIT 100
*/
/*
SELECT
	rev.rev_parent_id,
    c.comment_text
FROM
	revision rev
    INNER JOIN comment c
    ON rev.rev_comment_id = c.comment_id
    
WHERE
	rev.rev_id BETWEEN 1570000000 AND 1580000000
    AND c.comment_text LIKE '/* wbsetsitelink-add:1|trwiki%'
   
*/

SELECT
    ra.actor_name,
	SUM(CASE WHEN r.rev_parent_id = 0 THEN 1 ELSE 0 END) AS page_new,
	SUM(CASE WHEN c.comment_text LIKE '/* wbsetsitelink-add:1|trwiki/%' THEN 1 ELSE 0 END) AS page_linked
FROM
	revision r
	INNER JOIN comment c
    ON r.rev_comment_id = c.comment_id
    INNER JOIN actor ra
    ON r.rev_actor = ra.actor_id
    INNER JOIN page p
    ON ru.rev_page = p.page_id
WHERE
	r.rev_id BETWEEN 0 AND 0
    AND p.page_namespace = 0
    AND p.page_is_redirect = 0

GROUP BY
	ra.actor_name
SQL

Checking query status...
