Q&A about the site for gardeners and landscapers
SELECT p.Id, p2.AcceptedAnswerId, isnull(p2.Title, p.Title) AS Title, pt.Name, p.PostTypeId, 3 - p.PostTypeId - CASE WHEN p2.AcceptedAnswerId = p.Id THEN 0 ELSE 1 END AS Weight --p2.AcceptedAnswerId FROM Posts p JOIN PostTypes pt ON p.PostTypeId = pt.Id LEFT JOIN Posts p2 ON p.Id = p2.ParentId AND p.Id = p2.AcceptedAnswerId /* JOIN ( SELECT 1 AS PostTypeId, 'Question' AS WieghtType, 2 as WeightValue UNION ALL SELECT 2, 'Answer', 1 UNION ALL SELECT 3, 'Accepted Answer', 3 ) Weights */ WHERE p.OwnerUserId = 7816