Audiology

	    Error processing CFX custom tag CFX_GIFGD.
	    

	    Error processing CFX custom tag CFX_GIFGD.
	    

	SELECT name, value FROM config
	WHERE
		
		host = 'remote' OR host = '' OR host is null
		

SELECT id, description FROM code WHERE name = 'content_language' ORDER BY orderby

		Select IsTraineeSitePage
		From page
		Where page.page_id = ? 

SELECT page.page_id, page.page_section, page.page_title, page.hide_search, page.hide_navigation,
	page.owner, page.template, page.browser_title, page.meta_description, page.page_filename,
	CASE WHEN ggparent.page_id IS NOT NULL THEN ggparent.page_title
		WHEN gparent.page_id IS NOT NULL THEN gparent.page_title
		WHEN parent.page_id IS NOT NULL THEN parent.page_title
		ELSE page.page_title END AS section_name,
	CASE WHEN ggparent.page_id IS NOT NULL THEN ggparent.page_id
		WHEN gparent.page_id IS NOT NULL THEN gparent.page_id
		WHEN parent.page_id IS NOT NULL THEN parent.page_id
		ELSE page.page_id END AS section_id,
	CASE WHEN ggparent.page_id IS NOT NULL THEN URL('',ggparent.page_filename,ggparent.page_id)
		WHEN gparent.page_id IS NOT NULL THEN URL('',gparent.page_filename,gparent.page_id)
		WHEN parent.page_id IS NOT NULL THEN URL('',parent.page_filename,parent.page_id)
		ELSE URL('',page.page_filename,page.page_id) END AS section_filename,
	CASE WHEN page.header_image IS NOT NULL THEN page.header_image
		WHEN parent.header_image IS NOT NULL THEN parent.header_image
		WHEN gparent.header_image IS NOT NULL THEN gparent.header_image
		ELSE ggparent.header_image END AS header_image,
	gparent.page_title AS gparent_name, gparent.page_id AS gparent_id,
	gparent.page_filename AS gparent_filename,
	parent.page_title AS parent_name, parent.page_id AS parent_id,
	parent.page_filename AS parent_filename
FROM page LEFT JOIN page AS parent ON page.page_section = parent.page_id
	LEFT JOIN page AS gparent ON parent.page_section = gparent.page_id
	LEFT JOIN page AS ggparent ON gparent.page_section = ggparent.page_id
WHERE
	
	page.page_id = 327 /* 1 */
	
	AND page.template NOT IN ('ITAC','NGSD','ECP')
	
		AND (page.IsTraineeSitePage = 0 or page.IsTraineeSitePage is null)
	
ORDER BY page_id

	SELECT code.code
	FROM link_page_role INNER JOIN code ON link_page_role.code_id = code.id
	WHERE fk_id = 327 

SELECT page.page_id, page.page_section, page.template, page.page_title,
	CASE WHEN ggparent.page_id IS NOT NULL THEN ggparent.page_title
		WHEN gparent.page_id IS NOT NULL THEN gparent.page_title
		WHEN parent.page_id IS NOT NULL THEN parent.page_title
		ELSE page.page_title END AS section_name,
	CASE WHEN ggparent.page_id IS NOT NULL THEN ggparent.page_id
		WHEN gparent.page_id IS NOT NULL THEN gparent.page_id
		WHEN parent.page_id IS NOT NULL THEN parent.page_id
		ELSE page.page_id END AS section_id,
	CASE WHEN ggparent.page_id IS NOT NULL THEN URL('',ggparent.page_filename,ggparent.page_id)
		WHEN gparent.page_id IS NOT NULL THEN URL('',gparent.page_filename,gparent.page_id)
		WHEN parent.page_id IS NOT NULL THEN URL('',parent.page_filename,parent.page_id)
		ELSE URL('',page.page_filename,page.page_id) END AS section_filename,
	gparent.page_title AS gparent_name, gparent.page_id AS gparent_id,
	gparent.page_filename AS gparent_filename,
	parent.page_title AS parent_name, parent.page_id AS parent_id,
	parent.page_filename AS parent_filename
