0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for professionals, academics, and students working within the systems development life cycle

SELECT TOP 10000
    P.Id AS [Post ID],
    CONCAT('https://workplace.stackexchange.com/questions/', P.Id) AS [Post Link],
    P.Title AS [Post Title],
    FORMAT(P.CreationDate, 'dd-MM-yyyy') AS [Date Posted],
    U.Location AS [User Location],
    CONCAT('https://workplace.stackexchange.com/users/', U.Id) AS [User Profile Link]
FROM Posts P
LEFT JOIN Users U ON P.OwnerUserId = U.Id
WHERE 
    (P.Title LIKE '%elder senior%' OR P.Body LIKE '%elder senior%')
    AND (P.Title LIKE '%software engineering%' OR P.Body LIKE '%software engineering%')
    AND P.PostTypeId = 1 -- Apenas perguntas
ORDER BY P.CreationDate DESC;

fork query

edited dec 10

created dec 10 anonymous