>  Directories >  Grantee Profiles >  Background >  National Demonstration >  National Evaluation >  Program Partners >  Publications   Free To Grow   Mailman School   of Public Health   Columbia University   722 West 168th Street,   8th Floor   New York, NY 10032   Phone: 212-305-8120   Fax: 212-342-1963   info@freetogrow.org		The parents and staff who participate in Head Start programs have long known that many factors beyond the classroom affect how children grow, learn and get along in the world. They have always made efforts to remedy the kinds of problems that undermine family life, such as substance abuse and child abuse and neglect. In 1994, the National Head Start Bureau decided to explore more systematic ways to deal with substance abuse and its impact on young children. To this end, it entered into a unique partnership with the Robert Wood Johnson Foundation, one of the nation’s leading philanthropies in the field of health. Out of this collaboration emerged Free To Grow: Head Start Partnerships to Promote Substance-free Communities– a national community-based initiative that focuses on strengthening the overall environment of young children, particularly their families and communities. Free To Grow’s innovative prevention approach was developed by Head Start for Head Start. Its strategies were originally tested in five pilot sites located in San Isidro, Puerto Rico; Owensboro, Kentucky; Compton, California; Colorado Springs, Colorado; and Washington Heights in New York City. In 2001, the Doris Duke Charitable Foundation and the Office of Juvenile Justice and Delinquency Prevention (OJJDP) of the US Department of Justice joined the partnership to launch an evaluation and program demonstration phase of the initiative. Today, there are fifteen Free To Grow sites across the country. These sites work in collaboration with local funding and program partners, including school systems, law enforcement, and substance abuse and mental health treatment programs, to develop integrated family- and community focused prevention approaches that fit the local community context. Free To Grow operates under the auspices of the Mailman School of Public Health of Columbia University, which provides technical support to local grantees in program development and implementation. The national evaluation is being conducted by Wake Forest University School of Medicine. Program and evaluation activities are also guided by a National Advisory Committee and Evaluation Advisory Panel, made up of leading program, policy and research experts in the fields of early childhood development and community-based prevention. Directories Grantee Profiles Background National Demonstration National Evaluation Program Partners Publications
		Contact Us [info@freetogrow.org] copyright 2005 Free To Grow Disclaimer an iapps site Free To Grow is a national program supported by the Robert Wood Johnson Foundation and the Doris Duke Charitable Foundation with direction and technical assistance provided by the Mailman School of Public Health of Columbia University.

 (Records=1, Time=15ms)
SQL = 
sp_application_body

 (Records=1, Time=0ms)
SQL = 
sp_application_body

 (Records=1, Time=0ms)
SQL = 
sp_application_body

 (Records=1, Time=0ms)
SQL = 
sp_application_body

 (Records=1, Time=0ms)
SQL = 
sp_application_body

qry_cached (Records=1, Time=0ms)
SQL = 
sp_frame_cache 3354

qry_cache_existence (Records=1, Time=0ms)
SQL = 
sp_cached_output_get 'StyleSheet_1', 'ftg'

qry_get_text (Records=1, Time=0ms)
SQL = 
sp_get_text 3354

qry_get_text (Records=1, Time=15ms)
SQL = 
sp_get_text 3354

get_children (Records=2, Time=16ms)
SQL = 
SELECT 	lable,
			url,
			frame_id
	FROM	tbl_feature_usage
	WHERE	parent_id = 3354
	AND		frame_id not in (3382)
	order by creation_date

qry_categories (Records=5, Time=0ms)
SQL = 
SELECT		DISTINCT char_3
	FROM 		tbl_docs
	WHERE 		FRAME_ID = 3354
	AND 		active = 1
	ORDER BY 	char_3

qry_featured_grantee (Records=0, Time=15ms)
SQL = 
SELECT		td.doc_id,
				td.char_1,
				td.char_5,
				td.char_6,
				td.text_2
	FROM 		tbl_docs td
	INNER JOIN	tbl_doc_has_attrib tdha
		ON 		td.doc_id = tdha.doc_id
	WHERE 		td.frame_id = 3381
	AND 		tdha.attrib_id = 5386
	AND	 		td.active = 1

get_categories (Records=5, Time=0ms)
SQL = 
select DISTINCT case 
			when tdha.attrib_id = 7434 then 'Family'
			when tdha.attrib_id = 7435 then 'Partners'
			when tdha.attrib_id = 7436 then 'Community'
			when tdha.attrib_id = 7437 then 'Web Links'
			when tdha.attrib_id = 7438 then 'General'
		end as lable,
		case 
			when tdha.attrib_id = 7434 then 1
			when tdha.attrib_id = 7435 then 2
			when tdha.attrib_id = 7436 then 3
			when tdha.attrib_id = 7437 then 4
			when tdha.attrib_id = 7438 then 5
		end as prior,
		tdha.attrib_id
	from tbl_docs td,
	     tbl_doc_has_attrib tdha
	where td.frame_id = 3359
	and td.doc_id = tdha.doc_id
	and tdha.attrib_id in (select attrib_id from tbl_attrib where type_id = 957)
	order by  prior, lable, tdha.attrib_id

