SELECT | |
1 AS enter_credit_card, | |
time AS enter_credit_card_time | |
FROM event | |
WHERE | |
user_id = e1.user_id AND | |
data->>'type' = 'enter_credit_card' AND | |
time BETWEEN view_homepage_time AND (view_homepage_time + 1000*60*60*24*14) | |
ORDER BY time | |
LIMIT 1 |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment