Q&A about the site for enthusiasts and power users of the Android operating system
select p.Id, aa.CreationDate, aa.LastActivityDate, pfpp.*, pfaa.*, aa.*, p.* FROM Posts p inner join Posts aa on (aa.ParentId = p.Id and aa.Id=p.AcceptedAnswerId) inner join PendingFlags pfpp on (pfpp.PostId=p.Id) inner join PendingFlags pfaa on (pfaa.PostId=aa.Id) where p.Id in (26705784)