get_site_id (Records=1, Time=0ms)
SQL = 
SELECT	 	site_id
	FROM	 	tbl_feature_usage
	WHERE	 	frame_id = 3361

get_frame_properties (Records=1, Time=0ms)
SQL = 
SELECT		tool_config
	FROM		tbl_feature_usage
	WHERE		frame_id = 3361
	AND			site_id = 'ftg'

qry_cat_list (Records=6, Time=0ms)
SQL = 
select 	tdc.name, 
				tdc.doc_category_id,
				tdc.doc_category_order_num,
				tdc.frame_id
		from 	tbl_docs td,
				tbl_doc_categories tdc
		where 	tdc.frame_id = 3361
		AND		tdc.status = 1
		AND		tdc.frame_id = td.frame_id
		and		td.doc_category_id in (select doc_category_id from tbl_doc_categories where frame_id = 3361)
		group by tdc.doc_category_id, tdc.name, tdc.doc_category_order_num, tdc.frame_id
		order by tdc.doc_category_order_num, tdc.name

qry_docs_num (Records=1, Time=16ms)
SQL = 
select 	Count(td.doc_id) 'count'
				from 	tbl_docs td
				where 	td.doc_category_id = 6
				and		td.frame_id = 3361

qry_cat_abstract (Records=1, Time=0ms)
SQL = 
select 	tdc.abstract
							from 	tbl_doc_categories tdc
							where 	tdc.doc_category_id = 6
							and		tdc.frame_id = 3361

qry_cat_text (Records=1, Time=0ms)
SQL = 
select 	tdc.text
							from 	tbl_doc_categories tdc
							where 	tdc.doc_category_id = 6
							and		tdc.frame_id = 3361

qry_docs_num (Records=1, Time=16ms)
SQL = 
select 	Count(td.doc_id) 'count'
				from 	tbl_docs td
				where 	td.doc_category_id = 7
				and		td.frame_id = 3361

qry_cat_abstract (Records=1, Time=0ms)
SQL = 
select 	tdc.abstract
							from 	tbl_doc_categories tdc
							where 	tdc.doc_category_id = 7
							and		tdc.frame_id = 3361

qry_cat_text (Records=1, Time=0ms)
SQL = 
select 	tdc.text
							from 	tbl_doc_categories tdc
							where 	tdc.doc_category_id = 7
							and		tdc.frame_id = 3361

qry_docs_num (Records=1, Time=15ms)
SQL = 
select 	Count(td.doc_id) 'count'
				from 	tbl_docs td
				where 	td.doc_category_id = 8
				and		td.frame_id = 3361

qry_cat_abstract (Records=1, Time=0ms)
SQL = 
select 	tdc.abstract
							from 	tbl_doc_categories tdc
							where 	tdc.doc_category_id = 8
							and		tdc.frame_id = 3361

qry_cat_text (Records=1, Time=0ms)
SQL = 
select 	tdc.text
							from 	tbl_doc_categories tdc
							where 	tdc.doc_category_id = 8
							and		tdc.frame_id = 3361

qry_docs_num (Records=1, Time=16ms)
SQL = 
select 	Count(td.doc_id) 'count'
				from 	tbl_docs td
				where 	td.doc_category_id = 272
				and		td.frame_id = 3361

qry_cat_abstract (Records=1, Time=0ms)
SQL = 
select 	tdc.abstract
							from 	tbl_doc_categories tdc
							where 	tdc.doc_category_id = 272
							and		tdc.frame_id = 3361

qry_cat_text (Records=1, Time=0ms)
SQL = 
select 	tdc.text
							from 	tbl_doc_categories tdc
							where 	tdc.doc_category_id = 272
							and		tdc.frame_id = 3361

qry_docs_num (Records=1, Time=15ms)
SQL = 
select 	Count(td.doc_id) 'count'
				from 	tbl_docs td
				where 	td.doc_category_id = 437
				and		td.frame_id = 3361

qry_cat_abstract (Records=1, Time=16ms)
SQL = 
select 	tdc.abstract
							from 	tbl_doc_categories tdc
							where 	tdc.doc_category_id = 437
							and		tdc.frame_id = 3361

