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,

MIN(rev_id) AS first_rev, MAX(rev_timestamp) AS last_timestamp,

MAX(rev_id) AS last_rev, actor_name AS page_author

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.

SELECT page_id FROM page WHERE page_title = "Skon" AND page_namespace = "0";

SELECT COUNT(*) FROM revision WHERE rev_page = 16601866;