Answers FL

1

Please login or register to vote for this query.

(click on this box to dismiss)

Amateur Radio

Q&A for amateur radio enthusiasts

Select Distinct a.Id, a.CreationDate, a.Score, u.DisplayName, 
   Case p.AcceptedAnswerId-a.Id When 0 Then 'Accepted' Else '' End as Accepted,
   p.Title, p.Tags, 
   p.AnswerCount,
   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 Users u On a.OwnerUserId = u.Id
   Inner Join PostTags pt on p.Id = Pt.PostId
   Inner Join Tags t on pt.TagId = t.Id
   --Left Join Votes v on a.Id = v.PostId and v.VoteTypeId = 2 
   --Left Join Users vu on v.UserId = vu.Id
Where a.OwnerUserId in (
  --EMEA--
  5140781,  --Andriy
  6356968,  --Thomas
  1600436,  --Javier
  8625914,  --Vin
  9199185,  --Roberto
  --AMER--
  6753857,  --Rob
  4481169,  --Iavor
  9300778,  --Cole
  9329068,  --Omar
  7903948,  --Matthew
  9446439,  --Nichole
  6762789,  --Preston
  --APAC--
  8573097,  --Rafon
  8566739,  --Henri
  8579073,  --James
  9455567,  --Xer
  9460075,  --Micah
  9460321,  --Mervin
  9461114,  --Tom
  5993323,  --Ricky
  9652169,  --Nelson
  4799525   --Antonio
  )
  And a.PostTypeId = 2  -- Answer
  And p.PostTypeId = 1  -- Question
  And t.TagName in ('google-maps-api-3','google-maps', 'google-maps-api',
  'google-places-api', 'google-static-maps', 'google-street-view',
  'google-geocoding-api', 'google-direction', 'google-distancematrix-api',
  'google-maps-android-api-2', 'google-maps-sdk-ios', 'google-maps-embed',
  'google-maps-mobile', 'google-geolocation', 'google-maps-timezone',
  'google-elevation-api', 'google-roads-api')
  And a.CreationDate >= DATEADD(Month, -1, Getdate())  -- Last month answers 
Order by u.DisplayName, a.Score desc, 
Case p.AcceptedAnswerId-a.Id When 0 Then 'Accepted' Else '' End desc,
a.CreationDate desc

Enter Parameters

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