Unnamed

SELECT distinct ul.ul_account_id
FROM user_levels ul, psp_subscriptions psp, user_account ua
LEFT JOIN psp.subs_created ON ul.account_id=psp.subs_subscriber_id 
WHERE psp.subs_user_level_id = ul.ul_id
AND ul_account_id = ua.account_id
AND psp.subs_created >= TO_DATE('$start_date','YYYYMMDD')
AND psp.subs_created <= TO_DATE('$end_date','YYYYMMDD')
AND psp.subs_status = 2
ORDER BY psp.subs_created;";