Q&A for users and developers of hardware and software for Raspberry Pi
WITH Raw AS ( SELECT Q.OwnerUserId AS QUserId, A.OwnerUserId AS AUserId FROM Posts Q, Posts A WHERE Q.OwnerUserId > 0 AND A.OwnerUserId > 0 AND Q.CommunityOwnedDate IS NULL AND A.CommunityOwnedDate IS NULL AND A.ParentId = Q.Id AND Q.OwnerUserId <> A.OwnerUserId GROUP BY Q.OwnerUserId, A.OwnerUserId ), Raw2 AS ( SELECT QUserId, AUserId FROM Raw INTERSECT SELECT AUserId AS QUserId, QUserId AS AUserId FROM Raw ) SELECT QUsers.AccountId AS QSEId, AUsers.AccountId AS ASEId FROM Raw2, Users QUsers, Users AUsers WHERE Raw2.QUserId = QUsers.Id AND Raw2.AUserId = AUsers.Id AND QUsers.AccountId > AUsers.AccountId ORDER BY QUsers.AccountId + AUsers.AccountId DESC