Is there a way to see your full Comments history?

0

Please login or register to vote for this query.

(click on this box to dismiss)

https://meta.stackexchange.com/questions/171364

Signal Processing Meta

Q&A about the site for practitioners of the art and science of signal, image and video processing

select p.id as [Post Link]
     , p.lastactivitydate
     , p.owneruserid as [User Link]
     , case p.posttypeid 
       when 1 then 'Q'
       when 2 then 'A'
       else '?'
       end [Q or A] 
     , c.id as [Comment Link]
     , c.creationdate
from posts p
inner join comments c on c.postid = p.id
where c.userid = ##userid?344211##
and c.creationdate between ##startdate:string?2011-03-01## 
                       and ##enddate:string?2011-04-01## 
and p.posttypeid in (case 
                     when ##qa:string?q## = 'q' or ##qa:string?q## = 'qa'
                     then 1 
                     else null 
                     end, 
                     case 
                     when ##qa:string?q## = 'a' or ##qa:string?q## = 'qa'
                     then 2 
                     else null 
                     end)

Enter Parameters

Options:
Switch to main site
loading Hold tight while we fetch your results