Questions for tag and term

0

Please login or register to vote for this query.

(click on this box to dismiss)

Japanese Language

Q&A for students, teachers, and linguists wanting to discuss the finer points of the Japanese language

declare @tag varchar(80) = '##Tag##'
declare @userid int = '##UserId##'

select id,
    tags from Posts p1
   where p1.Tags like '%' + @tag + '%'
   and p1.posttypeid = 1 
   except
   (select parentid,tags
       from posts p2
       where
       p2.posttypeid = 2
       and p2.owneruserid = 6309 and
       p2.Tags like '%' + @tag + '%'
    )

Enter Parameters

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