>  Family >  Partners >  Community >  Web Links >  General   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 Research Page. Here you will find summaries of research related to the comprehensive strategies that underlie the Free To Grow approach. Free To Grow realizes that researchers and practitioners often work on parallel, rather than intersecting tracks, making it difficult for prevention practitioners, community residents, journalists and policy makers to learn about the successful application of relevant research. To help address this situation, Free to Grow has compiled a research base of "best and promising practices" that you can find in our Research Page. The Free to Grow approach rests on a solid research base showing that: Strengthening families and communities can improve results for children. Outcomes for children are affected both by the quality of the home environment and the ways that communities and families interact. Multi-faceted early intervention techniques hold promise for reducing the risk of substance abuse and other high-risk behaviors . The types of information you can find here: The Research Base: This section of the page contains studies that expand knowledge about the interaction of children, families and communities, with an emphasis on the factors that make them more resilient and less vulnerable to the adverse effects of substance abuse, child abuse and other high risk behaviors. Links: This section of the page contains links to the websites of other organizations engaged in relevant prevention and policy activities. Family Case Management Child Abuse Prevention Early Childhood Development Family Assessment Family Support Parent Education Substance Abuse and Mental Health Treatment Partners Child Protective Services Collaboration Policing Schools Community Community Action Community Assessment Community Awareness Immigration Leadership Development Policy Change Web Links Website Links General General Prevention Policy Prevention Theory
		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=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

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

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

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 3359

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

qry_research_areas (Records=21, Time=47ms)
SQL = 
select DISTINCT td.char_3,
		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

	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, char_3

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

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

qry_cat_description (Records=1, Time=375ms)
SQL = 
SELECT	td.doc_id,
					td.text_1
			FROM 	tbl_docs td,
					tbl_doc_has_attrib tdha
			WHERE 	td.frame_id = 3359
			AND		td.char_3 = 'Case Management'
			AND		td.doc_id = tdha.doc_id
			AND		tdha.attrib_id = 5598
			AND 	td.active = 1
			ORDER BY creation_date DESC

qry_site_frames (Records=1, Time=0ms)
SQL = 
SELECT	frame_id
	FROM	tbl_feature_usage
	WHERE	site_id = ? 
	AND		frame_id IN (?)

Query Parameter Value(s) -
Parameter #1 = ftg
Parameter #2 = 3359

qry_object_type (Records=1, Time=16ms)
SQL = 
SELECT base_table, id_column, attrib_key_table, attachment_key_table
			FROM tbl_object_types
			WHERE object_type_id = ?

Query Parameter Value(s) -
Parameter #1 = 2

qry_access_object (Records=1, Time=0ms)
SQL = 
sp_access_obj_doc '118343', '3359', 0, 0

qry_object_owner (Records=1, Time=0ms)
SQL = 
SELECT user_id
			FROM	tbl_docs
			WHERE	doc_id = 118343

qry_get_attachment (Records=1, Time=0ms)
SQL = 
SELECT	doc_attachment, doc_image
			FROM tbl_feature_usage
			WHERE FRAME_ID = 3359
			AND site_id = 'ftg'

qry_cat_description (Records=1, Time=766ms)
SQL = 
SELECT	td.doc_id,
					td.text_1
			FROM 	tbl_docs td,
					tbl_doc_has_attrib tdha
			WHERE 	td.frame_id = 3359
			AND		td.char_3 = 'Child Abuse Prevention'
			AND		td.doc_id = tdha.doc_id
			AND		tdha.attrib_id = 5598
			AND 	td.active = 1
			ORDER BY creation_date DESC

qry_site_frames (Records=1, Time=0ms)
SQL = 
SELECT	frame_id
	FROM	tbl_feature_usage
	WHERE	site_id = ? 
	AND		frame_id IN (?)

Query Parameter Value(s) -
Parameter #1 = ftg
Parameter #2 = 3359

qry_access_object (Records=1, Time=16ms)
SQL = 
sp_access_obj_doc '118624', '3359', 0, 0

