Untitled query #3801

SQL

SELECT 
user_name, count(*) 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) 
AND (user_name LIKE "%Bot%" OR user_name LIKE "%bot%")
GROUP BY 1 ORDER BY 2 DESC;

AخA
 
SELECT user_name, count(*) 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) AND (user_name LIKE "%Bot%" OR user_name LIKE "%bot%")GROUP BY 1 ORDER BY 2 DESC;

SQL

Checking query status...