· 4 years ago · Apr 15, 2021, 02:26 PM
1SELECT u.userEmail
2FROM users u
3LEFT JOIN (
4/*Users with API key issued in last 90 days - new registrations, new devices or login...*/
5
6SELECT userID FROM appapis
7WHERE appID = '7' AND appApiCreateDateTime > DATE_SUB(NOW(),INTERVAL 90 DAY)
8GROUP BY userID) app
9ON u.userID = app.userID
10
11WHERE app.userID is not NULL and userNewsletter = 1