FROM page LEFT JOIN page AS parent ON page.page_section = parent.page_id
	LEFT JOIN page AS gparent ON parent.page_section = gparent.page_id
	LEFT JOIN page AS ggparent ON gparent.page_section = ggparent.page_id
WHERE
	
	1=2
	

	SELECT page.page_id, page.page_title, page.page_section, page.orderby, page.meta_description,
		ifnull(parent.page_title,page.page_title) AS section_name,
		URL('',page.page_filename,page.page_id) AS page_filename
	FROM page LEFT JOIN page AS parent ON page.page_section = parent.page_id
	WHERE ifnull(page.hide_navigation,0) = 0 AND page.live = 1 AND
		parent.page_section is null
		
		AND page.orderby <= 70000
		AND (parent.page_id in (2,3,25,26,27,28,1,507,489) or
			(parent.page_id is null and page.page_id <> 514))
		AND (SELECT COUNT(*) FROM link_page_role WHERE fk_id = page.page_id AND code_id = 113) > 0
		
			AND (page.IsTraineeSitePage = 0 or page.IsTraineeSitePage is null)
		
		 
	ORDER BY page.orderby

SELECT page.page_id, page.page_title, page.orderby, 0 AS sub,
	URL('',page.page_filename,page.page_id) AS page_filename
FROM page
WHERE page.live = 1 AND ifnull(page.hide_navigation,0)=0 
	
		AND ifnull(page.page_section,0) = 2 
UNION
SELECT page_id, page_title, orderby, 1 AS sub,
	URL('',child.page_filename,child.page_id) AS page_filename
FROM page AS child
WHERE live = 1 AND ifnull(hide_navigation,0)=0 AND
	
	ifnull(page_section,0) = 6 
ORDER BY 3,2

SELECT * FROM qry_menutop
WHERE section_name = 'Network Resources' AND page_section > 0 AND page_filename not like '%nirs%'
ORDER BY orderby

SELECT * FROM qry_menutop
WHERE section_name = 'Home' AND page_section > 0
ORDER BY orderby

	SELECT sub FROM submenu
	WHERE page_id = 327 

	SELECT page.page_id, page.page_title, page.orderby,
		CASE WHEN ifnull(page.page_filename,'') <> '' AND locate('?',page.page_filename) > 0
		THEN concat(page.page_filename,'&parent=',page.page_section)
		WHEN ifnull(page.page_filename,'') <> '' AND locate('?',page.page_filename) = 0
		THEN concat(page.page_filename,'?parent=',page.page_section)
		ELSE concat('template/page.cfm?id=',page.page_id,'&parent=',page.page_section) 
		END AS page_filename
	FROM page
	WHERE
		
		ifnull(page.hide_navigation,0)=0 AND
		page_section = 327 
	ORDER BY orderby
	

SELECT page_module.link_id, page_type, page_module.title, page_module.orderby,
	page_subtype, page_topic, page_layout, page_criteria, replace(module.type,' ','') AS type,
	module.subtype, rssaddress, topic.topic_title, replace(page_module.custom,',',' ') as custom,
	'' AS rss,
	
	concat_ws(',',page_module.detail1_id,page_module.detail2_id,page_module.detail3_id) AS detail_id
	
FROM page_module INNER JOIN module ON page_module.page_type = module.type AND (module.sidebar = 0 OR module.sidebar is null)
	LEFT JOIN topic ON page_module.page_topic = topic.topic_id
WHERE
	
		page_id = 327 
ORDER BY page_module.orderby

	SELECT title, content
	FROM page_module
	WHERE link_id = 1555 

SELECT code.name, code.other, 
	CASE WHEN parent.description IS NULL OR code.other like '%show%' THEN code.description
		ELSE parent.description END AS description,
	ifnull(code.id,parent.id) AS parentid 
FROM code LEFT JOIN code AS parent ON code.name = parent.other AND parent.name = 'document_type' 
WHERE code.id = 406 

	SELECT topic_title FROM topic WHERE topic_id = 42 

	SELECT id FROM code WHERE name = 'news_type'
 	

