Search for OR terms in a tag

0

Please login or register to vote for this query.

(click on this box to dismiss)

Korean Language

Q&A for linguists, teachers and students of the Korean language

select p.id
     , p.creationdate,
     p.viewcount
into #taggedPosts
from posts p
inner join posttags pt on pt.postid = p.id
inner join tags t on t.id = pt.tagid
where t.tagname = '##tag##'

create clustered index #ix_taggedposts_id on #taggedposts(id)
create index #ix_taggedposts_creationdate on #taggedposts(creationdate)
create index #ix_taggedposts_viewcount on #taggedposts(viewcount)


select top 200 p.id [Post Link]
from posts p
inner join #taggedPosts tp  on tp.id = p.id
where body like '%##term1##%' 
    or body like '%##term2##%'
    or body like '%##term3##%'
order by tp.viewcount desc

Enter Parameters

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