0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for people seeking specific software recommendations

WITH 
distinct_source_tag_name AS
(
SELECT DISTINCT SourceTagName 
FROM TagSynonyms 
WHERE lower(SourceTagName) LIKE '%css%'
),
distinct_target_tag_name AS
(
SELECT DISTINCT TargetTagName 
FROM TagSynonyms 
WHERE lower(TargetTagName) LIKE '%css%'
),
css_tags AS
(
  SELECT 
  t.TagName, 
  t.Id, 
  ts1.SourceTagName as source_tag_name_if_joined_by_it,
  ts2.TargetTagName as target_tag_name_if_joined_by_it
  FROM Tags t
  LEFT JOIN distinct_source_tag_name ts1
  ON t.TagName = ts1.SourceTagName
  LEFT JOIN distinct_target_tag_name ts2
  ON t.TagName = ts2.TargetTagName
  WHERE lower(TagName) LIKE '%css%'
)
SELECT COUNT(*) 
FROM PostTags
WHERE PostTags.TagId IN (SELECT Id FROM css_tags)

view current version

edited dec 6

created dec 6 user28646684