0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for committed Christians, experts in Christianity and those interested in learning more

select c2.id, c2.text
from   Posts p2, Comments c2, PostTypes ptypes2
where  p2.id = c2.postid
and    p2.parentid in
      (
        select p1.id
        from Posts p1, PostTags ptags1, Tags t1, PostTypes ptypes1 
        where p1.posttypeid = ptypes1.id
          and ptypes1.id = 1
          and p1.id = ptags1.postid 
          and ptags1.tagid = t1.id 
          and t1.tagname = '##TagName##'
      )
  
and    p2.posttypeid = ptypes2.id
and    ptypes2.id = 2
and    c2.creationdate >= '##startdate##'
and    c2.creationdate <= '##enddate##'
order by p2.id

view current version

edited apr 30 13

created apr 23 13 Srinivas