psapir/Authors Query

## Authors Query
/*
This query populates an author DE by Selecting everyone who is in the MacAlertList who is also in the Subscriptions DE
*/
SELECT a.[Subscriber Key]
FROM MacAlertList a
WHERE Alerts like '%2658519%'
AND EXISTS (SELECT [Subscriber Key] FROM Subscriptions s WHERE s.[SubscriberKey] = a.[Subscriber Key] AND s.[DE Name] = 'Alan Weisman author alert - 2658519')
	/*
	This query populates an author DE by Selecting everyone who is in the MacAlertList who is also in the Subscriptions DE
	*/
	SELECT a.[Subscriber Key]
	FROM MacAlertList a
	WHERE Alerts like '%2658519%'
	AND EXISTS (SELECT [Subscriber Key] FROM Subscriptions s WHERE s.[SubscriberKey] = a.[Subscriber Key] AND s.[DE Name] = 'Alan Weisman author alert - 2658519')