>  General Policy >  Trends to Watch >  Substance Abuse Prevention and Treatment Policy >  Head Start Policy >  Immigrant Policy >  Web Links   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		Welcome to our Policy Page. This is the place to locate information pertinent to public policy—the trends affecting our ability to act at the local, state and national level to improve the well-being of young children, strengthen families, prevent child abuse and promote substance-free communities. The types of information you can find here: The Policy Base: The dictionary defines policy as a “method of action selected from alternatives…to guide and determine present and future decisions.” Issues of policy are at the heart of designing and winning support for effective prevention programs. Part of the Free To Grow approach is to identify and employ those techniques that have been tested and found to improve the lives of at-risk children. In the Policy Page, you can read what practitioners, academics, and those concerned with the well-being of children are saying to lawmakers, peers, the media and opinion makers about how best to ensure that our children live in substance-free, violence-free families and communities now, and in the future. You can also access documents pertinent to state and national policy trends that impact the work of programs like Free To Grow. Links: This section of the page contains links to the websites of other organizations engaged in relevant prevention and policy activities. Featured Policy Documents Immigrant Rights to Public Benefits General Policy Trends to Watch Substance Abuse Prevention and Treatment Policy Head Start Policy Immigrant Policy Web Links
		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 3812

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

qry_get_text (Records=1, Time=16ms)
SQL = 
sp_get_text 3812

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

get_featured_to_P_docs (Records=1, Time=16ms)
SQL = 
SELECT 		td.doc_id,
				td.char_1,
				td.char_4,
				td.text_1,
				td.text_2,
				td.frame_id		
	FROM 		tbl_docs td, tbl_doc_has_attrib tdha
	WHERE 		td.doc_id=tdha.doc_id
	AND			tdha.attrib_id=7427
	AND			td.frame_id=3812
	ORDER BY 	td.creation_date desc

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

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=16ms)
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=16ms)
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=15ms)
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=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=0ms)
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=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

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=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 = 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=0ms)
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=15ms)
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=0ms)
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=0ms)
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=0ms)
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=16ms)
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=0ms)
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=15ms)
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=15ms)
SQL = 
SELECT	 	site_id
	FROM	 	tbl_feature_usage
	WHERE	 	frame_id = 3360

get_frame_properties (Records=1, Time=0ms)
SQL = 
SELECT		tool_config
	FROM		tbl_feature_usage
	WHERE		frame_id = 3360
	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 = 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=15ms)
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=0ms)
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=15ms)
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=0ms)
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=16ms)
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=0ms)
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 = 3362

get_frame_properties (Records=1, Time=15ms)
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=0ms)
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=16ms)
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=0ms)
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=15ms)
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=16ms)
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=0ms)
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=15ms)
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=16ms)
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=16ms)
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=16ms)
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 = 3812)
		
		
		
			OR parent_id = (select parent_id
								from tbl_feature_usage
								where frame_id = 3812)
		
		
		
			OR parent_id = 3812
		
		
		
			OR parent_id = (	SELECT parent_ID
								FROM	tbl_feature_usage
								WHERE	frame_id in (	SELECT	parent_id
														FROM	tbl_feature_usage
														WHERE	frame_id = 3812)
							)
		
		)
		ORDER BY	tfu.creation_date

get_site_id (Records=1, Time=16ms)
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=15ms)
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=0ms)
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=0ms)
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=16ms)
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=15ms)
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=16ms)
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=0ms)
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=16ms)
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=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=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 = 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=31ms)
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=0ms)
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=16ms)
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=0ms)
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=0ms)
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=15ms)
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=0ms)
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=16ms)
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

1812 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_keywords3812\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_keywords3812/news_keywords.htm
PATH_TRANSLATED=\\file1\inetpub\wwwprod\orgitecture\wwwroot\ftg\news_keywords3812\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_keywords3812/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