rudy writes: > dean, did you put an index on replies.datemod? i think that would > really help this subquery I didn't before. I've just added it now. I have an index on replies.contentid which seemed to speed up the original query. Dean