When were this question's answers upvoted?

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 
v.CreationDate AS "Vote Date",
p.Id AS "Answer ID", 
DATEDIFF(day, p.CreationDate, pp.CreationDate) AS "Delay", 
p.CreationDate AS "Answer Date", 
p.Score AS "Answer Score", 
p.ParentId AS "Question ID", 
pp.CreationDate AS "Question Date",
pp.Title AS "Question Title"
FROM Posts p
JOIN Posts pp ON p.ParentId = pp.Id
JOIN Votes v ON v.PostId = p.Id
WHERE pp.Id = 90646 -- Question ID

Enter Parameters

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