Tag synonyms where the tags differ just by added s (pluralization)

1

Please login or register to vote for this query.

(click on this box to dismiss)

Poker Meta

Q&A about the site for serious players and enthusiasts of poker

SELECT
ts.SourceTagName, ts.TargetTagName,
  'site://tags/' + ts.TargetTagName+ '/synonyms' AS [Synonyms link]
FROM TagSynonyms ts
WHERE 
  (ts.SourceTagName=ts.TargetTagName+'s') OR
  (ts.TargetTagName=ts.SourceTagName+'s')

Enter Parameters

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