replicating Xtools stuff in a normal query

SQL

SELECT COUNT(*) AS revisions, COUNT(case rev_minor_edit when 1 then 1 else null end) AS minor_edits, COUNT(DISTINCT rev_actor) AS editors, MIN(rev_timestamp) AS first_timestamp, MAX(rev_timestamp) AS last_timestamp, actor_name AS page_author, MIN(rev_id) AS first_rev, MAX(rev_id) AS last_rev
FROM revision
INNER JOIN actor
ON revision.rev_actor = actor.actor_id
INNER JOIN page
ON revision.rev_page = page.page_id
WHERE page_title = "Skon"
AND page_namespace = "0";
# Runs in like 13 seconds -- what da?
#SELECT COUNT(*) AS revisions, COUNT(DISTINCT rev_actor) AS editors, MIN(rev_timestamp) AS first_timestamp, rev_actor, rev_id
#FROM revision
#WHERE rev_page = 16601866;
# Runs in like 0.09 seconds.
SQL

Checking query status...
