DECLARE @api_tag nvarchar(25) = ##api:string?jquery## DEC...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Ukrainian Language Meta

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

DECLARE @api_tag nvarchar(25) = ##api:string?jquery##
DECLARE @keyword nvarchar(25) = ##keyword:string?hate##

SELECT top 50
  p.id as [Post Link], p.title, p.body, p.Score 
FROM Tags t
JOIN PostTags pt ON pt.TagId = t.Id 
JOIN Posts as p ON p.Id = pt.PostId
WHERE p.Body like '% ' + @keyword + '%' and TagName = @api_tag
ORDER BY p.Score DESC

Enter Parameters

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