Q&A for those who base their lives on Jewish law and tradition and anyone interested in learning more
p.id 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 pq.id = p.parentid
where p.body like '%chabadlibrary.org%search=%'
order by viewcount desc