select * from aw_products where active_flag='Y' and product_type_id='RR' and frequency='MONTHLY'
select * from aw_products where active_flag='Y' and product_type_id='RR' and frequency='daily'
select * from aw_packages where package_type='COMBO'

select * from aw_product_package where package_id=200019
select * from aw_packages where package_id in (8,200000,200018)
select * from aw_product_package where product_id=200027

8	Website + ALL Research Reports	COMBO

--200044	RR	Pulses Monthly Research Report	2	0	MONTHLY	Y
--200019	Pulses (Daily + Weekly) Research Report	COMBO
--nsert into aw_product_package values (200044, 200019)

--200042	RR	Wheat Monthly Research Report	1	2	MONTHLY	Y
--200027	Wheat (Daily + Weekly) Research Report	COMBO
--nsert into aw_product_package values (200042, 200027)

--200049	RR	Cotton Monthly Research Report	7	24	MONTHLY	Y
--200018	Cotton (Daily + Weekly) Research Report	COMBO
--nsert into aw_product_package values (200049, 200018)

--200043	RR	Maize Monthly Research Report	1	3	MONTHLY	Y
--200038	Maize (Daily + Weekly) Research Report	COMBO
--nsert into aw_product_package values (200043, 200038)

--200045	RR	Veg Oil Monthly Research Report	3	0	MONTHLY	Y
--200022	Veg Oils (Daily + Weekly) Research Report	COMBO
--nsert into aw_product_package values (200045, 200022)

--200046	RR	Oil Seeds Monthly Research Report	4	0	MONTHLY	Y
--200043	Oilseeds (Daily + Weekly) Research Report	COMBO
--nsert into aw_product_package values (200046, 200043)

--200047	RR	Oil Meals Monthly Research Report	5	0	MONTHLY	Y
--200023	Oil Meal (Daily + Weekly) Research Report	COMBO
--nsert into aw_product_package values (200047, 200023)

--200048	RR	Sugar Monthly Research Report	6	0	MONTHLY	Y
--200020	Sugar (Daily + Weekly) Research Report	COMBO
--insert into aw_product_package values (200048, 200020)

--200050	RR	Guar Monthly Research Report	8	0	MONTHLY	Y
--200021	Guar (Daily + Weekly) Research Report	COMBO
--nsert into aw_product_package values (200050, 200021)

--200051	RR	Spices Monthly Research Report	9	0	MONTHLY	Y
--200025	Spices (Daily + Weekly) Research Report	COMBO
--insert into aw_product_package values (200051, 200025)

