Query explain extended select e.id as entryID, e.title, c.id, c.entryidfk, c.name, c.comment, date_add(c.posted, interval -1 hour) as posted from tblblogcomments c inner join tblblogentries e on c.entryidfk = e.id where blog = 'Default' order by c.posted desc limit 5, Mon Dec 21 12:48:36 2009

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	e	ref	PRIMARY,blog	blog	152	const	1897	100.00	Using where; Using temporary; Using filesort
1	SIMPLE	c	ref	entryidfk	entryidfk	107	myblog_dbo.e.id	5	100.00	(null)