>  Collaboration >  Establishing a Continuum of Care >  Policing >  Schools >  Child Protective Services >  Treatment Partnerships   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 Partners page. Here you will find resources and strategies that researchers and practitioners across the nation have identified as being effective at strengthening and engaging diverse community partners to support the healthy development of young children. In the Partners page, you can find information on assessing and improving your collaborative relationships, discover innovative strategies for improving relationships between residents and law enforcement officials, learn about developing dedicated treatment relationships, and explore ways to reduce the duplication of services to high-need families in your community. Linkages with community-based organizations has long been a hallmark of Head Start programs. While helping to reinforce these linkages, Free To Grow has added another dimension to community collaboration. Based on the conviction that community-level factors decisively influence individuals’ vulnerability to substance abuse and other high risk behaviors, Free To Grow creates new types of community partnerships that have the potential to make neighborhoods more protective environments for children and families. These partnerships, with groups like community development agencies, Alcohol Beverage Control agencies, and code enforcement officials, open up new terrain to early childhood programs like Head Start, and challenge them to think differently about how to solve some of the seemingly intractable problems of substance abuse, child abuse and domestic violence in their families and communities. The partnership strategies described in these pages are intended to support Free To Grow’s family and community strengthening efforts. For this reason, this page should be read along with our Family and Community pages. Click on any one of the strategy or resource pages to learn more. Collaboration Establishing a Continuum of Care Policing Schools Child Protective Services Treatment Partnerships
		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=16ms)
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 3361

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

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

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

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

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

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

get_frame_properties (Records=1, Time=15ms)
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=0ms)
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=0ms)
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=0ms)
SQL = 
select 	tdc.text
							from 	tbl_doc_categories tdc
							where 	tdc.doc_category_id = 9
							and		tdc.frame_id = 3361

687 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\pubs_keywords3361\pubs_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=/pubs_keywords3361/pubs_keywords.htm
PATH_TRANSLATED=\\file1\inetpub\wwwprod\orgitecture\wwwroot\ftg\pubs_keywords3361\pubs_keywords.htm
QUERY_STRING=
REMOTE_ADDR=66.243.56.98
REMOTE_HOST=66.243.56.98
REMOTE_USER=
REQUEST_METHOD=GET
SCRIPT_NAME=/pubs_keywords3361/pubs_keywords.htm
SERVER_NAME=www.freetogrow.org
SERVER_PORT=80
SERVER_PORT_SECURE=0
SERVER_PROTOCOL=HTTP/1.0
SERVER_SOFTWARE=Microsoft-IIS/6.0
WEB_SERVER_API=ISAPI