0

Please login or register to vote for this query.

(click on this box to dismiss)

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

SELECT p.Id AS [Post Link], p.Score, p.Title, p.Tags, p.CreationDate AS [Date Posted],
p.CommentCount, p.Body, p.ViewCount, p.AnswerCount, p.FavoriteCount,
a.Id AS [Answer Link], a.Score AS [Answer Score], a.Body AS [Answer Body]
FROM Posts p
JOIN Posts a ON p.Id = a.ParentId
WHERE p.PostTypeId = 1 -- Question
AND a.PostTypeId = 2 -- Answer
AND (
p.Title LIKE '%instrumentation%' OR p.Body LIKE '%instrumentation%' OR
p.Title LIKE '%overhead%' OR p.Body LIKE '%overhead%' OR
p.Title LIKE '%performance%' OR p.Body LIKE '%performance%' OR
p.Title LIKE '%code%' OR p.Body LIKE '%code%' OR
p.Title LIKE '%energy%' OR p.Body LIKE '%energy%'
)
ORDER BY p.ViewCount DESC, p.Score DESC, p.CreationDate DESC;

fork query

edited apr 17 jon.doe44382

created dec 8 23 Gerson