Replicas browser and optimizer
This query is marked as a draft
This query has been published
use wikidatawiki_p; SELECT #rev_comment, rev_user_text, DATE(CONCAT(YEAR(rev_timestamp),"-",MONTH(rev_timestamp),"-",DAY(rev_timestamp))) AS day ,COUNT(*) FROM revision_userindex WHERE rev_comment like "%New item from%" and rev_user_text = 'Mr.Ibrahembot' #and rev_comment like "%جديد%" #WHERE rev_user_text like "%bot" #GROUP BY rev_comment #ORDER BY COUNT(*) DESC GROUP BY day ORDER BY day DESC;
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