0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for enthusiasts and scholars of mythology and folklore

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

fork query

edited mar 28 12

created mar 28 12 Ben