SELECT TOP 100 p.Id AS [Post Link], p.AcceptedAnswerId, p...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Mythology Meta

Q&A about the site for enthusiasts and scholars of mythology and folklore

SELECT TOP 100
    p.Id AS [Post Link],
    p.AcceptedAnswerId,
    p.CreationDate,
    p.Score,
    p.Title,
    p.Body
FROM 
    Posts p
WHERE 
    (p.Title LIKE '%requirement%' OR p.Tags LIKE '%requirement%')
    AND (
        -- Include additional keywords related to requirements engineering
        p.Body LIKE '%analysis%' OR
        p.Body LIKE '%stakehold%' OR
        p.Body LIKE '%communicat%' OR
        p.Body LIKE '%manag%' OR
        p.Body LIKE '%functional%' OR
        p.Body LIKE '%scope%' OR
        p.Body LIKE '%customer%' OR
        p.Body LIKE '%evaluat%' OR
        p.Body LIKE '%elicit%' OR
        p.Body LIKE '%client%' OR
        p.Body LIKE '%verif%' OR
        p.Body LIKE '%use case%' OR
        p.Body LIKE '%user stor[yi]%' OR
        p.Body LIKE '%estimat%' OR
        p.Body LIKE '%specification%' OR
        p.Body LIKE '%prototype%' OR
        p.Body LIKE '%methodology%' OR
        p.Body LIKE '%gather%' OR
        p.Body LIKE '%expectation%' OR
        p.Body LIKE '%software%'
    )
    AND (
        -- Exclude posts containing words related to job, hiring, career, and job market from both title and body
        p.Tags NOT LIKE '%rails-ssl-requirement%' AND
        p.Tags NOT LIKE '%requirements.txt%' AND
        p.Title NOT LIKE '%job%' AND
        p.Title NOT LIKE '%hiring%' AND
        p.Title NOT LIKE '%career%' AND
        p.Title NOT LIKE '%job market%' AND
        p.Title NOT LIKE '%requirements.txt%' AND
        p.Body NOT LIKE '%job%' AND
        p.Body NOT LIKE '%hiring%' AND
        p.Body NOT LIKE '%career%' AND
        p.Body NOT LIKE '%job market%' AND
        p.Body NOT LIKE '%requirements.txt%'
    )
    AND (
        p.AcceptedAnswerId > 0 -- Filter out posts without accepted answers
    )
ORDER BY 
    p.Score DESC;

Enter Parameters

Options:
Switch to main site
loading Hold tight while we fetch your results