Unused pairs of tags

0

Please login or register to vote for this query.

(click on this box to dismiss)

Signal Processing Meta

Q&A about the site for practitioners of the art and science of signal, image and video processing

SELECT t1.tagName as tag1, t2.tagName as tag2
FROM tags t1, tags t2
WHERE t1.id < t2.id

AND t1.id IN (36,442,22,117,236,164,199,115,112,166,149,57,233,67,69,209,261,126,105,16,487,158,97,193,232,475,114,194,259,319)
AND t2.id IN (36,442,22,117,236,164,199,115,112,166,149,57,233,67,69,209,261,126,105,16,487,158,97,193,232,475,114,194,259,319)

AND NOT EXISTS (
  SELECT p.id 
  FROM posts p
  WHERE p.PostTypeId=1 AND 
   ( p.tags LIKE CONCAT('%<',t1.tagName,'>%<',t2.tagName,'>%') OR p.tags LIKE concat ('%<',t2.tagName,'>%<',t1.tagName,'>%') )
)

ORDER BY tag1, tag2;;

Enter Parameters

Options:
Switch to main site
loading Hold tight while we fetch your results