/* Article Title & Summary */
SELECT news.news_id, news.url,
	CASE WHEN length(url) > 0 THEN url
		WHEN ifnull(body,'') = '' AND length(document_file) > 0 THEN concat('/docs/',document_file)
		 
		ELSE concat('../template/news.cfm?news_id=',news_id,'&id=327&parent=327') END AS link,
		
	if(ifnull(body,'') <> '' AND length(document_file) > 0,1,0) AS multiple,
	if(ifnull(body,'') = '' AND (length(document_file) > 0 OR length(url) > 0),'target="_blank"','') AS target,
	document_file, news.title, news.subtitle, news.date, news.summary, news.body,
	code.description AS news_type, thumbnail_file AS photo, caption
FROM news INNER JOIN code ON news.type = code.id
WHERE live = 1
	
		AND type IN (406,85,463,465,468,475,540,555,556,557,568,587)
	
		AND news_id IN (SELECT news_id FROM link_news_topic WHERE topic_id = 42)
	
		AND CASE WHEN alwaysShoworder IS NULL THEN (date BETWEEN {d '2018-05-21'} AND {d '2018-07-20'})
		ELSE 1=1 END
	
ORDER BY 
	CASE WHEN alwaysShowOrder IS NULL THEN 1 ELSE 0 END, alwaysShowOrder,
	date
	
	DESC
	
	, news.title
	

	SELECT title, content
	FROM page_module
	WHERE link_id = 1551 

	SELECT topic_title FROM topic WHERE topic_id = 42 

SELECT code.name, code.other,
	CASE WHEN parent.description IS NULL OR code.other like '%show%' THEN code.description
		ELSE parent.description END AS description,
	ifnull(parent.id,code.id) AS parentid
FROM code LEFT JOIN code AS parent ON code.name = parent.other AND parent.name = 'document_type'
WHERE code.id = 0 

SELECT
	
	event.*, code.description AS location_description, code.other AS location_details,
	case when url is not null AND event.description is null then event.url
		
		else concat('../template/event.cfm?event_id=',event.event_id,'&id=327&parent=327') end AS event_url,
		
	case when url is not null AND event.description is null then '_blank'
		else '' end AS target
FROM event LEFT JOIN code ON event.location_select = code.id
	LEFT JOIN code AS code_type ON event.event_type = code_type.id
WHERE
	
		live = 1 /* Next 60 days */
		
			AND ifnull(parent_id,0) = 0
		
			AND (code_type.code = 'public' OR code_type.id is null)
		
			AND event_id IN (SELECT event_id FROM link_event_topic WHERE topic_id = 42)
		
		AND ifnull(parent_id,0) = 0
	
		AND (code_type.code = 'public' OR code_type.id is null)
	
		AND event_id IN (SELECT event_id FROM link_event_topic WHERE topic_id = 42)
	
		/* Next 60 days */
		AND (start_date BETWEEN {d '2018-07-20'} AND {d '2018-09-18'}
			OR end_date BETWEEN {d '2018-07-20'} AND {d '2018-09-18'})
		
ORDER BY start_date
	

	SELECT title, content
	FROM page_module
	WHERE link_id = 1552 

SELECT code.name, code.other, 
	CASE WHEN parent.description IS NULL OR code.other like '%show%' THEN code.description
		ELSE parent.description END AS description,
	ifnull(code.id,parent.id) AS parentid 
FROM code LEFT JOIN code AS parent ON code.name = parent.other AND parent.name = 'document_type' 
WHERE code.id = 117 

	SELECT topic_title FROM topic WHERE topic_id = 42 

	SELECT id FROM code WHERE name = 'resource_type'
 	

/* Small Title with date */
SELECT news.news_id, news.url,
	CASE WHEN length(url) > 0 THEN url
		WHEN ifnull(body,'') = '' AND length(document_file) > 0 THEN concat('/docs/',document_file)
		 
		ELSE concat('../template/news.cfm?news_id=',news_id,'&id=327&parent=327') END AS link,
		
	if(ifnull(body,'') <> '' AND length(document_file) > 0,1,0) AS multiple,
	if(ifnull(body,'') = '' AND (length(document_file) > 0 OR length(url) > 0),'target="_blank"','') AS target,
	document_file, news.title, news.subtitle, news.date, news.summary, news.body,
	code.description AS news_type, thumbnail_file AS photo, caption
