0

Please login or register to vote for this query.

(click on this box to dismiss)

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

fork query

edited apr 3 19

created feb 21 17 Joe.Binder