Get all Questions by tag

0

Please login or register to vote for this query.

(click on this box to dismiss)

Emacs

Q&A for those using, extending or developing Emacs

Select Distinct 
  a.Id, 
  a.CreationDate, 
  t.TagName,
  Case p.AcceptedAnswerId-a.Id 
    When 0 Then 'Accepted' 
    Else '' 
    End as Accepted,
   p.Title,p.Body, p.Tags, 
   CONCAT('http://stackoverflow.com/questions/', p.Id, '#answer-', a.Id) as Link
   --,vu.DisplayName
From Posts a 
   Inner Join Posts p On a.ParentId = p.Id 
   Inner Join PostTags pt on p.Id = Pt.PostId
   Inner Join Tags t on pt.TagId = t.Id
WHERE a.CreationDate > Convert(datetime, '2021-01-01' )
  AND p.PostTypeId = 1
  And (t.TagName LIKE 'google-maps%')
  --And a.CreationDate >= DATEADD(Day, -14, Getdate())  -- Last two weeks answers 
Order by a.CreationDate desc

Enter Parameters

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