select * from aw_packages

select * from aw_products

select C.cust_name, C.cust_email, C.cust_phones, C.cust_mobile 
from aw_customers C, aw_customer_subscription CS, aw_subscriptions S, aw_packages PKG, aw_product_package PP, aw_products PROD
where C.cust_id=CS.cust_id and CS.subscription_id=S.subscription_id and S.package_id=PKG.package_id and PKG.package_id=PP.package_id and PP.product_id=PROD.product_id
and P.product_id in ('WEB', 'RR')