Umbraco user notification SQL Query

notification_query.sql

-- Select all notifications for user
SELECT TOP 1000 
	uu.userName,
	uu.userEmail,
	[userId],
	cd.[nodeId],
	cd.text,
	cd.published,
	cd.updateDate,
	[action]
FROM [dbo].[umbracoUser2NodeNotify] u2n
inner join umbracoUser uu on u2n.userId = uu.id
inner join cmsDocument cd on u2n.nodeId = cd.nodeId and cd.published = 1
-- where u2n.userId = 0
order by userid