0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for people studying math at any level and professionals in related fields

SELECT TOP 1
    p.id -- Explicitly qualify the 'id' column to avoid ambiguity
    --q.title AS QuestionTitle,
    --TIMESTAMPDIFF(MINUTE, q.creation_date, a.creation_date) AS TimeToAnswerInMinutes
FROM 
    Posts p
JOIN 
    PostTags t ON p.id = t.PostId
JOIN 
    Tags a ON t.TagId = a.Id
WHERE 
    p.CreationDate >= '2024-11-25 08:00:00' AND
    p.PostTypeId = 1 AND t.TagId = 11549
    --Tags LIKE '%<java>%'

    --AND a.is_accepted = 1
--ORDER BY 
--    TimeToAnswerInMinutes ASC;

view current version

edited dec 3

created dec 3 jon.doe46454