Questions with best answer which has at least one link to site on microsoft domain

1

Please login or register to vote for this query.

(click on this box to dismiss)

Physics

Q&A for active researchers, academics and students of physics

select 
count(queries.Id)
  --queries.Id as Id,
  --queries.Title as QueryTitle,
  --queries.Body as QueryBody,
  --answers.Body as AnswerBody,
  --answers.Score as AnswerScore,
  --queries.Tags as Tags,
  --queries.Score as QueryScore,
  --queries.CreationDate as QueryCreationDate
from Posts queries
  join PostTags postTags on postTags.PostId = queries.Id
  join Tags tags on postTags.TagId = tags.Id
  join Posts answers on queries.AcceptedAnswerId = answers.Id
where 
  tags.TagName in ('c#', 'C#', '%net', '%NET', 'ASP%NET', 'asp%net')
  and queries.AcceptedAnswerId is not null
  and answers.Score > 0
  and queries.Score > 0
  and answers.Body like '%<a href="%microsoft.com%"%'
  --and queries.Id > 26235671
  --and (answers.Body like '%msdn.microsoft.com%'
  --    or answers.Body like '%docs.microsoft.com%'
  --    or answers.Body like '%technet.microsoft.com%')

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results