qry_cat_text (Records=1, Time=0ms)
SQL = 
select 	tdc.text
							from 	tbl_doc_categories tdc
							where 	tdc.doc_category_id = 437
							and		tdc.frame_id = 3361

qry_docs_num (Records=1, Time=0ms)
SQL = 
select 	Count(td.doc_id) 'count'
				from 	tbl_docs td
				where 	td.doc_category_id = 9
				and		td.frame_id = 3361

qry_cat_abstract (Records=1, Time=16ms)
SQL = 
select 	tdc.abstract
							from 	tbl_doc_categories tdc
							where 	tdc.doc_category_id = 9
							and		tdc.frame_id = 3361

qry_cat_text (Records=1, Time=0ms)
SQL = 
select 	tdc.text
							from 	tbl_doc_categories tdc
							where 	tdc.doc_category_id = 9
							and		tdc.frame_id = 3361

get_site_id (Records=1, Time=0ms)
SQL = 
SELECT	 	site_id
	FROM	 	tbl_feature_usage
	WHERE	 	frame_id = 3360

get_frame_properties (Records=1, Time=15ms)
SQL = 
SELECT		tool_config
	FROM		tbl_feature_usage
	WHERE		frame_id = 3360
	AND			site_id = 'ftg'

qry_cat_list (Records=5, Time=0ms)
SQL = 
select 	tdc.name, 
				tdc.doc_category_id,
				tdc.doc_category_order_num,
				tdc.frame_id
		from 	tbl_docs td,
				tbl_doc_categories tdc
		where 	tdc.frame_id = 3360
		AND		tdc.status = 1
		AND		tdc.frame_id = td.frame_id
		and		td.doc_category_id in (select doc_category_id from tbl_doc_categories where frame_id = 3360)
		group by tdc.doc_category_id, tdc.name, tdc.doc_category_order_num, tdc.frame_id
		order by tdc.doc_category_order_num, tdc.name

qry_docs_num (Records=1, Time=0ms)
SQL = 
select 	Count(td.doc_id) 'count'
				from 	tbl_docs td
				where 	td.doc_category_id = 1
				and		td.frame_id = 3360

qry_cat_abstract (Records=1, Time=0ms)
SQL = 
select 	tdc.abstract
							from 	tbl_doc_categories tdc
							where 	tdc.doc_category_id = 1
							and		tdc.frame_id = 3360

qry_cat_text (Records=1, Time=0ms)
SQL = 
select 	tdc.text
							from 	tbl_doc_categories tdc
							where 	tdc.doc_category_id = 1
							and		tdc.frame_id = 3360

qry_docs_num (Records=1, Time=15ms)
SQL = 
select 	Count(td.doc_id) 'count'
				from 	tbl_docs td
				where 	td.doc_category_id = 2
				and		td.frame_id = 3360

qry_cat_abstract (Records=1, Time=0ms)
SQL = 
select 	tdc.abstract
							from 	tbl_doc_categories tdc
							where 	tdc.doc_category_id = 2
							and		tdc.frame_id = 3360

qry_cat_text (Records=1, Time=0ms)
SQL = 
select 	tdc.text
							from 	tbl_doc_categories tdc
							where 	tdc.doc_category_id = 2
							and		tdc.frame_id = 3360

qry_docs_num (Records=1, Time=0ms)
SQL = 
select 	Count(td.doc_id) 'count'
				from 	tbl_docs td
				where 	td.doc_category_id = 3
				and		td.frame_id = 3360

qry_cat_abstract (Records=1, Time=0ms)
SQL = 
select 	tdc.abstract
							from 	tbl_doc_categories tdc
							where 	tdc.doc_category_id = 3
							and		tdc.frame_id = 3360

qry_cat_text (Records=1, Time=0ms)
SQL = 
select 	tdc.text
							from 	tbl_doc_categories tdc
							where 	tdc.doc_category_id = 3
							and		tdc.frame_id = 3360

qry_docs_num (Records=1, Time=15ms)
SQL = 
select 	Count(td.doc_id) 'count'
				from 	tbl_docs td
				where 	td.doc_category_id = 4
				and		td.frame_id = 3360

qry_cat_abstract (Records=1, Time=0ms)
SQL = 
select 	tdc.abstract
							from 	tbl_doc_categories tdc
							where 	tdc.doc_category_id = 4
							and		tdc.frame_id = 3360

qry_cat_text (Records=1, Time=0ms)
SQL = 
select 	tdc.text
							from 	tbl_doc_categories tdc
							where 	tdc.doc_category_id = 4
							and		tdc.frame_id = 3360

qry_docs_num (Records=1, Time=16ms)
SQL = 
select 	Count(td.doc_id) 'count'
				from 	tbl_docs td
				where 	td.doc_category_id = 5
				and		td.frame_id = 3360

