DECLARE @Email VARCHAR(100) = 'nam.nguyen@ceezoo.com'

SELECT TOP 100 *
FROM dbo.Orders o
INNER JOIN dbo.Customers c ON c.ID = o.CustomerID
WHERE c.Email = @Email AND o.IsPushNotified = 0

UPDATE o
SET o.IsPushNotified = 1
FROM dbo.Orders o
INNER JOIN dbo.Customers c ON c.ID = o.CustomerID
WHERE c.Email != @Email AND o.IsPushNotified = 0


SELECT *
FROM dbo.CustomerDevices cd
INNER JOIN dbo.Customers c ON c.ID = cd.CustomerID
WHERE c.Email = @Email

UPDATE cd
SET cd.DeviceID = '85a21e3d-9765-4273-9b17-881d76146839' -- playerId web muốn gửi
FROM dbo.CustomerDevices cd
WHERE cd.DeviceID = '20DC9326-1617-45CD-A220-A325D4B16BB8'