The subquery portion is extremely fast. I would expect that the outer portion would only run on the results of the subquery so it should be very fast. But it takes ages to run. The activity table is huge...
select * from (
select top 10 systemvars from activity order by activityid desc
) as blah
where SystemVars like '%MSIE 7.0%'