Cacher is the code snippet organizer for pro developers

SELECT 
createdon AS Modified,
EmailAddress, 
CASE WHEN status = 'active' THEN 'True'
ELSE 'false'
END AS nboptin, 
slug
FROM [FS Subscribe]
WHERE mailinglist = 'PL - Newsletter'
UNION
SELECT
date AS Modified,
EmailAddress,
'True' AS nboptin,
slug
FROM [Import - all]
WHERE nboptin_boolean = 'True'