Show all types

17

Please login or register to vote for this query.

(click on this box to dismiss)

Show post history types, post types and vote types.

Gardening and Landscaping Meta

Q&A for gardeners and landscapers

-- Show types
-- Show post history types, post types and vote types.

SELECT Coalesce(COTRT.Id, CRT.Id, FT.Id, PT.Id, PHT.Id, RTRT.Id, RTT.Id, VT.Id) As [Id],
       Min(PT.Name) As [Post],
       Min(PHT.Name) As [Revision],
       Min(VT.Name) As [Vote],
       Min(CRT.Name) As [Close],
       Min(COTRT.MarkdownMini) As [Off-topic],
       Min(FT.Name) As [Flag],
       Min(RTT.Name) As [Review],
       Min(RTRT.Name) As [Review result]
FROM PostTypes PT
FULL OUTER JOIN CloseAsOffTopicReasonTypes COTRT
ON PT.Id = COTRT.Id
FULL OUTER JOIN CloseReasonTypes CRT
ON PT.Id = CRT.Id
FULL OUTER JOIN FlagTypes FT
ON PT.Id = FT.Id
FULL OUTER JOIN PostHistoryTypes PHT
ON PT.Id = PHT.Id
FULL OUTER JOIN VoteTypes VT
ON PT.Id = VT.Id
FULL OUTER JOIN ReviewTaskResultTypes RTRT
ON PT.Id = RTRT.Id
FULL OUTER JOIN ReviewTaskTypes RTT
ON PT.Id = RTT.Id
GROUP BY Coalesce(COTRT.Id, CRT.Id, FT.Id, PT.Id, PHT.Id, RTRT.Id, RTT.Id, VT.Id)
ORDER BY Id ASC

Enter Parameters

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