All Java Posts

0

Please login or register to vote for this query.

(click on this box to dismiss)

Korean Language

Q&A for linguists, teachers and students of the Korean language

SELECT
    q.Id AS [Post Link],
    q.Title,
    a.Score AS [Accepted Answer Score]
FROM
    Posts q
JOIN
    Posts a ON q.AcceptedAnswerId = a.Id
JOIN
    PostTags pt ON q.Id = pt.PostId
JOIN
    Tags t ON pt.TagId = t.Id
WHERE
    q.PostTypeId = 1 -- Samo pitanja
    AND a.PostTypeId = 2 -- Prihvaćeni odgovor
    AND a.Score > 100 -- Broj lajkova prihvaćenog odgovora veći od 100
    AND t.TagName = 'java' -- Samo pitanja s tagom 'java'

Enter Parameters

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