Replicas browser and optimizer
Find most recent additions of labels by certain users in Bengali
This query is marked as a draft
This query has been published
This list only considers changes from the past 30 days due to the $wgRcMaxAge setting. (Ripped from wdvd's code and modified a bit.) Thanks, Adam, for further modifications! Mahir256 is in this list for comparisons only--no effect on the rankings of others is to be assumed.
USE wikidatawiki_p; SELECT current_date; SELECT rc_user_text as Username, COUNT(*) as Number_of_labels_added FROM ( SELECT rc_user_text, rc_title, comment_text # count(comment_text) as added FROM recentchanges LEFT JOIN comment ON comment.comment_id = recentchanges.rc_comment_id WHERE comment_text REGEXP 'wbsetlabel-add...ml' AND rc_user_text IN ('Ranjithsiji', 'Mujeebcpy', 'Ambadyanands', 'KannanVM', 'Akbarali') AND rc_timestamp >= 20181105183000 AND rc_namespace = 0) as derivedtable GROUP BY rc_user_text ORDER BY Number_of_labels_added desc; #group by rc_user_text #order by added;
By running queries you agree to the
and you irrevocably agree to release your SQL under
All SQL code is licensed under
Checking query status...
Report a bug!
Wikimedia Cloud VPS
, written in