1

Please login or register to vote for this query.

(click on this box to dismiss)

Search for a string that occurs either in title, tags or body Posts need a minimum score of 7 and should be without code in body

Q&A for users of Linux, FreeBSD and other Un*x-like operating systems

-- Top score question to given tags/keywords/minimum 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)) + '%';
DECLARE @MinScore int     = ##MinimumScore##

SELECT     Id AS [Post Link], Score, Tags, Body
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))
AND        (q.Body NOT LIKE '%pre%')
AND        (q.Body NOT LIKE '%<ol%')
AND        (q.Body NOT LIKE '%<ul%')

AND         q.Score >= @MinScore


-- Remove line above to allow questions with code --
AND        q.Score >= @MinScore


ORDER BY   Score DESC

view current version

edited may 11 15

created mar 29 15 SK55