qry_object_owner (Records=1, Time=0ms)
SQL = 
SELECT user_id
			FROM	tbl_docs
			WHERE	doc_id = 118624

qry_get_attachment (Records=1, Time=0ms)
SQL = 
SELECT	doc_attachment, doc_image
			FROM tbl_feature_usage
			WHERE FRAME_ID = 3359
			AND site_id = 'ftg'

qry_cat_description (Records=1, Time=1000ms)
SQL = 
SELECT	td.doc_id,
					td.text_1
			FROM 	tbl_docs td,
					tbl_doc_has_attrib tdha
			WHERE 	td.frame_id = 3359
			AND		td.char_3 = 'Early Childhood Development'
			AND		td.doc_id = tdha.doc_id
			AND		tdha.attrib_id = 5598
			AND 	td.active = 1
			ORDER BY creation_date DESC

qry_site_frames (Records=1, Time=0ms)
SQL = 
SELECT	frame_id
	FROM	tbl_feature_usage
	WHERE	site_id = ? 
	AND		frame_id IN (?)

Query Parameter Value(s) -
Parameter #1 = ftg
Parameter #2 = 3359

qry_access_object (Records=1, Time=15ms)
SQL = 
sp_access_obj_doc '118625', '3359', 0, 0

qry_object_owner (Records=1, Time=0ms)
SQL = 
SELECT user_id
			FROM	tbl_docs
			WHERE	doc_id = 118625

qry_get_attachment (Records=1, Time=0ms)
SQL = 
SELECT	doc_attachment, doc_image
			FROM tbl_feature_usage
			WHERE FRAME_ID = 3359
			AND site_id = 'ftg'

qry_cat_description (Records=1, Time=16ms)
SQL = 
SELECT	td.doc_id,
					td.text_1
			FROM 	tbl_docs td,
					tbl_doc_has_attrib tdha
			WHERE 	td.frame_id = 3359
			AND		td.char_3 = 'Family Assessment'
			AND		td.doc_id = tdha.doc_id
			AND		tdha.attrib_id = 5598
			AND 	td.active = 1
			ORDER BY creation_date DESC

qry_site_frames (Records=1, Time=0ms)
SQL = 
SELECT	frame_id
	FROM	tbl_feature_usage
	WHERE	site_id = ? 
	AND		frame_id IN (?)

Query Parameter Value(s) -
Parameter #1 = ftg
Parameter #2 = 3359

qry_access_object (Records=1, Time=0ms)
SQL = 
sp_access_obj_doc '118341', '3359', 0, 0

qry_object_owner (Records=1, Time=0ms)
SQL = 
SELECT user_id
			FROM	tbl_docs
			WHERE	doc_id = 118341

qry_get_attachment (Records=1, Time=0ms)
SQL = 
SELECT	doc_attachment, doc_image
			FROM tbl_feature_usage
			WHERE FRAME_ID = 3359
			AND site_id = 'ftg'

qry_cat_description (Records=1, Time=15ms)
SQL = 
SELECT	td.doc_id,
					td.text_1
			FROM 	tbl_docs td,
					tbl_doc_has_attrib tdha
			WHERE 	td.frame_id = 3359
			AND		td.char_3 = 'Family Support'
			AND		td.doc_id = tdha.doc_id
			AND		tdha.attrib_id = 5598
			AND 	td.active = 1
			ORDER BY creation_date DESC

qry_site_frames (Records=1, Time=15ms)
SQL = 
SELECT	frame_id
	FROM	tbl_feature_usage
	WHERE	site_id = ? 
	AND		frame_id IN (?)

Query Parameter Value(s) -
Parameter #1 = ftg
Parameter #2 = 3359

qry_access_object (Records=1, Time=47ms)
SQL = 
sp_access_obj_doc '118342', '3359', 0, 0

qry_object_owner (Records=1, Time=0ms)
SQL = 
SELECT user_id
			FROM	tbl_docs
			WHERE	doc_id = 118342

