Q&A for active researchers, academics and students of physics
--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
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%')