select count(*) count,industry_name,t_industry.industry_id,t_company_survey_question.question_type
from t_industry,t_company_industry,t_company_survey,t_company_survey_question
where t_industry.industry_id=t_company_industry.industry_id
and t_company_industry.company_id=t_company_survey.company_id 
and t_company_survey.response_id=t_company_survey_question.response_id 
and t_industry.active=1
and t_company_survey.active=1
group by industry_name,t_industry.industry_id,t_company_survey_question.question_type
order by industry_name

					SELECT categorytitle,storefront_categories.storefrontcategory_id
					from channels,storefront_categories
					WHERE channels.ch_id=storefront_categories.ch_id
					and storefront_categories.ch_id=345
					order by categorytitle

	SELECT distinct categorytitle,company,storefronts.storefront_id,shortcodescript,ORDERS,
	showcase,storefront_categories.storefrontcategory_id
	FROM storefronts,relate_storefront_ind,storefront_categories
	WHERE storefronts.storefront_id=relate_storefront_ind.storefront_id
	AND storefront_categories.storefrontcategory_id=relate_storefront_ind.storefrontcategory_id
	AND ch_id=345
	AND featured=1
	and relate_storefront_ind.storefrontcategory_id=1506
	order by ORDERS         
	

	SELECT distinct categorytitle,company,storefronts.storefront_id,shortcodescript,ORDERS,
	showcase,storefront_categories.storefrontcategory_id
	FROM storefronts,relate_storefront_ind,storefront_categories
	WHERE storefronts.storefront_id=relate_storefront_ind.storefront_id
	AND storefront_categories.storefrontcategory_id=relate_storefront_ind.storefrontcategory_id
	AND ch_id=345
	AND featured=1
	and relate_storefront_ind.storefrontcategory_id=1464
	order by ORDERS         
	

	SELECT distinct categorytitle,company,storefronts.storefront_id,shortcodescript,ORDERS,
	showcase,storefront_categories.storefrontcategory_id
	FROM storefronts,relate_storefront_ind,storefront_categories
	WHERE storefronts.storefront_id=relate_storefront_ind.storefront_id
	AND storefront_categories.storefrontcategory_id=relate_storefront_ind.storefrontcategory_id
	AND ch_id=345
	AND featured=1
	and relate_storefront_ind.storefrontcategory_id=1507
	order by ORDERS         
	

	SELECT distinct categorytitle,company,storefronts.storefront_id,shortcodescript,ORDERS,
	showcase,storefront_categories.storefrontcategory_id
	FROM storefronts,relate_storefront_ind,storefront_categories
	WHERE storefronts.storefront_id=relate_storefront_ind.storefront_id
	AND storefront_categories.storefrontcategory_id=relate_storefront_ind.storefrontcategory_id
	AND ch_id=345
	AND featured=1
	and relate_storefront_ind.storefrontcategory_id=1470
	order by ORDERS         
	

	SELECT distinct categorytitle,company,storefronts.storefront_id,shortcodescript,ORDERS,
	showcase,storefront_categories.storefrontcategory_id
	FROM storefronts,relate_storefront_ind,storefront_categories
	WHERE storefronts.storefront_id=relate_storefront_ind.storefront_id
	AND storefront_categories.storefrontcategory_id=relate_storefront_ind.storefrontcategory_id
	AND ch_id=345
	AND featured=1
	and relate_storefront_ind.storefrontcategory_id=1467
	order by ORDERS         
	

	SELECT distinct categorytitle,company,storefronts.storefront_id,shortcodescript,ORDERS,
	showcase,storefront_categories.storefrontcategory_id
	FROM storefronts,relate_storefront_ind,storefront_categories
	WHERE storefronts.storefront_id=relate_storefront_ind.storefront_id
	AND storefront_categories.storefrontcategory_id=relate_storefront_ind.storefrontcategory_id
	AND ch_id=345
	AND featured=1
	and relate_storefront_ind.storefrontcategory_id=1471
	order by ORDERS         
	

	SELECT distinct categorytitle,company,storefronts.storefront_id,shortcodescript,ORDERS,
	showcase,storefront_categories.storefrontcategory_id
	FROM storefronts,relate_storefront_ind,storefront_categories
	WHERE storefronts.storefront_id=relate_storefront_ind.storefront_id
	AND storefront_categories.storefrontcategory_id=relate_storefront_ind.storefrontcategory_id
	AND ch_id=345
	AND featured=1
	and relate_storefront_ind.storefrontcategory_id=1404
	order by ORDERS         
	

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=E:\Inetpub\wwwroot\tvspy\empsurvey\category_list.cfm
CONTENT_LENGTH=
CONTENT_TYPE=
CONTEXT_PATH=
GATEWAY_INTERFACE=CGI/1.1
HTTPS=off
HTTPS_KEYSIZE=
HTTPS_SECRETKEYSIZE=
HTTPS_SERVER_ISSUER=
HTTPS_SERVER_SUBJECT=
HTTP_ACCEPT=text/xml,application/xhtml+xml,text/html;q=0.9,text/plain;q=0.8,image/png,*/*;q=0.5
HTTP_ACCEPT_ENCODING=gzip
HTTP_ACCEPT_LANGUAGE=en-us,en;q=0.5
HTTP_CONNECTION=Keep-Alive
HTTP_COOKIE=CFID=62124984; CFTOKEN=92153754; JSESSIONID=9c304992ed80G$0C$CE$; CFGLOBALS=urltoken%3DCFID%23%3D62124984%26CFTOKEN%23%3D92153754%23lastvisit%3D%7Bts%20%272010%2D02%2D09%2006%3A43%3A26%27%7D%23timecreated%3D%7Bts%20%272010%2D02%2D09%2006%3A37%3A07%27%7D%23hitcount%3D21%23cftoken%3D92153754%23cfid%3D62124984%23; NSC_uwtqz.dpn=ffffffffd2d89a0f45525d5f4f58455e445a4a423660
HTTP_HOST=www.tvspy.com
HTTP_REFERER=
HTTP_USER_AGENT=CCBot/1.0 (+http://www.commoncrawl.org/bot.html)
PATH_INFO=/empsurvey/category_list.cfm
PATH_TRANSLATED=E:\Inetpub\wwwroot\tvspy\empsurvey\category_list.cfm
QUERY_STRING=
REMOTE_ADDR=209.208.132.227
REMOTE_HOST=209.208.132.227
REMOTE_USER=
REQUEST_METHOD=GET
SCRIPT_NAME=/empsurvey/category_list.cfm
SERVER_NAME=www.tvspy.com
SERVER_PORT=80
SERVER_PORT_SECURE=0
SERVER_PROTOCOL=HTTP/1.1
SERVER_SOFTWARE=Microsoft-IIS/6.0
WEB_SERVER_API=

Client Variables:
cfid=62124984
cftoken=92153754
hitcount=21
lastvisit={ts '2010-02-09 06:43:26'}
timecreated={ts '2010-02-09 06:37:07'}
urltoken=CFID=62124984&CFTOKEN=92153754

Cookie Variables:
CFGLOBALS=urltoken=CFID#=62124984&CFTOKEN#=92153754#lastvisit={ts '2010-02-09 06:43:26'}#timecreated={ts '2010-02-09 06:37:07'}#hitcount=21#cftoken=92153754#cfid=62124984#
CFID=62124984
CFTOKEN=92153754
JSESSIONID=9c304992ed80G$0C$CE$
NSC_uwtqz.dpn=ffffffffd2d89a0f45525d5f4f58455e445a4a423660

Session Variables:
auth=0
cfid=62124984
cftoken=92153754
gotopath=/membership/join2.cfm?update=1
sessionid=TVSPYNEW_62124984_92153754
urltoken=CFID=62124984&CFTOKEN=92153754