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 posts.Id as answer_id, PostTypeId as post_type,
       posts.CreationDate as answer_creation_date, Body as answer_body, ParentId as question_id,
       OwnerUserId as user_id ,
       Users.DisplayName as user_name , Users.CreationDate as user_creation_date ,
       Users.Reputation ,Users.views as user_num_views ,Users.UpVotes as user_up_votes ,
       Users.DownVotes as user_down_votes, WebsiteUrl as user_url , Location as user_location , AboutMe as user_about,  score as answer_score
      from posts LEFT JOIN Users ON posts.OwnerUserId = Users.Id
      where (PostTypeId = 2 and ParentId IN(
      select Id from Posts
      where CreationDate >='##date1##' and CreationDate < '##date2##' and PostTypeId=1
      and tags LIKE '%<##TagName##>%' ))

fork query

edited aug 21 19

created aug 9 19 anonymous