qry_get_attachment (Records=1, Time=0ms)
SQL = 
SELECT	doc_attachment, doc_image
			FROM tbl_feature_usage
			WHERE FRAME_ID = 3359
			AND site_id = 'ftg'

qry_cat_description (Records=1, Time=31ms)
SQL = 
SELECT	td.doc_id,
					td.text_1
			FROM 	tbl_docs td,
					tbl_doc_has_attrib tdha
			WHERE 	td.frame_id = 3359
			AND		td.char_3 = 'Parent Education'
			AND		td.doc_id = tdha.doc_id
			AND		tdha.attrib_id = 5598
			AND 	td.active = 1
			ORDER BY creation_date DESC

qry_site_frames (Records=1, Time=0ms)
SQL = 
SELECT	frame_id
	FROM	tbl_feature_usage
	WHERE	site_id = ? 
	AND		frame_id IN (?)

Query Parameter Value(s) -
Parameter #1 = ftg
Parameter #2 = 3359

qry_access_object (Records=1, Time=0ms)
SQL = 
sp_access_obj_doc '118345', '3359', 0, 0

qry_object_owner (Records=1, Time=0ms)
SQL = 
SELECT user_id
			FROM	tbl_docs
			WHERE	doc_id = 118345

qry_get_attachment (Records=1, Time=0ms)
SQL = 
SELECT	doc_attachment, doc_image
			FROM tbl_feature_usage
			WHERE FRAME_ID = 3359
			AND site_id = 'ftg'

qry_cat_description (Records=1, Time=16ms)
SQL = 
SELECT	td.doc_id,
					td.text_1
			FROM 	tbl_docs td,
					tbl_doc_has_attrib tdha
			WHERE 	td.frame_id = 3359
			AND		td.char_3 = 'Substance Abuse and Mental Health Treatment'
			AND		td.doc_id = tdha.doc_id
			AND		tdha.attrib_id = 5598
			AND 	td.active = 1
			ORDER BY creation_date DESC

qry_site_frames (Records=1, Time=0ms)
SQL = 
SELECT	frame_id
	FROM	tbl_feature_usage
	WHERE	site_id = ? 
	AND		frame_id IN (?)

Query Parameter Value(s) -
Parameter #1 = ftg
Parameter #2 = 3359

qry_access_object (Records=1, Time=15ms)
SQL = 
sp_access_obj_doc '118346', '3359', 0, 0

qry_object_owner (Records=1, Time=0ms)
SQL = 
SELECT user_id
			FROM	tbl_docs
			WHERE	doc_id = 118346

qry_get_attachment (Records=1, Time=16ms)
SQL = 
SELECT	doc_attachment, doc_image
			FROM tbl_feature_usage
			WHERE FRAME_ID = 3359
			AND site_id = 'ftg'

qry_cat_description (Records=0, Time=31ms)
SQL = 
SELECT	td.doc_id,
					td.text_1
			FROM 	tbl_docs td,
					tbl_doc_has_attrib tdha
			WHERE 	td.frame_id = 3359
			AND		td.char_3 = 'Child Protective Services'
			AND		td.doc_id = tdha.doc_id
			AND		tdha.attrib_id = 5598
			AND 	td.active = 1
			ORDER BY creation_date DESC

qry_cat_description (Records=1, Time=16ms)
SQL = 
SELECT	td.doc_id,
					td.text_1
			FROM 	tbl_docs td,
					tbl_doc_has_attrib tdha
			WHERE 	td.frame_id = 3359
			AND		td.char_3 = 'Collaboration'
			AND		td.doc_id = tdha.doc_id
			AND		tdha.attrib_id = 5598
			AND 	td.active = 1
			ORDER BY creation_date DESC

qry_site_frames (Records=1, Time=0ms)
SQL = 
SELECT	frame_id
	FROM	tbl_feature_usage
	WHERE	site_id = ? 
	AND		frame_id IN (?)

