psapir · January 7, 2018 14:48
diff --git a/Authors Query b/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')