Total and reverted revisions of pages with most revisions

SQL

SELECT
 page_title,
 COUNT(*) AS total,
 COUNT(DISTINCT rev_sha1) AS unreverted,
 COUNT(*) - COUNT(DISTINCT rev_sha1) AS reverted,
 100 * (1 - COUNT(DISTINCT rev_sha1) / COUNT(*)) AS percentReverted
FROM revision
JOIN page ON rev_page = page_id
WHERE page_namespace = 0
AND page_title IN (
  'List_of_WWE_personnel',
  'George_W._Bush',
  'United_States',
  'Donald_Trump',
  'Wikipedia',
  'List_of_current_UFC_fighters',
  'Michael_Jackson',
  'Jesus',
  'List_of_programs_broadcast_by_ABS-CBN',
  'ATP_Tour_records'
)
GROUP BY page_title
ORDER BY COUNT(*) DESC;

SQL

Checking query status...