replicating Xtools stuff in a normal query

SQL

SELECT COUNT(*) AS revisions, count(rev_minor_edit = 1) AS minor_edits, COUNT(DISTINCT rev_actor) AS editors, MIN(rev_timestamp) AS first_timestamp, actor_name AS page_author, rev_id
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...