Perl top 1000

0

Please login or register to vote for this query.

(click on this box to dismiss)

Joomla

Q&A for Joomla! administrators, users, developers and designers

SELECT TOP 1000
p.Title AS "Title",
-- a.Score AS "Accepted Score",  
p.ViewCount AS "ViewCount",
p.Body  AS "Question",
a.Body  AS "Accepted Answer",
u.DisplayName AS "Asker",
au.DisplayName AS "Answerer"
  
FROM Posts p
JOIN Posts a ON p.AcceptedAnswerId = a.Id
JOIN Users u ON p.OwnerUserId = u.Id
JOIN Users au ON a.OwnerUserId = au.Id
inner join posttags pt on pt.postid = p.id
inner join tags t on pt.tagid = t.id
WHERE t.tagname in ('perl')
AND p.PostTypeId = 1
and p.AcceptedAnswerId IS NOT NULL
ORDER BY p.ViewCount DESC

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results