Weighted Activity Gauge for Scifi


Please login or register to vote for this query.

(click on this box to dismiss)

ExpressionEngine® Answers

Q&A for administrators, end users, developers and designers for ExpressionEngine® CMS

SELECT p.Id, isnull(p2.Title, p.Title) AS [Title], pt.Name, p2.AcceptedAnswerId
FROM Posts p
JOIN PostTypes pt
ON p.PostTypeId = pt.Id
LEFT JOIN Posts p2
ON p2.Id = p.ParentId
WHERE p.OwnerUserId = 7816

Enter Parameters

Switch sites:
loading Hold tight while we fetch your results