SELECT [e].[Id], [e0].[Id], [e0].[EntityId], [e0].[Name]
FROM [Entity] AS [e]
LEFT JOIN [Entity] AS [e0] ON [e].[Id] = [e0].[EntityId]
ORDER BY [e].[Id]