select as [Comment Link],max( as [Post Link],...


Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow

Q&A for professional and enthusiast programmers

select as [Comment Link],max( as [Post Link],max(pv.viewcount) as viewcount from
posts q
join posts p
on ( = p.parentid or = as pv
(select id, postid from comments where (text like '%jefromi%' or text like '%Jefromi%')) as jc
on = jc.postid
group by
order by viewcount desc

Enter Parameters

Switch sites:
loading Hold tight while we fetch your results