qry_cat_abstract (Records=1, Time=0ms)
SQL = 
select 	tdc.abstract
							from 	tbl_doc_categories tdc
							where 	tdc.doc_category_id = 5
							and		tdc.frame_id = 3360

qry_cat_text (Records=1, Time=0ms)
SQL = 
select 	tdc.text
							from 	tbl_doc_categories tdc
							where 	tdc.doc_category_id = 5
							and		tdc.frame_id = 3360

get_site_id (Records=1, Time=0ms)
SQL = 
SELECT	 	site_id
	FROM	 	tbl_feature_usage
	WHERE	 	frame_id = 3812

get_frame_properties (Records=1, Time=0ms)
SQL = 
SELECT		tool_config
	FROM		tbl_feature_usage
	WHERE		frame_id = 3812
	AND			site_id = 'ftg'

qry_cat_list (Records=6, Time=0ms)
SQL = 
select 	tdc.name, 
				tdc.doc_category_id,
				tdc.doc_category_order_num,
				tdc.frame_id
		from 	tbl_docs td,
				tbl_doc_categories tdc
		where 	tdc.frame_id = 3812
		AND		tdc.status = 1
		AND		tdc.frame_id = td.frame_id
		and		td.doc_category_id in (select doc_category_id from tbl_doc_categories where frame_id = 3812)
		group by tdc.doc_category_id, tdc.name, tdc.doc_category_order_num, tdc.frame_id
		order by tdc.doc_category_order_num, tdc.name

qry_docs_num (Records=1, Time=0ms)
SQL = 
select 	Count(td.doc_id) 'count'
				from 	tbl_docs td
				where 	td.doc_category_id = 49
				and		td.frame_id = 3812

qry_cat_abstract (Records=1, Time=16ms)
SQL = 
select 	tdc.abstract
							from 	tbl_doc_categories tdc
							where 	tdc.doc_category_id = 49
							and		tdc.frame_id = 3812

qry_cat_text (Records=1, Time=0ms)
SQL = 
select 	tdc.text
							from 	tbl_doc_categories tdc
							where 	tdc.doc_category_id = 49
							and		tdc.frame_id = 3812

qry_docs_num (Records=1, Time=0ms)
SQL = 
select 	Count(td.doc_id) 'count'
				from 	tbl_docs td
				where 	td.doc_category_id = 50
				and		td.frame_id = 3812

qry_cat_abstract (Records=1, Time=15ms)
SQL = 
select 	tdc.abstract
							from 	tbl_doc_categories tdc
							where 	tdc.doc_category_id = 50
							and		tdc.frame_id = 3812

qry_cat_text (Records=1, Time=31ms)
SQL = 
select 	tdc.text
							from 	tbl_doc_categories tdc
							where 	tdc.doc_category_id = 50
							and		tdc.frame_id = 3812

qry_docs_num (Records=1, Time=0ms)
SQL = 
select 	Count(td.doc_id) 'count'
				from 	tbl_docs td
				where 	td.doc_category_id = 51
				and		td.frame_id = 3812

qry_cat_abstract (Records=1, Time=16ms)
SQL = 
select 	tdc.abstract
							from 	tbl_doc_categories tdc
							where 	tdc.doc_category_id = 51
							and		tdc.frame_id = 3812

qry_cat_text (Records=1, Time=0ms)
SQL = 
select 	tdc.text
							from 	tbl_doc_categories tdc
							where 	tdc.doc_category_id = 51
							and		tdc.frame_id = 3812

qry_docs_num (Records=1, Time=0ms)
SQL = 
select 	Count(td.doc_id) 'count'
				from 	tbl_docs td
				where 	td.doc_category_id = 52
				and		td.frame_id = 3812

qry_cat_abstract (Records=1, Time=15ms)
SQL = 
select 	tdc.abstract
							from 	tbl_doc_categories tdc
							where 	tdc.doc_category_id = 52
							and		tdc.frame_id = 3812

qry_cat_text (Records=1, Time=0ms)
SQL = 
select 	tdc.text
							from 	tbl_doc_categories tdc
							where 	tdc.doc_category_id = 52
							and		tdc.frame_id = 3812

qry_docs_num (Records=1, Time=0ms)
SQL = 
select 	Count(td.doc_id) 'count'
				from 	tbl_docs td
				where 	td.doc_category_id = 438
				and		td.frame_id = 3812

qry_cat_abstract (Records=1, Time=0ms)
SQL = 
select 	tdc.abstract
							from 	tbl_doc_categories tdc
							where 	tdc.doc_category_id = 438
							and		tdc.frame_id = 3812

