Untitled query #3802

SQL

SELECT 
SUBSTRING(rev_timestamp,1,6) AS my, AVG(user_name LIKE "%Bot%" OR user_name LIKE "%bot%") as naive_bot_pct, count(*) as revs from revision
INNER JOIN user
ON rev_user = user_id
WHERE rev_page IN (1952670, 5149102, 3741656, 5137507, 33585400, 438960, 12936136, 21090364, 2356700, 6768170, 7567233, 2530810, 692849, 8634849, 24705288, 303754, 1704434, 31934316, 14727094, 10412416, 35525747, 41199377, 24101289, 12106325, 14642781, 564696, 1348054, 13207787, 4520402, 7726456, 16002516, 374797, 41687434, 15612792, 4200230, 4944928, 31914036, 473349, 66158, 392393, 375972, 11424955, 1052128, 5634192, 46576416, 431540, 6163896, 25415430, 352651, 18438651, 26803395, 18053857, 34475351, 6680271, 895730, 1108567, 11022716, 26740553, 1015853, 986140, 3706897, 3252662, 34595875, 34353211, 3603326, 15130507, 2735348, 8531586) 
GROUP BY 1;

AخA
 
SELECT SUBSTRING(rev_timestamp,1,6) AS my, AVG(user_name LIKE "%Bot%" OR user_name LIKE "%bot%") as naive_bot_pct, count(*) as revs from revisionINNER JOIN userON rev_user = user_idWHERE rev_page IN (1952670, 5149102, 3741656, 5137507, 33585400, 438960, 12936136, 21090364, 2356700, 6768170, 7567233, 2530810, 692849, 8634849, 24705288, 303754, 1704434, 31934316, 14727094, 10412416, 35525747, 41199377, 24101289, 12106325, 14642781, 564696, 1348054, 13207787, 4520402, 7726456, 16002516, 374797, 41687434, 15612792, 4200230, 4944928, 31914036, 473349, 66158, 392393, 375972, 11424955, 1052128, 5634192, 46576416, 431540, 6163896, 25415430, 352651, 18438651, 26803395, 18053857, 34475351, 6680271, 895730, 1108567, 11022716, 26740553, 1015853, 986140, 3706897, 3252662, 34595875, 34353211, 3603326, 15130507, 2735348, 8531586) GROUP BY 1;

SQL

Checking query status...