SELECT
(
CASE WHEN ourtable_osmembership_subscribers.plan_subscription_from_date
BETWEEN '2018-03-01 00:00:00' AND '2019-03-01 00:00:00' THEN '2018 - 2019'
WHEN ourtable_osmembership_subscribers.plan_subscription_from_date
BETWEEN '2019-03-01 00:00:00' AND '2020-03-01 00:00:00' THEN '2019 - 2020'
WHEN ourtable_osmembership_subscribers.plan_subscription_from_date
BETWEEN '2020-03-01 00:00:00' AND '2021-03-01 00:00:00' THEN '2020 - 2021'
ELSE 'unknown'
END
)
FROM
ourtable_osmembership_subscribers
INNER JOIN ourtable_comprofiler ON ourtable_osmembership_subscribers.user_id = ourtable_comprofiler.user_id
WHERE ourtable_comprofiler.user_id = ourtable_osmembership_subscribers.user_id
Please Log in to join the conversation.
SELECT
(
CASE WHEN `plan_subscription_from_date`
BETWEEN '2018-03-01 00:00:00' AND '2019-03-01 00:00:00' THEN '2018 - 2019'
WHEN `plan_subscription_from_date`
BETWEEN '2019-03-01 00:00:00' AND '2020-03-01 00:00:00' THEN '2019 - 2020'
WHEN `plan_subscription_from_date`
BETWEEN '2020-03-01 00:00:00' AND '2021-03-01 00:00:00' THEN '2020 - 2021'
ELSE 'unknown'
END
)
FROM `ourtable_osmembership_subscribers`
WHERE `user_id` = '[user_id]'
Please Log in to join the conversation.