qry_cat_text (Records=1, Time=0ms)
SQL = 
select 	tdc.text
							from 	tbl_doc_categories tdc
							where 	tdc.doc_category_id = 438
							and		tdc.frame_id = 3812

qry_docs_num (Records=1, Time=0ms)
SQL = 
select 	Count(td.doc_id) 'count'
				from 	tbl_docs td
				where 	td.doc_category_id = 53
				and		td.frame_id = 3812

qry_cat_abstract (Records=1, Time=0ms)
SQL = 
select 	tdc.abstract
							from 	tbl_doc_categories tdc
							where 	tdc.doc_category_id = 53
							and		tdc.frame_id = 3812

qry_cat_text (Records=1, Time=0ms)
SQL = 
select 	tdc.text
							from 	tbl_doc_categories tdc
							where 	tdc.doc_category_id = 53
							and		tdc.frame_id = 3812

get_site_id (Records=1, Time=16ms)
SQL = 
SELECT	 	site_id
	FROM	 	tbl_feature_usage
	WHERE	 	frame_id = 3362

get_frame_properties (Records=1, Time=0ms)
SQL = 
SELECT		tool_config
	FROM		tbl_feature_usage
	WHERE		frame_id = 3362
	AND			site_id = 'ftg'

qry_cat_list (Records=5, Time=0ms)
SQL = 
select 	tdc.name, 
				tdc.doc_category_id,
				tdc.doc_category_order_num,
				tdc.frame_id
		from 	tbl_docs td,
				tbl_doc_categories tdc
		where 	tdc.frame_id = 3362
		AND		tdc.status = 1
		AND		tdc.frame_id = td.frame_id
		and		td.doc_category_id in (select doc_category_id from tbl_doc_categories where frame_id = 3362)
		group by tdc.doc_category_id, tdc.name, tdc.doc_category_order_num, tdc.frame_id
		order by tdc.doc_category_order_num, tdc.name

qry_docs_num (Records=1, Time=16ms)
SQL = 
select 	Count(td.doc_id) 'count'
				from 	tbl_docs td
				where 	td.doc_category_id = 10
				and		td.frame_id = 3362

qry_cat_abstract (Records=1, Time=0ms)
SQL = 
select 	tdc.abstract
							from 	tbl_doc_categories tdc
							where 	tdc.doc_category_id = 10
							and		tdc.frame_id = 3362

qry_cat_text (Records=1, Time=0ms)
SQL = 
select 	tdc.text
							from 	tbl_doc_categories tdc
							where 	tdc.doc_category_id = 10
							and		tdc.frame_id = 3362

qry_docs_num (Records=1, Time=15ms)
SQL = 
select 	Count(td.doc_id) 'count'
				from 	tbl_docs td
				where 	td.doc_category_id = 11
				and		td.frame_id = 3362

qry_cat_abstract (Records=1, Time=0ms)
SQL = 
select 	tdc.abstract
							from 	tbl_doc_categories tdc
							where 	tdc.doc_category_id = 11
							and		tdc.frame_id = 3362

qry_cat_text (Records=1, Time=16ms)
SQL = 
select 	tdc.text
							from 	tbl_doc_categories tdc
							where 	tdc.doc_category_id = 11
							and		tdc.frame_id = 3362

qry_docs_num (Records=1, Time=0ms)
SQL = 
select 	Count(td.doc_id) 'count'
				from 	tbl_docs td
				where 	td.doc_category_id = 12
				and		td.frame_id = 3362

qry_cat_abstract (Records=1, Time=0ms)
SQL = 
select 	tdc.abstract
							from 	tbl_doc_categories tdc
							where 	tdc.doc_category_id = 12
							and		tdc.frame_id = 3362

qry_cat_text (Records=1, Time=0ms)
SQL = 
select 	tdc.text
							from 	tbl_doc_categories tdc
							where 	tdc.doc_category_id = 12
							and		tdc.frame_id = 3362

qry_docs_num (Records=1, Time=16ms)
SQL = 
select 	Count(td.doc_id) 'count'
				from 	tbl_docs td
				where 	td.doc_category_id = 13
				and		td.frame_id = 3362

qry_cat_abstract (Records=1, Time=0ms)
SQL = 
select 	tdc.abstract
							from 	tbl_doc_categories tdc
							where 	tdc.doc_category_id = 13
							and		tdc.frame_id = 3362

qry_cat_text (Records=1, Time=0ms)
SQL = 
select 	tdc.text
							from 	tbl_doc_categories tdc
							where 	tdc.doc_category_id = 13
							and		tdc.frame_id = 3362

qry_docs_num (Records=1, Time=15ms)
SQL = 
select 	Count(td.doc_id) 'count'
				from 	tbl_docs td
				where 	td.doc_category_id = 14
				and		td.frame_id = 3362

