secret list of questions that might be good to check out

0

Please login or register to vote for this query.

(click on this box to dismiss)

Music Fans Meta

Q&A for music historians, critics, and fans

-- you can fork my super secret list of questions to check out
-- but you owe me an upvote :)

select top 100  Id, Tags, Score, ViewCount, FavoriteCount, CreationDate, LastActivityDate, Title, Body, DeletionDate
from Posts a
left join PostTags b
on a.Id = b.PostId
WHERE TagId = '4452'
and Tags not like '%erve%'
and Tags not like '%ock%'
and Tags not like '%hin%'
and Tags not like '%ument%'
and Tags not like '%dow%'
and Tags not like '%ashb%'
and Tags not like '%it-t%'
and Tags not like '%rcp%'
and AnswerCount = 0
and Body not like 'duplicate'
and Score > 1
and ClosedDate is null
and CommunityOwnedDate is null
and DeletionDate is null
order by Score DESC

Enter Parameters

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