Query Parameter Value(s) -
Parameter #1 = ftg
Parameter #2 = 3359

qry_access_object (Records=1, Time=0ms)
SQL = 
sp_access_obj_doc '118349', '3359', 0, 0

qry_object_owner (Records=1, Time=0ms)
SQL = 
SELECT user_id
			FROM	tbl_docs
			WHERE	doc_id = 118349

qry_get_attachment (Records=1, Time=0ms)
SQL = 
SELECT	doc_attachment, doc_image
			FROM tbl_feature_usage
			WHERE FRAME_ID = 3359
			AND site_id = 'ftg'

qry_cat_description (Records=0, Time=15ms)
SQL = 
SELECT	td.doc_id,
					td.text_1
			FROM 	tbl_docs td,
					tbl_doc_has_attrib tdha
			WHERE 	td.frame_id = 3359
			AND		td.char_3 = 'Policing'
			AND		td.doc_id = tdha.doc_id
			AND		tdha.attrib_id = 5598
			AND 	td.active = 1
			ORDER BY creation_date DESC

qry_cat_description (Records=0, Time=16ms)
SQL = 
SELECT	td.doc_id,
					td.text_1
			FROM 	tbl_docs td,
					tbl_doc_has_attrib tdha
			WHERE 	td.frame_id = 3359
			AND		td.char_3 = 'Schools'
			AND		td.doc_id = tdha.doc_id
			AND		tdha.attrib_id = 5598
			AND 	td.active = 1
			ORDER BY creation_date DESC

qry_cat_description (Records=1, Time=16ms)
SQL = 
SELECT	td.doc_id,
					td.text_1
			FROM 	tbl_docs td,
					tbl_doc_has_attrib tdha
			WHERE 	td.frame_id = 3359
			AND		td.char_3 = 'Community Action'
			AND		td.doc_id = tdha.doc_id
			AND		tdha.attrib_id = 5598
			AND 	td.active = 1
			ORDER BY creation_date DESC

qry_site_frames (Records=1, Time=0ms)
SQL = 
SELECT	frame_id
	FROM	tbl_feature_usage
	WHERE	site_id = ? 
	AND		frame_id IN (?)

Query Parameter Value(s) -
Parameter #1 = ftg
Parameter #2 = 3359

qry_access_object (Records=1, Time=16ms)
SQL = 
sp_access_obj_doc '118352', '3359', 0, 0

qry_object_owner (Records=1, Time=0ms)
SQL = 
SELECT user_id
			FROM	tbl_docs
			WHERE	doc_id = 118352

qry_get_attachment (Records=1, Time=0ms)
SQL = 
SELECT	doc_attachment, doc_image
			FROM tbl_feature_usage
			WHERE FRAME_ID = 3359
			AND site_id = 'ftg'

qry_cat_description (Records=1, Time=31ms)
SQL = 
SELECT	td.doc_id,
					td.text_1
			FROM 	tbl_docs td,
					tbl_doc_has_attrib tdha
			WHERE 	td.frame_id = 3359
			AND		td.char_3 = 'Community Assessment'
			AND		td.doc_id = tdha.doc_id
			AND		tdha.attrib_id = 5598
			AND 	td.active = 1
			ORDER BY creation_date DESC

qry_site_frames (Records=1, Time=0ms)
SQL = 
SELECT	frame_id
	FROM	tbl_feature_usage
	WHERE	site_id = ? 
	AND		frame_id IN (?)

Query Parameter Value(s) -
Parameter #1 = ftg
Parameter #2 = 3359

qry_access_object (Records=1, Time=16ms)
SQL = 
sp_access_obj_doc '118348', '3359', 0, 0

qry_object_owner (Records=1, Time=0ms)
SQL = 
SELECT user_id
			FROM	tbl_docs
			WHERE	doc_id = 118348

qry_get_attachment (Records=1, Time=15ms)
SQL = 
SELECT	doc_attachment, doc_image
			FROM tbl_feature_usage
			WHERE FRAME_ID = 3359
			AND site_id = 'ftg'