qry_cat_abstract (Records=1, Time=0ms)
SQL = 
select 	tdc.abstract
							from 	tbl_doc_categories tdc
							where 	tdc.doc_category_id = 14
							and		tdc.frame_id = 3362

qry_cat_text (Records=1, Time=0ms)
SQL = 
select 	tdc.text
							from 	tbl_doc_categories tdc
							where 	tdc.doc_category_id = 14
							and		tdc.frame_id = 3362

get_site_id (Records=1, Time=0ms)
SQL = 
SELECT	 	site_id
	FROM	 	tbl_feature_usage
	WHERE	 	frame_id = 3375

get_frame_properties (Records=1, Time=0ms)
SQL = 
SELECT		tool_config
	FROM		tbl_feature_usage
	WHERE		frame_id = 3375
	AND			site_id = 'ftg'

qry_cat_list (Records=0, Time=0ms)
SQL = 
select 	tdc.name, 
				tdc.doc_category_id,
				tdc.doc_category_order_num,
				tdc.frame_id
		from 	tbl_docs td,
				tbl_doc_categories tdc
		where 	tdc.frame_id = 3375
		AND		tdc.status = 1
		AND		tdc.frame_id = td.frame_id
		and		td.doc_category_id in (select doc_category_id from tbl_doc_categories where frame_id = 3375)
		group by tdc.doc_category_id, tdc.name, tdc.doc_category_order_num, tdc.frame_id
		order by tdc.doc_category_order_num, tdc.name

get_children (Records=1, Time=47ms)
SQL = 
SELECT 	lable,
			url,
			frame_id
	FROM	tbl_feature_usage
	WHERE	parent_id = 3363
	
	AND		frame_id not in (3365,3367)
	
	AND		frame_id not in (3877)
	order by creation_date

nav (Records=11, Time=Cached Query)
SQL = 
SELECT DISTINCT 
					tfu.frame_id,
					tfu.lable,
					CASE
				    WHEN tfu.feature_id = null THEN tfu.url 
				    ELSE ts.root_url + tfu.url  
				   	END
				    AS  url,
					tfu.creation_date
		FROM		tbl_feature_usage tfu, tbl_sites ts
		WHERE		tfu.site_id = 'ftg'
		and			tfu.site_id = ts.site_id
		AND		tfu.hidden = 0
		AND		(
				frame_id in (3348)
				
		
		
		
			OR frame_id = (select parent_id
								from tbl_feature_usage
								where frame_id = 3354)
		
		
		
			OR parent_id = (select parent_id
								from tbl_feature_usage
								where frame_id = 3354)
		
		
		
			OR parent_id = 3354
		
		
		
			OR parent_id = (	SELECT parent_ID
								FROM	tbl_feature_usage
								WHERE	frame_id in (	SELECT	parent_id
														FROM	tbl_feature_usage
														WHERE	frame_id = 3354)
							)
		
		)
		ORDER BY	tfu.creation_date

get_children (Records=2, Time=31ms)
SQL = 
SELECT 	lable,
			url,
			frame_id
	FROM	tbl_feature_usage
	WHERE	parent_id = 3354
	AND		frame_id not in (3382)
	order by creation_date

get_site_id (Records=1, Time=0ms)
SQL = 
SELECT	 	site_id
	FROM	 	tbl_feature_usage
	WHERE	 	frame_id = 3354

get_frame_properties (Records=1, Time=0ms)
SQL = 
SELECT		tool_config
	FROM		tbl_feature_usage
	WHERE		frame_id = 3354
	AND			site_id = 'ftg'

qry_cat_list (Records=5, Time=16ms)
SQL = 
select 	tdc.name, 
				tdc.doc_category_id,
				tdc.doc_category_order_num,
				tdc.frame_id
		from 	tbl_docs td,
				tbl_doc_categories tdc
		where 	tdc.frame_id = 3354
		AND		tdc.status = 1
		AND		tdc.frame_id = td.frame_id
		and		td.doc_category_id in (select doc_category_id from tbl_doc_categories where frame_id = 3354)
		group by tdc.doc_category_id, tdc.name, tdc.doc_category_order_num, tdc.frame_id
		order by tdc.doc_category_order_num, tdc.name

qry_docs_num (Records=1, Time=15ms)
SQL = 
select 	Count(td.doc_id) 'count'
				from 	tbl_docs td
				where 	td.doc_category_id = 15
				and		td.frame_id = 3354

qry_cat_abstract (Records=1, Time=0ms)
SQL = 
select 	tdc.abstract
							from 	tbl_doc_categories tdc
							where 	tdc.doc_category_id = 15
							and		tdc.frame_id = 3354