FROM news INNER JOIN code ON news.type = code.id
WHERE live = 1
	
		AND type IN (117,435,436,477,537,550,552,554,561,563)
	
		AND news_id IN (SELECT news_id FROM link_news_topic WHERE topic_id = 42)
	
ORDER BY 
	CASE WHEN alwaysShowOrder IS NULL THEN 1 ELSE 0 END, alwaysShowOrder,
	date
	
	DESC
	
	, news.title
	
	LIMIT 3 

	SELECT title, content
	FROM page_module
	WHERE link_id = 1550 

SELECT sidebar_module.link_id, page_type, sidebar_module.title, sidebar_module.orderby,
	page_topic, page_subtype, page_layout, page_criteria, replace(module.type,' ','') AS type,
	module.subtype, rssaddress, topic.topic_title, sidebar_module.custom, sidebar_module.content,
	'' AS rss,
	
	concat_ws(',',sidebar_module.detail1_id,sidebar_module.detail2_id,sidebar_module.detail3_id) AS detail_id
	
FROM sidebar_module INNER JOIN module ON sidebar_module.page_type = module.type AND module.sidebar = 1
	LEFT JOIN topic ON sidebar_module.page_topic = topic.topic_id
WHERE page_id = 327 
	AND position = 'R'
	
ORDER BY sidebar_module.orderby

	SELECT title, content
	FROM sidebar_module
	WHERE link_id = 299 

