Find all posts matching list of tags

0

Please login or register to vote for this query.

(click on this box to dismiss)

Chess

Q&A for serious players and enthusiasts of chess

--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 in ('c++14', 'c++17')
  
SELECT TOP 10
  p.ID AS [Post Link],
  p.Tags AS [Tags]
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.Score DESC

Enter Parameters

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