qry_cat_description (Records=1, Time=16ms)
SQL = 
SELECT	td.doc_id,
					td.text_1
			FROM 	tbl_docs td,
					tbl_doc_has_attrib tdha
			WHERE 	td.frame_id = 3359
			AND		td.char_3 = 'Community Awareness'
			AND		td.doc_id = tdha.doc_id
			AND		tdha.attrib_id = 5598
			AND 	td.active = 1
			ORDER BY creation_date DESC

qry_site_frames (Records=1, Time=0ms)
SQL = 
SELECT	frame_id
	FROM	tbl_feature_usage
	WHERE	site_id = ? 
	AND		frame_id IN (?)

Query Parameter Value(s) -
Parameter #1 = ftg
Parameter #2 = 3359

qry_access_object (Records=1, Time=0ms)
SQL = 
sp_access_obj_doc '118626', '3359', 0, 0

qry_object_owner (Records=1, Time=0ms)
SQL = 
SELECT user_id
			FROM	tbl_docs
			WHERE	doc_id = 118626

qry_get_attachment (Records=1, Time=0ms)
SQL = 
SELECT	doc_attachment, doc_image
			FROM tbl_feature_usage
			WHERE FRAME_ID = 3359
			AND site_id = 'ftg'

qry_cat_description (Records=0, Time=16ms)
SQL = 
SELECT	td.doc_id,
					td.text_1
			FROM 	tbl_docs td,
					tbl_doc_has_attrib tdha
			WHERE 	td.frame_id = 3359
			AND		td.char_3 = 'Immigration'
			AND		td.doc_id = tdha.doc_id
			AND		tdha.attrib_id = 5598
			AND 	td.active = 1
			ORDER BY creation_date DESC

qry_cat_description (Records=1, Time=16ms)
SQL = 
SELECT	td.doc_id,
					td.text_1
			FROM 	tbl_docs td,
					tbl_doc_has_attrib tdha
			WHERE 	td.frame_id = 3359
			AND		td.char_3 = 'Leadership Development'
			AND		td.doc_id = tdha.doc_id
			AND		tdha.attrib_id = 5598
			AND 	td.active = 1
			ORDER BY creation_date DESC

qry_site_frames (Records=1, Time=0ms)
SQL = 
SELECT	frame_id
	FROM	tbl_feature_usage
	WHERE	site_id = ? 
	AND		frame_id IN (?)

Query Parameter Value(s) -
Parameter #1 = ftg
Parameter #2 = 3359

qry_access_object (Records=1, Time=16ms)
SQL = 
sp_access_obj_doc '118351', '3359', 0, 0

qry_object_owner (Records=1, Time=0ms)
SQL = 
SELECT user_id
			FROM	tbl_docs
			WHERE	doc_id = 118351

qry_get_attachment (Records=1, Time=0ms)
SQL = 
SELECT	doc_attachment, doc_image
			FROM tbl_feature_usage
			WHERE FRAME_ID = 3359
			AND site_id = 'ftg'

qry_cat_description (Records=1, Time=15ms)
SQL = 
SELECT	td.doc_id,
					td.text_1
			FROM 	tbl_docs td,
					tbl_doc_has_attrib tdha
			WHERE 	td.frame_id = 3359
			AND		td.char_3 = 'Policy Change'
			AND		td.doc_id = tdha.doc_id
			AND		tdha.attrib_id = 5598
			AND 	td.active = 1
			ORDER BY creation_date DESC

qry_site_frames (Records=1, Time=0ms)
SQL = 
SELECT	frame_id
	FROM	tbl_feature_usage
	WHERE	site_id = ? 
	AND		frame_id IN (?)

Query Parameter Value(s) -
Parameter #1 = ftg
Parameter #2 = 3359

qry_access_object (Records=1, Time=16ms)
SQL = 
sp_access_obj_doc '118353', '3359', 0, 0

qry_object_owner (Records=1, Time=0ms)
SQL = 
SELECT user_id
			FROM	tbl_docs
			WHERE	doc_id = 118353