CGI Variables:
AUTH_PASSWORD=
AUTH_TYPE=
AUTH_USER=
CERT_COOKIE=
CERT_FLAGS=
CERT_ISSUER=
CERT_KEYSIZE=256
CERT_SECRETKEYSIZE=2048
CERT_SERIALNUMBER=
CERT_SERVER_ISSUER=C=GB, S=Greater Manchester, L=Salford, O=COMODO CA Limited, CN=COMODO RSA Domain Validation Secure Server CA
CERT_SERVER_SUBJECT=OU=Domain Control Validated, OU=EssentialSSL, CN=www.aucd.org
CERT_SUBJECT=
CF_TEMPLATE_PATH=E:\www\aauapweb\aucd\template\page.cfm
CONTENT_LENGTH=
CONTENT_TYPE=
CONTEXT_PATH=
GATEWAY_INTERFACE=CGI/1.1
HTTPS=on
HTTPS_KEYSIZE=256
HTTPS_SECRETKEYSIZE=2048
HTTPS_SERVER_ISSUER=C=GB, S=Greater Manchester, L=Salford, O=COMODO CA Limited, CN=COMODO RSA Domain Validation Secure Server CA
HTTPS_SERVER_SUBJECT=OU=Domain Control Validated, OU=EssentialSSL, CN=www.aucd.org
HTTP_ACCEPT=text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8
HTTP_ACCEPT_ENCODING=x-gzip, gzip, deflate
HTTP_ACCEPT_LANGUAGE=
HTTP_CONNECTION=close
HTTP_COOKIE=
HTTP_HOST=www.aucd.org
HTTP_REFERER=
HTTP_USER_AGENT=CCBot/2.0 (http://commoncrawl.org/faq/)
PATH_INFO=/template/page.cfm
PATH_TRANSLATED=E:\www\aauapweb\aucd\template\page.cfm
QUERY_STRING=id=327
REMOTE_ADDR=54.161.40.41
REMOTE_HOST=54.161.40.41
REMOTE_USER=
REQUEST_METHOD=GET
SCRIPT_NAME=/template/page.cfm
SERVER_NAME=www.aucd.org
SERVER_PORT=443
SERVER_PORT_SECURE=1
SERVER_PROTOCOL=HTTP/1.1
SERVER_SOFTWARE=Microsoft-IIS/7.5
WEB_SERVER_API=

Client Variables:
cfid=22762628
cftoken=66791795
hitcount=1
lastvisit={ts '2018-07-20 12:24:12'}
timecreated={ts '2018-07-20 12:24:12'}
urltoken=CFID=22762628&CFTOKEN=66791795

Cookie Variables:
CFID=22762628
CFTOKEN=66791795

Session Variables:
cfg_admin_directory=/aucd_admin/
cfg_article_url=../resources/digest/issue.cfm?article_id=
cfg_authentication=HTML
cfg_client_full_name=AUCD
cfg_client_id=247
cfg_client_short_name=AUCD
cfg_database_type=mysql
cfg_dateformat=m/d/yyyy
cfg_doc_extension=doc,pdf,xls,txt,wpd,rtf,jpg,jpeg,gif,bmp,png,ppt,pps,mp3
cfg_doc_path=/docs/
cfg_ecp_feedback=bkaufman@AUCD.ORG
cfg_ecp_share=bkaufman@AUCD.ORG
cfg_editor_path=/tiny_mce/
cfg_email_actearlynews_submission=agriffen@AUCD.ORG, oklimova@aucd.org
cfg_email_council_cis=
cfg_email_council_coca=
cfg_email_council_core=
cfg_email_council_mcc=oklimova@aucd.org
cfg_email_council_ncedc=
cfg_email_council_ntdc=
cfg_email_developments_submission=lvaldez@aucd.org
cfg_email_digest_submission=acostalas@AUCD.ORG
cfg_email_hdd_submission=jminor@aucd.org
cfg_email_lend_application_submission=jperry@AUCD.ORG
cfg_email_pmu_submission=ynikola-lisa@aucd.org
cfg_email_spotlight_submission=cpariseau@aucd.org
cfg_email_stimulus=oklimova@aucd.org
cfg_email_website_feedback=oklimova@aucd.org
cfg_encoding=ISO-8859-1
cfg_evaluation_review=agriffen@AUCD.ORG
cfg_has_article_dept=Yes
cfg_has_article_issue=Yes
cfg_has_article_issuedept=Yes
cfg_has_article_type=0
cfg_has_crm=No
cfg_has_document=0
cfg_has_event_topic=Yes
cfg_has_feature_home_page=0
cfg_has_friendly_urls=No
cfg_has_issue_number=Yes
cfg_has_issue_summary=Yes
cfg_has_issue_volume=Yes
cfg_has_module_heading=Yes
cfg_has_new_topic=Yes
cfg_has_news_author=1
cfg_has_news_topic=Yes
cfg_has_person_address=0
cfg_has_person_board=Yes
cfg_has_person_country=0
cfg_has_person_custom=Yes
cfg_has_person_department=1
cfg_has_person_fax=Yes
cfg_has_person_photo=Yes
cfg_has_photo_expiration=0
cfg_has_sidebar=0
cfg_has_topic_parent_id=0
cfg_has_xml_import=0
cfg_live_default=No
cfg_log_number_of_months=4
cfg_mail_from=aucdinfo@aucd.org
cfg_mail_server=
cfg_module_detail_options=3
cfg_ngsd_about=681
cfg_ngsd_email_notification=oklimova@aucd.org,drudolph@aucd.org,beckmanncc@umkc.edu,spalmer@ku.edu,walkerla@umkc.edu,ericecook@sbcglobal.net,gottog@umkc.edu
cfg_ngsd_events=685
cfg_ngsd_join_listserve=687
cfg_ngsd_links=686
cfg_ngsd_news=684
cfg_ngsd_resources=683
cfg_ngsd_topics=682
cfg_ngsd_training=680
cfg_paging_count_landing=3
cfg_paging_count_list=15
cfg_path=
cfg_path_include=
cfg_paths_relative_to=root
cfg_person_notes_label=Notes
cfg_photo_album_view=JavaScript:openNewWindow('../template/slideshow.cfm?album_id={{id}}',800,750);
cfg_photo_path=/images2/
cfg_remember_login=1
cfg_rtoi_year=2012
cfg_search_resilience=per session
cfg_show_error_details=0
cfg_sidebar_positions=Left,Right
cfg_specific_items_days=730
cfg_specific_items_sort=Name
cfg_title=Content Management System
cfg_type_link_to=code
cfid=22762628
cftoken=66791795
sessionid=AUCDWEBSITE_22762628_66791795
urltoken=CFID=22762628&CFTOKEN=66791795

URL Parameters:
id=327