Q&A for amateur radio enthusiasts
--Get the Tag IDs that you are interested in for the Tags table SELECT Id, TagName INTO #MyTags FROM Tags WHERE --TagName IN ('apache-spark', 'cassandra', 'mesos','akka', 'apache-kafka') --TagName IN ('apache-spark', 'spark-streaming', 'apache-kafka', 'flume', 'redis') --TagName IN ('jenkins','gitlab', 'bamboo', 'spinnaker', 'codeship', 'drone', 'vsts-build', 'vsts-release', 'travis-ci', 'docker-compose','packer', 'kubernetes', 'docker-swarm', 'mesos','etcd', 'consul', 'apache-zookeeper') --TagName IN ('github','terraform', 'ansible', 'chef', 'puppet', 'salt-stack') --TagName IN ('redis') --TagName IN ( 'mongodb') --TagName IN ('apache-spark', 'akka', 'mesos', 'apache-kafka') --TagName IN ('mysql') --TagName IN ('apache-kafka') --TagName IN ('spring', 'spring-boot') TagName = 'azure' select p.Id, p.Body from Posts p join PostTags pt on pt.PostId = p.Id join Tags t on t.Id = pt.TagId where TagId in ( SELECT Id FROM #MyTags ) order by p.LastActivityDate desc