Investigation for I861d84722f (T292545)

SQL

SELECT
SUM(comment_text RLIKE '\\[\\[\\S*[PQ][1-9]\\d*\\]\\]') AS benefiting, -- ENTITY_ID_SUMMARY_REGEXP
COUNT(*) AS total,
100 * SUM(comment_text RLIKE '\\[\\[\\S*[PQ][1-9]\\d*\\]\\]') / COUNT(*) AS percent -- unlike SPARQL, SQL doesn’t allow "100 * benefiting / total, here :(
FROM recentchanges
JOIN comment_recentchanges ON rc_comment_id = comment_id
WHERE rc_type IN (0, 1) -- RC_EDIT, RC_NEW
AND rc_namespace NOT IN (0, 120, 146) -- Items, Properties, Lexemes
AND '20241201000000' <= rc_timestamp
AND rc_timestamp < '20241208000000';

SQL

Checking query status...