qry_cat_text (Records=1, Time=0ms)
SQL = 
select 	tdc.text
							from 	tbl_doc_categories tdc
							where 	tdc.doc_category_id = 15
							and		tdc.frame_id = 3354

qry_docs_num (Records=1, Time=16ms)
SQL = 
select 	Count(td.doc_id) 'count'
				from 	tbl_docs td
				where 	td.doc_category_id = 16
				and		td.frame_id = 3354

qry_cat_abstract (Records=1, Time=0ms)
SQL = 
select 	tdc.abstract
							from 	tbl_doc_categories tdc
							where 	tdc.doc_category_id = 16
							and		tdc.frame_id = 3354

qry_cat_text (Records=1, Time=0ms)
SQL = 
select 	tdc.text
							from 	tbl_doc_categories tdc
							where 	tdc.doc_category_id = 16
							and		tdc.frame_id = 3354

qry_docs_num (Records=1, Time=16ms)
SQL = 
select 	Count(td.doc_id) 'count'
				from 	tbl_docs td
				where 	td.doc_category_id = 17
				and		td.frame_id = 3354

qry_cat_abstract (Records=1, Time=0ms)
SQL = 
select 	tdc.abstract
							from 	tbl_doc_categories tdc
							where 	tdc.doc_category_id = 17
							and		tdc.frame_id = 3354

qry_cat_text (Records=1, Time=0ms)
SQL = 
select 	tdc.text
							from 	tbl_doc_categories tdc
							where 	tdc.doc_category_id = 17
							and		tdc.frame_id = 3354

qry_docs_num (Records=1, Time=15ms)
SQL = 
select 	Count(td.doc_id) 'count'
				from 	tbl_docs td
				where 	td.doc_category_id = 18
				and		td.frame_id = 3354

qry_cat_abstract (Records=1, Time=16ms)
SQL = 
select 	tdc.abstract
							from 	tbl_doc_categories tdc
							where 	tdc.doc_category_id = 18
							and		tdc.frame_id = 3354

qry_cat_text (Records=1, Time=0ms)
SQL = 
select 	tdc.text
							from 	tbl_doc_categories tdc
							where 	tdc.doc_category_id = 18
							and		tdc.frame_id = 3354

qry_docs_num (Records=1, Time=0ms)
SQL = 
select 	Count(td.doc_id) 'count'
				from 	tbl_docs td
				where 	td.doc_category_id = 19
				and		td.frame_id = 3354

qry_cat_abstract (Records=1, Time=15ms)
SQL = 
select 	tdc.abstract
							from 	tbl_doc_categories tdc
							where 	tdc.doc_category_id = 19
							and		tdc.frame_id = 3354

qry_cat_text (Records=1, Time=0ms)
SQL = 
select 	tdc.text
							from 	tbl_doc_categories tdc
							where 	tdc.doc_category_id = 19
							and		tdc.frame_id = 3354

get_site_id (Records=1, Time=0ms)
SQL = 
SELECT	 	site_id
	FROM	 	tbl_feature_usage
	WHERE	 	frame_id = 3354

get_frame_properties (Records=1, Time=0ms)
SQL = 
SELECT		tool_config
	FROM		tbl_feature_usage
	WHERE		frame_id = 3354
	AND			site_id = 'ftg'

qry_cat_list (Records=5, Time=0ms)
SQL = 
select 	tdc.name, 
				tdc.doc_category_id,
				tdc.doc_category_order_num,
				tdc.frame_id
		from 	tbl_docs td,
				tbl_doc_categories tdc
		where 	tdc.frame_id = 3354
		AND		tdc.status = 1
		AND		tdc.frame_id = td.frame_id
		and		td.doc_category_id in (select doc_category_id from tbl_doc_categories where frame_id = 3354)
		group by tdc.doc_category_id, tdc.name, tdc.doc_category_order_num, tdc.frame_id
		order by tdc.doc_category_order_num, tdc.name

qry_docs_num (Records=1, Time=15ms)
SQL = 
select 	Count(td.doc_id) 'count'
				from 	tbl_docs td
				where 	td.doc_category_id = 15
				and		td.frame_id = 3354

qry_cat_abstract (Records=1, Time=0ms)
SQL = 
select 	tdc.abstract
							from 	tbl_doc_categories tdc
							where 	tdc.doc_category_id = 15
							and		tdc.frame_id = 3354

qry_cat_text (Records=1, Time=0ms)
SQL = 
select 	tdc.text
							from 	tbl_doc_categories tdc
							where 	tdc.doc_category_id = 15
							and		tdc.frame_id = 3354

qry_docs_num (Records=1, Time=0ms)
SQL = 
select 	Count(td.doc_id) 'count'
				from 	tbl_docs td
				where 	td.doc_category_id = 16
				and		td.frame_id = 3354