qry_get_attachment (Records=1, Time=0ms)
SQL = 
SELECT	doc_attachment, doc_image
			FROM tbl_feature_usage
			WHERE FRAME_ID = 3359
			AND site_id = 'ftg'

qry_cat_description (Records=0, Time=15ms)
SQL = 
SELECT	td.doc_id,
					td.text_1
			FROM 	tbl_docs td,
					tbl_doc_has_attrib tdha
			WHERE 	td.frame_id = 3359
			AND		td.char_3 = 'Website Links'
			AND		td.doc_id = tdha.doc_id
			AND		tdha.attrib_id = 5598
			AND 	td.active = 1
			ORDER BY creation_date DESC

qry_cat_description (Records=0, Time=16ms)
SQL = 
SELECT	td.doc_id,
					td.text_1
			FROM 	tbl_docs td,
					tbl_doc_has_attrib tdha
			WHERE 	td.frame_id = 3359
			AND		td.char_3 = 'General'
			AND		td.doc_id = tdha.doc_id
			AND		tdha.attrib_id = 5598
			AND 	td.active = 1
			ORDER BY creation_date DESC

qry_cat_description (Records=1, Time=16ms)
SQL = 
SELECT	td.doc_id,
					td.text_1
			FROM 	tbl_docs td,
					tbl_doc_has_attrib tdha
			WHERE 	td.frame_id = 3359
			AND		td.char_3 = 'Prevention Policy'
			AND		td.doc_id = tdha.doc_id
			AND		tdha.attrib_id = 5598
			AND 	td.active = 1
			ORDER BY creation_date DESC

qry_site_frames (Records=1, Time=0ms)
SQL = 
SELECT	frame_id
	FROM	tbl_feature_usage
	WHERE	site_id = ? 
	AND		frame_id IN (?)

Query Parameter Value(s) -
Parameter #1 = ftg
Parameter #2 = 3359

qry_access_object (Records=1, Time=15ms)
SQL = 
sp_access_obj_doc '118337', '3359', 0, 0

qry_object_owner (Records=1, Time=0ms)
SQL = 
SELECT user_id
			FROM	tbl_docs
			WHERE	doc_id = 118337

qry_get_attachment (Records=1, Time=0ms)
SQL = 
SELECT	doc_attachment, doc_image
			FROM tbl_feature_usage
			WHERE FRAME_ID = 3359
			AND site_id = 'ftg'

qry_cat_description (Records=1, Time=32ms)
SQL = 
SELECT	td.doc_id,
					td.text_1
			FROM 	tbl_docs td,
					tbl_doc_has_attrib tdha
			WHERE 	td.frame_id = 3359
			AND		td.char_3 = 'Prevention Theory'
			AND		td.doc_id = tdha.doc_id
			AND		tdha.attrib_id = 5598
			AND 	td.active = 1
			ORDER BY creation_date DESC

qry_site_frames (Records=1, Time=0ms)
SQL = 
SELECT	frame_id
	FROM	tbl_feature_usage
	WHERE	site_id = ? 
	AND		frame_id IN (?)

Query Parameter Value(s) -
Parameter #1 = ftg
Parameter #2 = 3359

qry_access_object (Records=1, Time=0ms)
SQL = 
sp_access_obj_doc '118336', '3359', 0, 0

qry_object_owner (Records=1, Time=16ms)
SQL = 
SELECT user_id
			FROM	tbl_docs
			WHERE	doc_id = 118336

qry_get_attachment (Records=1, Time=0ms)
SQL = 
SELECT	doc_attachment, doc_image
			FROM tbl_feature_usage
			WHERE FRAME_ID = 3359
			AND site_id = 'ftg'

5062 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_keywords3359\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_keywords3359/news_keywords.htm
PATH_TRANSLATED=\\file1\inetpub\wwwprod\orgitecture\wwwroot\ftg\news_keywords3359\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_keywords3359/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