SELECT
t1.SUBSCRIPTION_ID, t2.USER_DISPLAY_NAME, t4.USER_REAL_EMAIL, t3.SUBSCRIPTION_NAME, t1.SUBSCRIPTION_START_DATE,
t1.SUBSCRIPTION_END_DATE, t1.SUBSCRIPTION_STATUS, t1.SUBSCRIPTION_IS_ACTIVE, t1.SUBSCRIPTION_PAYMENT, t1.USER_ID,
t3.GROUP_ID
FROM
ubbt_SUBSCRIPTION_DATA AS t1,
ubbt_USERS AS t2,
ubbt_SUBSCRIPTIONS AS t3,
ubbt_USER_PROFILE AS t4
WHERE
t1.USER_ID = t2.USER_ID AND
t1.GROUP_ID = t3.GROUP_ID AND
t1.USER_ID = t4.USER_ID
ORDER BY t1.SUBSCRIPTION_ID DESC