0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for engineers, producers, editors, and enthusiasts spanning the fields of video, and media creation

select p.body as body
, case when p.posttypeid = 1 then 'Question' else 'Answer' end [Q/A]
, p.Owneruserid
, p.ownerdisplayname
, p.viewcount
, p.commentcount
, p.creationdate
, p.tags
, p.answercount
from posts p
inner join posts q
on q.id = coalesce(p.parentid, p.id) -- only questions have tags
inner join posttags pt on pt.postid = q.id
inner join tags t on t.id = pt.tagid
cross join string_split(##tags:string?Tencent,Cloud##, ',') tv
where t.tagname = tv.value
AND p.creationdate BETWEEN ##StartDate:string?2020-01-01## AND ##EndDate:string?2020-12-01##

view current version

edited dec 1

created dec 1 anonymous