Possible duplicate tags based on '-'.

1

Please login or register to vote for this query.

(click on this box to dismiss)

Amateur Radio

Q&A for amateur radio enthusiasts

select t1.*, t2.*
  from tags t1
  join tags t2
    on t1.tagname = replace(t2.tagname,'-','')
  left outer join tagsynonyms ts
    on t1.tagname = targettagname
   and t2.tagname = sourcetagname
 where ts.id is null
   and t1.tagname <> t2.tagname
 order by t1.count + t2.count desc
        , t2.count desc
        , t1.count desc

Enter Parameters

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