select as [Post Link], (case when p.title is not nul...


Please login or register to vote for this query.

(click on this box to dismiss)

Mi Yodeya

Q&A for those who base their lives on Jewish law and tradition and anyone interested in learning more

select as [Post Link],
  (case when p.title is not null then p.title else pq.title end) as title, 
  (case when p.viewcount is not null then p.viewcount else pq.viewcount end) as viewcount
from posts p
left outer join posts pq on = p.parentid
where p.body like ''
order by viewcount desc

Enter Parameters

Switch to meta site
loading Hold tight while we fetch your results