qry_cat_abstract (Records=1, Time=0ms)
SQL = 
select 	tdc.abstract
							from 	tbl_doc_categories tdc
							where 	tdc.doc_category_id = 16
							and		tdc.frame_id = 3354

qry_cat_text (Records=1, Time=16ms)
SQL = 
select 	tdc.text
							from 	tbl_doc_categories tdc
							where 	tdc.doc_category_id = 16
							and		tdc.frame_id = 3354

qry_docs_num (Records=1, Time=0ms)
SQL = 
select 	Count(td.doc_id) 'count'
				from 	tbl_docs td
				where 	td.doc_category_id = 17
				and		td.frame_id = 3354

qry_cat_abstract (Records=1, Time=0ms)
SQL = 
select 	tdc.abstract
							from 	tbl_doc_categories tdc
							where 	tdc.doc_category_id = 17
							and		tdc.frame_id = 3354

qry_cat_text (Records=1, Time=0ms)
SQL = 
select 	tdc.text
							from 	tbl_doc_categories tdc
							where 	tdc.doc_category_id = 17
							and		tdc.frame_id = 3354

qry_docs_num (Records=1, Time=16ms)
SQL = 
select 	Count(td.doc_id) 'count'
				from 	tbl_docs td
				where 	td.doc_category_id = 18
				and		td.frame_id = 3354

qry_cat_abstract (Records=1, Time=0ms)
SQL = 
select 	tdc.abstract
							from 	tbl_doc_categories tdc
							where 	tdc.doc_category_id = 18
							and		tdc.frame_id = 3354

qry_cat_text (Records=1, Time=0ms)
SQL = 
select 	tdc.text
							from 	tbl_doc_categories tdc
							where 	tdc.doc_category_id = 18
							and		tdc.frame_id = 3354

qry_docs_num (Records=1, Time=0ms)
SQL = 
select 	Count(td.doc_id) 'count'
				from 	tbl_docs td
				where 	td.doc_category_id = 19
				and		td.frame_id = 3354

qry_cat_abstract (Records=1, Time=0ms)
SQL = 
select 	tdc.abstract
							from 	tbl_doc_categories tdc
							where 	tdc.doc_category_id = 19
							and		tdc.frame_id = 3354

qry_cat_text (Records=1, Time=0ms)
SQL = 
select 	tdc.text
							from 	tbl_doc_categories tdc
							where 	tdc.doc_category_id = 19
							and		tdc.frame_id = 3354

2203 milliseconds

CGI Variables:

AUTH_PASSWORD=
AUTH_TYPE=
AUTH_USER=
CERT_COOKIE=
CERT_FLAGS=
CERT_ISSUER=
CERT_KEYSIZE=
CERT_SECRETKEYSIZE=
CERT_SERIALNUMBER=
CERT_SERVER_ISSUER=
CERT_SERVER_SUBJECT=
CERT_SUBJECT=
CF_TEMPLATE_PATH=\\file1\inetpub\wwwprod\orgitecture\wwwroot\ftg\news_keywords3354\news_keywords.htm
CONTENT_LENGTH=0
CONTENT_TYPE=
GATEWAY_INTERFACE=CGI/1.1
HTTP_ACCEPT=*/*
HTTP_ACCEPT_ENCODING=gzip
HTTP_ACCEPT_LANGUAGE=en-us
HTTP_COOKIE=CFID=14746256; CFTOKEN=35477524; CSS_SET_ID=1
HTTP_HOST=www.freetogrow.org
HTTP_REFERER=http://www.freetogrow.org/
HTTP_USER_AGENT=Mozilla/4.0 (compatible; MSIE 5.0; Windows 98)
HTTPS=off
HTTPS_KEYSIZE=
HTTPS_SECRETKEYSIZE=
HTTPS_SERVER_ISSUER=
HTTPS_SERVER_SUBJECT=
PATH_INFO=/news_keywords3354/news_keywords.htm
PATH_TRANSLATED=\\file1\inetpub\wwwprod\orgitecture\wwwroot\ftg\news_keywords3354\news_keywords.htm
QUERY_STRING=
REMOTE_ADDR=66.243.56.98
REMOTE_HOST=66.243.56.98
REMOTE_USER=
REQUEST_METHOD=GET
SCRIPT_NAME=/news_keywords3354/news_keywords.htm
SERVER_NAME=www.freetogrow.org
SERVER_PORT=80
SERVER_PORT_SECURE=0
SERVER_PROTOCOL=HTTP/1.0
SERVER_SOFTWARE=Microsoft-IIS/5.0
WEB_SERVER_API=ISAPI