Q&A for linguists, teachers, and students wanting to discuss the finer points of the Latin language
-- Top score question to given tags/keywords/min score -- -- without code examples -- DECLARE @Tag1 VARCHAR(30) = ##FirstTagOrKeyword:string##; SET @Tag1 = '%' + LTRIM(RTRIM(@Tag1)) + '%'; DECLARE @Tag2 VARCHAR(30) = ##SecondTagOrKeyword:string##; SET @Tag2 = '%' + LTRIM(RTRIM(@Tag2)) + '%'; -- Search Tags and Keywords in Header DECLARE @MinScore int = ##MinimumScore## -- min Score SELECT Id AS [Post Link], Score, Tags, ViewCount, AnswerCount, CommentCount, FavoriteCount, OwnerUserId, Title AS [Post Link] FROM Posts q WHERE PostTypeId = 1 AND ((q.Tags LIKE @Tag1 AND q.Tags LIKE @Tag2) OR (q.Title LIKE @Tag1 AND q.Title LIKE @Tag2) OR (q.Body LIKE @Tag1 AND q.Body LIKE @Tag2)) -- No code alllowed allowed, most Code Block starts with <pre><code> AND (q.Body NOT LIKE '%<pre><code>%') AND q.Score >= @MinScore ORDER BY Score DESC