set nocount on declare @bobby table (qID int, tagCoun...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Ukrainian Language Meta

Q&A about the site for linguists, teachers and students of the Ukrainian language

-- This query finds your answers where there aren't many tags on the question
-- This way you can add missing tags so you get proper credit

-- Most questions should have at least two tags:
-- A language tag, or language-agnostic
-- At least one tag describing what the program is about and what the problem is
-- Maybe additional technologies/libraries/etc. used
-- So if a question has only one tag, it is most likely missing something!

-- Parameters:
-- UserID: User ID
-- ScoreMinimum: Minimum answer score (eg 1)
-- TagMaximum: Maximum tags on answer (eg 1)


set nocount on 
declare @bobby table (qID int, tagCount int) 


insert @bobby
select q.Id as miau, count(*) as wau from 
Posts q join Posts a on a.ParentId = q.Id
join PostTags pt on pt.PostId = q.Id
where a.OwnerUserId = ##UserID## and a.Score >= ##ScoreMinimum##
group by q.Id

set nocount off

select * from @bobby where tagCount <= ##TagMaximum##

Enter Parameters

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