Skating Rink Directory - RinkTime - We are All About Rinks! Get Analyzed - Get Analyzed by Keith Primeau

Hartland, WI Skating Rinks, Skating Arenas & Hockey Rinks Directory




 
Skating Rinks, Skating Arenas
 
Howard G. Mullett Ice Center in Hartland ICE
Kettle Moraine Curling Club in Hartland ICE

 
Recent Community Pictures
 

 
Community Video
 

Nintendoweb.nl NES Ice Hockey USA vs SU part I

Pee Wee Hockey Brawl

nike goalie cab driver

Ice hockey hits & bloopers

Possibly the best Ice Hockey fight Ever!

Roxana Shells Senior Hockey

Teemu Selänne - Electric Hero

Nike Goalie - "Bank Robbery"
 
Community Members
 

Top User-Rated Rinks

- No Rated Rinks -

 

RinkTime News

 
 


Debugging Information
ColdFusion Server Enterprise 8,0,1,195765
Template /skating_rinks/wi/hartland_wi_skating_rinks_arenas.cfm
Time Stamp 06-Sep-08 12:12 AM
Locale English (US)
User Agent CCBot/1.0 (+http://www.commoncrawl.org/bot.html)
Remote IP 38.103.63.60
Host Name 38.103.63.60


Execution Time

Total Time Avg Time Count Template
734 ms 734 ms 1 CFC[ C:\WWW\v2\Application.cfc | onRequest(/skating_rinks/wi/hartland_wi_skating_rinks_arenas.cfm) ] from C:\WWW\v2\Application.cfc
718 ms 718 ms 1 C:\WWW\v2\skating_rinks\template_City.cfm
718 ms 718 ms 1 C:\WWW\v2\skating_rinks\wi\hartland_wi_skating_rinks_arenas.cfm
187 ms 187 ms 1 C:\WWW\v2\skating_rinks\publish_Locations.cfm
125 ms 125 ms 1 C:\WWW\v2\skating_rinks\top_nav.cfm
109 ms 16 ms 7 C:\WWW\v2\Extensions\Theme.cfm
94 ms 13 ms 7 CFC[ C:\WWW\v2\Components\Theme.cfc | getThemeVerbiage(THEMEID = 1, THEMEVERBIAGE_STANDARDNAME = ) ] from C:\WWW\v2\Components\Theme.cfc
63 ms 63 ms 1 C:\WWW\v2\skating_rinks\autoSuggest.cfm
62 ms 62 ms 1 C:\WWW\v2\Events\dsp_CategoryEvents.cfm
62 ms 62 ms 1 CFC[ C:\WWW\v2\Components\Event.cfc | PromoEvents(CityName = Hartland, MaxResults = 50, isHost = False, Featured = True, StateCode = WI) ] from C:\WWW\v2\Components\Event.cfc
62 ms 62 ms 1 CFC[ C:\WWW\v2\Components\Location.cfc | getLocations(COUNTY_NAME = Waukesha, CITY_NAME = Hartland, STATE_CODE = WI) ] from C:\WWW\v2\Components\Location.cfc
47 ms 47 ms 1 C:\WWW\v2\skating_rinks\TopLocations.cfm
47 ms 47 ms 1 CFC[ C:\WWW\v2\Components\Rating.cfc | TopLocations(COUNTRY = USA, CITY = Hartland, Level = City, LOCATION_ID = 34846, COUNTY = Waukesha, STATEPROV = WI, MaxResults = 15, THRESHOLD = 3) ] from C:\WWW\v2\Components\Rating.cfc
47 ms 47 ms 1 CFC[ C:\WWW\v2\Components\Rating.cfc | getRating(Threshold = 3, StateProv = WI, MaxResults = 15, City = Hartland) ] from C:\WWW\v2\Components\Rating.cfc
32 ms 16 ms 2 C:\WWW\v2\Extensions\Link.cfm
31 ms 31 ms 1 C:\WWW\v2\skating_rinks\dsp_BannerRotator.cfm
31 ms 31 ms 1 C:\WWW\v2\skating_rinks\dsp_Footer.cfm
16 ms 2 ms 7 C:\WWW\v2\Extensions\accelerate.cfm
16 ms 16 ms 1 C:\WWW\v2\skating_rinks\dsp_AdvertisementBanner.cfm
16 ms 16 ms 1 C:\WWW\v2\skating_rinks\dsp_Header.cfm
16 ms 16 ms 1 C:\WWW\v2\skating_rinks\dsp_news.cfm
16 ms 16 ms 1 C:\WWW\v2\vars_Request.cfm
16 ms 16 ms 1 CFC[ C:\WWW\v2\Components\Community.cfc | displayLogins(ImageSize = 50, Columns = 4, MaxResults = 8) ] from C:\WWW\v2\Components\Community.cfc
16 ms 16 ms 1 CFC[ C:\WWW\v2\Components\Community.cfc | displayPictures(ImageSize = 65, Columns = 6, MaxResults = 12) ] from C:\WWW\v2\Components\Community.cfc
16 ms 16 ms 1 CFC[ C:\WWW\v2\Components\Description.cfc | getall() ] from C:\WWW\v2\Components\Description.cfc
16 ms 16 ms 1 CFC[ C:\WWW\v2\Components\Description.cfc | numberOfAreas(1652, ICE) ] from C:\WWW\v2\Components\Description.cfc
16 ms 16 ms 1 CFC[ C:\WWW\v2\Components\Description.cfc | numberOfAreas(1652, ROLLER) ] from C:\WWW\v2\Components\Description.cfc
16 ms 16 ms 1 CFC[ C:\WWW\v2\Components\Description.cfc | numberOfAreas(34846, ICE) ] from C:\WWW\v2\Components\Description.cfc
16 ms 16 ms 1 CFC[ C:\WWW\v2\Components\Link.cfc | showRotator(ORIENTATION = HORIZONTAL, STYLE = , LOCATION = DIRECTORY_TOP, MAXSIZE = 700) ] from C:\WWW\v2\Components\Link.cfc
16 ms 16 ms 1 CFC[ C:\WWW\v2\Components\Link.cfc | showRotator(ORIENTATION = VERTICAL, STYLE = , LOCATION = DIRECTORY_RIGHT, MAXSIZE = 750) ] from C:\WWW\v2\Components\Link.cfc
15 ms 15 ms 1 CFC[ C:\WWW\v2\Components\Description.cfc | numberOfAreas(34846, ROLLER) ] from C:\WWW\v2\Components\Description.cfc
15 ms 15 ms 1 CFC[ C:\WWW\v2\Components\Feature.cfc | getLocationFeatures(LOCATIONID = 34846) ] from C:\WWW\v2\Components\Feature.cfc
15 ms 15 ms 1 CFC[ C:\WWW\v2\Components\Location.cfc | hasFeature(NOADS, 34846) ] from C:\WWW\v2\Components\Location.cfc
0 ms 0 ms 20 C:\CFusionMX7\CustomTags\Capitalize.cfm
0 ms 0 ms 14 C:\WWW\v2\Extensions\Capitalize.cfm
0 ms 0 ms 4 C:\WWW\v2\Extensions\GetFilePath.cfm
0 ms 0 ms 1 C:\WWW\v2\Global_INC.cfm
0 ms 0 ms 1 C:\WWW\v2\act_CheckScrape.cfm
0 ms 0 ms 1 C:\WWW\v2\skating_rinks\getNews.cfm
0 ms 0 ms 1 C:\WWW\v2\statTrackers.cfm
0 ms 0 ms 1 CFC[ C:\WWW\v2\Application.cfc | onRequestEnd(/skating_rinks/wi/hartland_wi_skating_rinks_arenas.cfm) ] from C:\WWW\v2\Application.cfc
0 ms 0 ms 1 CFC[ C:\WWW\v2\Application.cfc | onRequestStart(/skating_rinks/wi/hartland_wi_skating_rinks_arenas.cfm) ] from C:\WWW\v2\Application.cfc
0 ms 0 ms 1 CFC[ C:\WWW\v2\Application.cfc | onSessionStart() ] from C:\WWW\v2\Application.cfc
0 ms 0 ms 1 CFC[ C:\WWW\v2\Components\Activity.cfc | getActivityList() ] from C:\WWW\v2\Components\Activity.cfc
0 ms 0 ms 1 CFC[ C:\WWW\v2\Components\Community.cfc | displayVideos(ImageSize = 100, Columns = 4, Category = Ice Hockey, MaxResults = 8, ShowFull = True) ] from C:\WWW\v2\Components\Community.cfc
0 ms 0 ms 1 CFC[ C:\WWW\v2\Components\Link.cfc | display(LINK_ID = 37, STYLE = , RESOURCE_ID = ) ] from C:\WWW\v2\Components\Link.cfc
0 ms 0 ms 1 CFC[ C:\WWW\v2\Components\Link.cfc | display(LINK_ID = 70, STYLE = , RESOURCE_ID = ) ] from C:\WWW\v2\Components\Link.cfc
0 ms 0 ms 1 CFC[ C:\WWW\v2\Components\Location.cfc | seasonStatus(1652) ] from C:\WWW\v2\Components\Location.cfc
0 ms 0 ms 1 CFC[ C:\WWW\v2\Components\Location.cfc | seasonStatus(34846) ] from C:\WWW\v2\Components\Location.cfc
0 ms 0 ms 1 CFC[ C:\WWW\v2\Components\Theme.cfc | getThemeDetails(RINKTIME) ] from C:\WWW\v2\Components\Theme.cfc
0 ms 0 ms 4 CFC[ C:\WWW\v2\Components\Theme.cfc | getThemeVerbiage(THEMEID = 1, THEMEVERBIAGE_STANDARDNAME = Location) ] from C:\WWW\v2\Components\Theme.cfc
0 ms 0 ms 2 CFC[ C:\WWW\v2\Components\Theme.cfc | getThemeVerbiage(THEMEID = 1, THEMEVERBIAGE_STANDARDNAME = location) ] from C:\WWW\v2\Components\Theme.cfc
0 ms 0 ms 1 CFC[ C:\WWW\v2\Components\Theme.cfc | getThemeVerbiage(THEMEID = 1, THEMEVERBIAGE_STANDARDNAME = rink) ] from C:\WWW\v2\Components\Theme.cfc
0 ms 0 ms 1 CFC[ C:\WWW\v2\Components\UDF.cfc | EpochTimeToDate(1178675545) ] from C:\WWW\v2\Components\UDF.cfc
0 ms 0 ms 1 CFC[ C:\WWW\v2\Components\UDF.cfc | EpochTimeToDate(1182802488) ] from C:\WWW\v2\Components\UDF.cfc
0 ms 0 ms 1 CFC[ C:\WWW\v2\Components\UDF.cfc | EpochTimeToDate(1183154843) ] from C:\WWW\v2\Components\UDF.cfc
0 ms 0 ms 1 CFC[ C:\WWW\v2\Components\UDF.cfc | EpochTimeToDate(1191890270) ] from C:\WWW\v2\Components\UDF.cfc
0 ms 0 ms 1 CFC[ C:\WWW\v2\Components\UDF.cfc | EpochTimeToDate(1193244695) ] from C:\WWW\v2\Components\UDF.cfc
0 ms 0 ms 1 CFC[ C:\WWW\v2\Components\UDF.cfc | EpochTimeToDate(1193245098) ] from C:\WWW\v2\Components\UDF.cfc
0 ms 0 ms 1 CFC[ C:\WWW\v2\Components\UDF.cfc | EpochTimeToDate(1196928272) ] from C:\WWW\v2\Components\UDF.cfc
0 ms 0 ms 1 CFC[ C:\WWW\v2\Components\UDF.cfc | EpochTimeToDate(1203649735) ] from C:\WWW\v2\Components\UDF.cfc
0 ms 0 ms 1 CFC[ C:\WWW\v2\Components\UDF.cfc | EpochTimeToDate(1204309578) ] from C:\WWW\v2\Components\UDF.cfc
0 ms 0 ms 1 CFC[ C:\WWW\v2\Components\UDF.cfc | EpochTimeToDate(1205114886) ] from C:\WWW\v2\Components\UDF.cfc
0 ms 0 ms 1 CFC[ C:\WWW\v2\Components\UDF.cfc | EpochTimeToDate(1205115396) ] from C:\WWW\v2\Components\UDF.cfc
0 ms 0 ms 1 CFC[ C:\WWW\v2\Components\UDF.cfc | EpochTimeToDate(1205686535) ] from C:\WWW\v2\Components\UDF.cfc
0 ms 0 ms 1 CFC[ C:\WWW\v2\Components\UDF.cfc | EpochTimeToDate(1205761722) ] from C:\WWW\v2\Components\UDF.cfc
0 ms 0 ms 1 CFC[ C:\WWW\v2\Components\UDF.cfc | EpochTimeToDate(1205773576) ] from C:\WWW\v2\Components\UDF.cfc
0 ms 0 ms 1 CFC[ C:\WWW\v2\Components\UDF.cfc | EpochTimeToDate(1205773599) ] from C:\WWW\v2\Components\UDF.cfc
0 ms 0 ms 1 CFC[ C:\WWW\v2\Components\UDF.cfc | EpochTimeToDate(1205776133) ] from C:\WWW\v2\Components\UDF.cfc
0 ms 0 ms 1 CFC[ C:\WWW\v2\Components\UDF.cfc | EpochTimeToDate(1205777125) ] from C:\WWW\v2\Components\UDF.cfc
0 ms 0 ms 1 CFC[ C:\WWW\v2\Components\UDF.cfc | EpochTimeToDate(1205777155) ] from C:\WWW\v2\Components\UDF.cfc
0 ms 0 ms 1 CFC[ C:\WWW\v2\Components\UDF.cfc | EpochTimeToDate(1205777759) ] from C:\WWW\v2\Components\UDF.cfc
0 ms 0 ms 1 CFC[ C:\WWW\v2\Components\UDF.cfc | EpochTimeToDate(1205778323) ] from C:\WWW\v2\Components\UDF.cfc
0 ms 0 ms 1 CFC[ C:\WWW\v2\Components\UDF.cfc | SortVertically([complex value], 2) ] from C:\WWW\v2\Components\UDF.cfc
0 ms 0 ms 2 CFC[ C:\WWW\v2\Components\UDF.cfc | setTimeMarker(------Query Record) ] from C:\WWW\v2\Components\UDF.cfc
0 ms 0 ms 1 CFC[ C:\WWW\v2\Components\UDF.cfc | setTimeMarker(---End Location.getLocations output) ] from C:\WWW\v2\Components\UDF.cfc
0 ms 0 ms 1 CFC[ C:\WWW\v2\Components\UDF.cfc | setTimeMarker(---Location.getLocations) ] from C:\WWW\v2\Components\UDF.cfc
0 ms 0 ms 1 CFC[ C:\WWW\v2\Components\UDF.cfc | setTimeMarker(---Start Location.getLocations output (2 records)) ] from C:\WWW\v2\Components\UDF.cfc
0 ms 0 ms 1 CFC[ C:\WWW\v2\Components\UDF.cfc | setTimeMarker(---zip.getSimpleStateList) ] from C:\WWW\v2\Components\UDF.cfc
0 ms 0 ms 1 CFC[ C:\WWW\v2\Components\UDF.cfc | setTimeMarker(COMLPETE!) ] from C:\WWW\v2\Components\UDF.cfc
0 ms 0 ms 1 CFC[ C:\WWW\v2\Components\UDF.cfc | setTimeMarker(End publish_Locations.cfm) ] from C:\WWW\v2\Components\UDF.cfc
0 ms 0 ms 1 CFC[ C:\WWW\v2\Components\UDF.cfc | setTimeMarker(Start publish_Locations.cfm) ] from C:\WWW\v2\Components\UDF.cfc
0 ms 0 ms 1 CFC[ C:\WWW\v2\Components\Zip.cfc | getSimpleStateList(STATE_CODE = WI) ] from C:\WWW\v2\Components\Zip.cfc
188 ms  STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
922 ms  TOTAL EXECUTION TIME
red = over 250 ms average execution time


Exceptions

00:12:25.025 - Application Exception - in C:\WWW\v2\Components\Event.cfc : line 671
	    No data returned.
	    


SQL Queries

Result.Data (Datasource=RINKTIME_v2, Time=0ms, Records=1, Cached Query) in C:\WWW\v2\Components\Theme.cfc @ 00:12:25.025
			SELECT * FROM TBL_THEME
			WHERE 1=1
			
				and THEME_CODE = 'RINKTIME'
			
Link (Datasource=RINKTIME_v2, Time=0ms, Records=3) in C:\WWW\v2\Components\Link.cfc @ 00:12:25.025
			SELECT LINK_ID, LINK_H, LINK_W
			FROM TBL_LINK 
			INNER JOIN TBL_PARTNER ON TBL_PARTNER.PARTNER_ID = TBL_LINK.PARTNER_ID
			WHERE LINK_LOCATION LIKE '%DIRECTORY_TOP%'
			AND LINK_ACTIVE = 1
			AND PARTNER_ACTIVE = 1
			AND LINK_STARTDATE <= getDate()
			AND LINK_ENDDATE >= getDate()
			order by LINK_PRIORITY
		
Link (Datasource=RINKTIME_v2, Time=0ms, Records=1) in C:\WWW\v2\Components\Link.cfc @ 00:12:25.025
					SELECT TOP 1 *
					FROM TBL_LINK
					INNER JOIN TBL_PARTNER ON TBL_PARTNER.PARTNER_ID = TBL_LINK.PARTNER_ID
					WHERE TBL_LINK.LINK_ID = 37
					AND LINK_ACTIVE = 1
					AND PARTNER_ACTIVE = 1
					and 1=1
				
LinkLog (Datasource=RINKTIME_v2, Time=0ms, Records=1) in C:\WWW\v2\Components\Link.cfc @ 00:12:25.025
					INSERT INTO TBL_LINKLOG 
					(
						LINK_ID,
						RESOURCE_ID,
						LINKLOG_IP,
						LINKLOG_DATE,
						LINKLOG_REFERER,
						LINKLOG_TYPE
					) 
	  				VALUES 
					(
						37,
						0,
						'38.103.63.60',
						GetDate(),
						'',
						'VIEW'
					)
				
Theme (Datasource=RINKTIME_v2, Time=0ms, Records=0, Cached Query) in C:\WWW\v2\Components\Theme.cfc @ 00:12:25.025
			SELECT * FROM TBL_THEMEVERBIAGE 
			WHERE THEME_ID = 1
			AND THEMEVERBIAGE_STANDARD = ''
		
Theme (Datasource=RINKTIME_v2, Time=0ms, Records=1, Cached Query) in C:\WWW\v2\Components\Theme.cfc @ 00:12:25.025
			SELECT * FROM TBL_THEMEVERBIAGE 
			WHERE THEME_ID = 1
			AND THEMEVERBIAGE_STANDARD = 'Location'
		
Theme (Datasource=RINKTIME_v2, Time=0ms, Records=0, Cached Query) in C:\WWW\v2\Components\Theme.cfc @ 00:12:25.025
			SELECT * FROM TBL_THEMEVERBIAGE 
			WHERE THEME_ID = 1
			AND THEMEVERBIAGE_STANDARD = ''
		
Theme (Datasource=RINKTIME_v2, Time=0ms, Records=1, Cached Query) in C:\WWW\v2\Components\Theme.cfc @ 00:12:25.025
			SELECT * FROM TBL_THEMEVERBIAGE 
			WHERE THEME_ID = 1
			AND THEMEVERBIAGE_STANDARD = 'Location'
		
Theme (Datasource=RINKTIME_v2, Time=0ms, Records=0, Cached Query) in C:\WWW\v2\Components\Theme.cfc @ 00:12:25.025
			SELECT * FROM TBL_THEMEVERBIAGE 
			WHERE THEME_ID = 1
			AND THEMEVERBIAGE_STANDARD = ''
		
Theme (Datasource=RINKTIME_v2, Time=0ms, Records=1, Cached Query) in C:\WWW\v2\Components\Theme.cfc @ 00:12:25.025
			SELECT * FROM TBL_THEMEVERBIAGE 
			WHERE THEME_ID = 1
			AND THEMEVERBIAGE_STANDARD = 'location'
		
Theme (Datasource=RINKTIME_v2, Time=0ms, Records=0, Cached Query) in C:\WWW\v2\Components\Theme.cfc @ 00:12:25.025
			SELECT * FROM TBL_THEMEVERBIAGE 
			WHERE THEME_ID = 1
			AND THEMEVERBIAGE_STANDARD = ''
		
Theme (Datasource=RINKTIME_v2, Time=0ms, Records=1, Cached Query) in C:\WWW\v2\Components\Theme.cfc @ 00:12:25.025
			SELECT * FROM TBL_THEMEVERBIAGE 
			WHERE THEME_ID = 1
			AND THEMEVERBIAGE_STANDARD = 'Location'
		
Result.Data (Datasource=RINKTIME_v2, Time=0ms, Records=81) in C:\WWW\v2\Components\Activity.cfc @ 00:12:25.025
				SELECT 
					TBL_ACTIVITY_DESCRIPTION.ACTIVITY_ID,
					TBL_DIVISION.DIVISION_ID,
					TBL_ACTIVITY_DESCRIPTION.DESCRIPTION_ID,
					ACTIVITY_NAME,
					ACTIVITY_URLSAFENAME,
					DESCRIPTION_NAME,
					DESCRIPTION_URLSAFENAME,
					TBL_DESCRIPTION.DESCRIPTION_ID,
					DIVISION_NAME,
					DIVISION_URLSAFENAME,
					ACTIVITY_CODE,
					DESCRIPTION_CODE
				FROM TBL_ACTIVITY_DESCRIPTION
				LEFT JOIN TBL_ACTIVITY_DIVISION ON TBL_ACTIVITY_DIVISION.ACTIVITY_ID = TBL_ACTIVITY_DESCRIPTION.ACTIVITY_ID
				INNER JOIN TBL_ACTIVITY ON TBL_ACTIVITY.ACTIVITY_ID = TBL_ACTIVITY_DESCRIPTION.ACTIVITY_ID
				LEFT JOIN TBL_DIVISION ON TBL_DIVISION.DIVISION_ID = TBL_ACTIVITY_DIVISION.DIVISION_ID
				LEFT JOIN TBL_DESCRIPTION ON TBL_DESCRIPTION.DESCRIPTION_ID = TBL_ACTIVITY_DESCRIPTION.DESCRIPTION_ID
				WHERE 1=1
					
				and ACTIVITY_ACTIVE = 1
				ORDER BY TBL_DESCRIPTION.DESCRIPTION_ID, ACTIVITY_PRIORITY desc, TBL_ACTIVITY.ACTIVITY_ID,  TBL_DIVISION.DIVISION_ID
			
Result.Data (Datasource=RINKTIME_v2, Time=62ms, Records=0) in C:\WWW\v2\Components\Event.cfc @ 00:12:25.025
				select distinct TOP 50
					TBL_EVENT.EVENT_ID,
					TBL_EVENT.EVENT_NAME,
					TBL_EVENT.EVENT_START_DATE,
					TBL_EVENT.EVENT_END_DATE,
					TBL_EVENT.EVENT_IMAGE,
					TBL_EVENT.EVENT_IMAGETHUMB,
					TBL_EVENT.EVENT_PROMOSTART,
					TBL_EVENT.EVENT_PROMOTER,
					TBL_EVENT.EVENT_ALLOWLEADS,
					
					TBL_ACTIVITY.ACTIVITY_CODE,
					TBL_ACTIVITY.ACTIVITY_NAME,
					TBL_ACTIVITY.ACTIVITY_ID,
					TBL_DIVISION.DIVISION_CODE,
					TBL_DIVISION.DIVISION_NAME,
					TBL_DIVISION.DIVISION_ID,
					TBL_DESCRIPTION.DESCRIPTION_CODE,
					TBL_DESCRIPTION.DESCRIPTION_NAME,
					TBL_DESCRIPTION.DESCRIPTION_ID,
					
					'' as LocationURL,
					'' as EventURL
				from TBL_EVENT
				left join TBL_EVENT_ACTIVITY_DIVISION_DESCRIPTION on TBL_EVENT.EVENT_ID = TBL_EVENT_ACTIVITY_DIVISION_DESCRIPTION.EVENT_ID
				left join TBL_ACTIVITY on TBL_ACTIVITY.ACTIVITY_ID = TBL_EVENT_ACTIVITY_DIVISION_DESCRIPTION.ACTIVITY_ID
				left join TBL_DIVISION on TBL_DIVISION.DIVISION_ID = TBL_EVENT_ACTIVITY_DIVISION_DESCRIPTION.DIVISION_ID
				left join TBL_DESCRIPTION on TBL_DESCRIPTION.DESCRIPTION_ID = TBL_EVENT_ACTIVITY_DIVISION_DESCRIPTION.DESCRIPTION_ID
				
					left join TBL_EVENT_LOCATION on TBL_EVENT_LOCATION.EVENT_ID = TBL_EVENT.EVENT_ID
					left join TBL_LOCATION on TBL_LOCATION.LOCATION_ID = TBL_EVENT_LOCATION.LOCATION_ID
				
				
				where 1=1
				and EVENT_PROMOSTART <= getDate()
				and EVENT_PROMOEND >= getDate()
				and EVENT_START_DATE >= getDate()
				and EVENT_ACTIVE = 1
				
					and EVENT_LOCATION_HELDHERE = 0
				
					and TBL_LOCATION.LOCATION_STATE = 'WI'
				
					and TBL_LOCATION.LOCATION_CITY = 'Hartland'
				
					and TBL_EVENT.EVENT_FEATURED = 1 
				order by EVENT_START_DATE asc
			
States (Datasource=RINKTIME_v2, Time=0ms, Records=1) in C:\WWW\v2\Components\Zip.cfc @ 00:12:25.025
			SELECT * FROM TBL_STATE
			WHERE STATE_CODE = 'WI' 
qry_AllLocations (Datasource=RINKTIME_v2, Time=62ms, Records=2) in C:\WWW\v2\Components\Location.cfc @ 00:12:26.026
			SELECT DISTINCT TBL_LOCATION.LOCATION_ID, LOCATION_NAME, LOCATION_CITY, LOCATION_STATE AS POSTAL_STATE, LOCATION_STATE, LOCATION_LAST_UPDATED			
			FROM TBL_LOCATION
			inner join TBL_POSTAL ON TBL_POSTAL.POSTAL_CODE = TBL_LOCATION.LOCATION_ZIP
			inner join TBL_LOCATIONTYPE ON TBL_LOCATIONTYPE.LOCATIONTYPE_ID = TBL_LOCATION.LOCATIONTYPE_ID
			WHERE 1=1
			AND LOCATIONTYPE_CODE = 'RINK'
			AND TBL_LOCATION.LOCATION_STATE = 'WI' AND TBL_POSTAL.POSTAL_COUNTY = 'Waukesha' 
				AND (
					TBL_LOCATION.LOCATION_CITY = 'Hartland'
					OR REPLACE(REPLACE(TBL_LOCATION.LOCATION_CITY,'-',''),'.','') =  'Hartland' 
					)
			AND TBL_LOCATION.LOCATION_ACTIVE = 1 
			order by LOCATION_NAME
		
Result.Data (Datasource=RINKTIME_v2, Time=16ms, Records=2) in C:\WWW\v2\Components\Description.cfc @ 00:12:26.026
				SELECT * 
				FROM TBL_DESCRIPTION
				WHERE DESCRIPTION_ACTIVE = 1
			
Result.Data (Datasource=RINKTIME_v2, Time=0ms, Records=1) in C:\WWW\v2\Components\Location.cfc @ 00:12:26.026
					select LOCATION_SEASONSTART, LOCATION_SEASONEND
					from TBL_LOCATION
					where LOCATION_ID = 1652 
Result.Data (Datasource=RINKTIME_v2, Time=16ms, Records=1) in C:\WWW\v2\Components\Description.cfc @ 00:12:26.026
				SELECT Count(*) AS count
				FROM TBL_LOCATION_DESCRIPTION
				INNER JOIN TBL_DESCRIPTION ON TBL_DESCRIPTION.DESCRIPTION_ID = TBL_LOCATION_DESCRIPTION.DESCRIPTION_ID
				WHERE LOCATION_ID = 1652 AND TBL_DESCRIPTION.DESCRIPTION_CODE = 'ICE' 
Result.Data (Datasource=RINKTIME_v2, Time=16ms, Records=1) in C:\WWW\v2\Components\Description.cfc @ 00:12:26.026
				SELECT Count(*) AS count
				FROM TBL_LOCATION_DESCRIPTION
				INNER JOIN TBL_DESCRIPTION ON TBL_DESCRIPTION.DESCRIPTION_ID = TBL_LOCATION_DESCRIPTION.DESCRIPTION_ID
				WHERE LOCATION_ID = 1652 AND TBL_DESCRIPTION.DESCRIPTION_CODE = 'ROLLER' 
Result.Data (Datasource=RINKTIME_v2, Time=0ms, Records=1) in C:\WWW\v2\Components\Location.cfc @ 00:12:26.026
					select LOCATION_SEASONSTART, LOCATION_SEASONEND
					from TBL_LOCATION
					where LOCATION_ID = 34846 
Result.Data (Datasource=RINKTIME_v2, Time=16ms, Records=1) in C:\WWW\v2\Components\Description.cfc @ 00:12:26.026
				SELECT Count(*) AS count
				FROM TBL_LOCATION_DESCRIPTION
				INNER JOIN TBL_DESCRIPTION ON TBL_DESCRIPTION.DESCRIPTION_ID = TBL_LOCATION_DESCRIPTION.DESCRIPTION_ID
				WHERE LOCATION_ID = 34846 AND TBL_DESCRIPTION.DESCRIPTION_CODE = 'ICE' 
Result.Data (Datasource=RINKTIME_v2, Time=15ms, Records=1) in C:\WWW\v2\Components\Description.cfc @ 00:12:26.026
				SELECT Count(*) AS count
				FROM TBL_LOCATION_DESCRIPTION
				INNER JOIN TBL_DESCRIPTION ON TBL_DESCRIPTION.DESCRIPTION_ID = TBL_LOCATION_DESCRIPTION.DESCRIPTION_ID
				WHERE LOCATION_ID = 34846 AND TBL_DESCRIPTION.DESCRIPTION_CODE = 'ROLLER' 
Result.Data (Datasource=RINKTIME_v2, Time=0ms, Records=12) in C:\WWW\v2\Components\Community.cfc @ 00:12:26.026
				select top 12 *
				from TBL_COMMUNITY_main 
				where 1=1
				and is_adult = 0
				and who_view = 'everyone'
				
				order by newid()
			
Result.Data (Datasource=RINKTIME_v2, Time=0ms, Records=8) in C:\WWW\v2\Components\Community.cfc @ 00:12:26.026
				select top 8 video, [user], category, dateadd, title
				from TBL_COMMUNITY_myvideos
				where apro = 1
				and [public] = 0 
				and category = 'Ice Hockey'
				
				order by newid()
			
Result.Data (Datasource=RINKTIME_v2, Time=16ms, Records=8) in C:\WWW\v2\Components\Community.cfc @ 00:12:26.026
				select top 8 id, [user]
				from TBL_COMMUNITY_user
				where [login] > 0 
				and friends_only = 0
				
				order by newid()
			
qry_getAllRatings (Datasource=RINKTIME_v2, Time=47ms, Records=0) in C:\WWW\v2\Components\Rating.cfc @ 00:12:26.026
				SELECT TOP 15
					TBL_LOCATION.LOCATION_ID,
					TBL_LOCATION.LOCATION_NAME,
					TBL_LOCATION.LOCATION_CITY,
					TBL_LOCATION.LOCATION_STATE,
					-1 AS ReviewCount,
					round(avg(REVIEWDETAIL_VALUE),1) AS Rating
				FROM TBL_REVIEW
				INNER JOIN TBL_LOCATION ON TBL_LOCATION.LOCATION_ID = TBL_REVIEW.LOCATION_ID
				LEFT JOIN TBL_REVIEWDETAIL ON TBL_REVIEWDETAIL.REVIEW_ID = TBL_REVIEW.REVIEW_ID
				
				
					INNER JOIN TBL_POSTAL ON TBL_POSTAL.POSTAL_CODE = TBL_LOCATION.LOCATION_ZIP
				
				WHERE 1=1
					AND (
						REVIEW_MODERATORAPPROVAL = 1
						OR (
							REVIEW_MODERATORAPPROVAL IS NULL
							AND REVIEW_NEEDSREVIEW = 0
							)
						)
					AND REVIEW_EMAILVERIFIED = 1
					AND REVIEW_ACTIVE = 1
					
					AND POSTAL_STATE = 'WI' AND LOCATION_CITY = 'Hartland'
					AND LOCATION_ACTIVE = 1
					and REVIEW_DATE > {d '2008-03-06'}
				GROUP BY TBL_LOCATION.LOCATION_ID, TBL_LOCATION.LOCATION_NAME, TBL_LOCATION.LOCATION_CITY, TBL_LOCATION.LOCATION_STATE
				
					HAVING avg(REVIEWDETAIL_VALUE) >= 3 
				ORDER BY Rating DESC, ReviewCount DESC
			
Theme (Datasource=RINKTIME_v2, Time=0ms, Records=0, Cached Query) in C:\WWW\v2\Components\Theme.cfc @ 00:12:26.026
			SELECT * FROM TBL_THEMEVERBIAGE 
			WHERE THEME_ID = 1
			AND THEMEVERBIAGE_STANDARD = ''
		
Theme (Datasource=RINKTIME_v2, Time=0ms, Records=1, Cached Query) in C:\WWW\v2\Components\Theme.cfc @ 00:12:26.026
			SELECT * FROM TBL_THEMEVERBIAGE 
			WHERE THEME_ID = 1
			AND THEMEVERBIAGE_STANDARD = 'location'
		
qry_Categories (Datasource=RINKTIME_v2, Time=0ms, Records=10, Cached Query) in C:\WWW\v2\skating_rinks\dsp_news.cfm @ 00:12:26.026
			select *
			from TBL_COMMUNITY_news_category
			order by newscat_order ASC
		
Result.Data (Datasource=RINKTIME_v2, Time=0ms, Records=15, Cached Query) in C:\WWW\v2\skating_rinks\getNews.cfm @ 00:12:26.026
	select top 15 *
	from TBL_COMMUNITY_news_main
	inner join TBL_COMMUNITY_news_category on TBL_COMMUNITY_news_category.newscat_id = TBL_COMMUNITY_news_main.news_category
	where active = 1
	and news_votes >= -3
	
	and newscat_id = 13
	order by news_date DESC, news_votes DESC
Features (Datasource=RINKTIME_v2, Time=15ms, Records=3) in C:\WWW\v2\Components\Feature.cfc @ 00:12:26.026
				SELECT
					TBL_LOCATION_PACKAGE_FEATURE.LOCATION_ID,
					TBL_LOCATION_PACKAGE_FEATURE.FEATURE_ID,
					TBL_LOCATION_PACKAGE_FEATURE.PACKAGE_ID,
					FEATURE_NAME,
					FEATURE_CODE,
					FEATURE_PRICE,
					FEATURE_PRICEPER,
					PACKAGE_FEATURE_DISCOUNT,
					PACKAGE_FEATURE_DISCOUNTUNIT,
					LOCATION_PACKAGE_FEATURE_STARTDATE, 
					LOCATION_PACKAGE_FEATURE_ENDDATE,
					LOCATION_PACKAGE_FEATURE_COMMITTEDUNTIL
					, '' as UnitDiscount
					, '' as DiscountedPrice
				FROM TBL_LOCATION_PACKAGE_FEATURE
				INNER JOIN TBL_LOCATION ON TBL_LOCATION.LOCATION_ID = TBL_LOCATION_PACKAGE_FEATURE.LOCATION_ID
				INNER JOIN TBL_FEATURE ON TBL_FEATURE.FEATURE_ID = TBL_LOCATION_PACKAGE_FEATURE.FEATURE_ID
				LEFT JOIN TBL_PACKAGE ON TBL_PACKAGE.PACKAGE_ID = TBL_LOCATION_PACKAGE_FEATURE.PACKAGE_ID
				LEFT JOIN TBL_PACKAGE_FEATURE ON (
					TBL_PACKAGE_FEATURE.PACKAGE_ID = TBL_LOCATION_PACKAGE_FEATURE.PACKAGE_ID 
					AND TBL_PACKAGE_FEATURE.FEATURE_ID = TBL_LOCATION_PACKAGE_FEATURE.FEATURE_ID
					)
				WHERE 1=1
				AND TBL_LOCATION_PACKAGE_FEATURE.LOCATION_ID = 34846 
					AND LOCATION_PACKAGE_FEATURE_STARTDATE <= getDate()
					AND (LOCATION_PACKAGE_FEATURE_ENDDATE >= getDate() OR LOCATION_PACKAGE_FEATURE_ENDDATE IS NULL)
				
				AND FEATURE_STARTDATE <= getDate()
				AND (FEATURE_ENDDATE > getDate() or FEATURE_ENDDATE is NULL)
				ORDER BY TBL_LOCATION_PACKAGE_FEATURE.LOCATION_ID, FEATURE_PRIORITY
			
Link (Datasource=RINKTIME_v2, Time=0ms, Records=1) in C:\WWW\v2\Components\Link.cfc @ 00:12:26.026
			SELECT LINK_ID, LINK_H, LINK_W
			FROM TBL_LINK 
			INNER JOIN TBL_PARTNER ON TBL_PARTNER.PARTNER_ID = TBL_LINK.PARTNER_ID
			WHERE LINK_LOCATION LIKE '%DIRECTORY_RIGHT%'
			AND LINK_ACTIVE = 1
			AND PARTNER_ACTIVE = 1
			AND LINK_STARTDATE <= getDate()
			AND LINK_ENDDATE >= getDate()
			order by LINK_PRIORITY
		
Link (Datasource=RINKTIME_v2, Time=0ms, Records=1) in C:\WWW\v2\Components\Link.cfc @ 00:12:26.026
					SELECT TOP 1 *
					FROM TBL_LINK
					INNER JOIN TBL_PARTNER ON TBL_PARTNER.PARTNER_ID = TBL_LINK.PARTNER_ID
					WHERE TBL_LINK.LINK_ID = 70
					AND LINK_ACTIVE = 1
					AND PARTNER_ACTIVE = 1
					and 1=1
				
LinkLog (Datasource=RINKTIME_v2, Time=0ms, Records=1) in C:\WWW\v2\Components\Link.cfc @ 00:12:26.026
					INSERT INTO TBL_LINKLOG 
					(
						LINK_ID,
						RESOURCE_ID,
						LINKLOG_IP,
						LINKLOG_DATE,
						LINKLOG_REFERER,
						LINKLOG_TYPE
					) 
	  				VALUES 
					(
						70,
						0,
						'38.103.63.60',
						GetDate(),
						'',
						'VIEW'
					)
				
Theme (Datasource=RINKTIME_v2, Time=0ms, Records=0, Cached Query) in C:\WWW\v2\Components\Theme.cfc @ 00:12:26.026
			SELECT * FROM TBL_THEMEVERBIAGE 
			WHERE THEME_ID = 1
			AND THEMEVERBIAGE_STANDARD = ''
		
Theme (Datasource=RINKTIME_v2, Time=0ms, Records=1, Cached Query) in C:\WWW\v2\Components\Theme.cfc @ 00:12:26.026
			SELECT * FROM TBL_THEMEVERBIAGE 
			WHERE THEME_ID = 1
			AND THEMEVERBIAGE_STANDARD = 'Location'
		
Theme (Datasource=RINKTIME_v2, Time=0ms, Records=0, Cached Query) in C:\WWW\v2\Components\Theme.cfc @ 00:12:26.026
			SELECT * FROM TBL_THEMEVERBIAGE 
			WHERE THEME_ID = 1
			AND THEMEVERBIAGE_STANDARD = ''
		
Theme (Datasource=RINKTIME_v2, Time=0ms, Records=0, Cached Query) in C:\WWW\v2\Components\Theme.cfc @ 00:12:26.026
			SELECT * FROM TBL_THEMEVERBIAGE 
			WHERE THEME_ID = 1
			AND THEMEVERBIAGE_STANDARD = 'rink'
		


Scope Variables

Application Variables:
accountobj=Struct (5)
activityobj=Struct (7)
addir=a1/
allowdynamicsearch=False
applicationname=RT_Directory
appstarted={ts '2008-09-05 21:30:23'}
assetdir=Assets/
basedir=/
basepath=C:\WWW\v2\
cachedwithin=0.5
communityobj=Struct (14)
componentsdir=Components/
cryptkey=RinKtiMe+
daysuntilinvoicedue=14
dbdatasource=RINKTIME_v2
dbpassword=joelgrimes
dbusername=joelgrimes
debug=True
descriptionobj=Struct (4)
developerips=10.100.10.127,127.0.0.1,localhost,71.85.149.193,71.85.149.243,69.110.219.250,68.184.205.131,10.100.10.250,68.184.205.131,68.184.204.5
divisionobj=Struct (3)
domain=www.rinktime.com
erroremail=rt_errors@zepoid.com
event_costfeaturedperday=0.17
event_costperday=0.17
event_costperlocation=0.02
event_minimumfee=2.50
eventcontroldir=events/EventControl/
eventdir=events/
eventimagesdir=Assets/events/
eventobj=Struct (19)
extensiondir=Extensions/
extensionsdir=Extensions/
externaladdir=//s3.amazonaws.com/RT_ASSETS/a1/
externalassetdir=//s3.amazonaws.com/RT_ASSETS/
facebookkey=a639ea1d8381241007988ad44840fd54
fbclient=Struct (41)
featureobj=Struct (12)
filedir=Files/
financialsystemactivated=False
googlemapsapikey=ABQIAAAAIgEWZ8eRgO6bNZ0ZdzoALxQ4GwHlP3Y-ZeRcab9SrPhZZuUw1RTeInzqZoDyGzIb3zbZ9vrfnlhjYA
googlerateperclick=0.10
groupobj=Struct (15)
invoiceobj=Struct (4)
lastrequestthrottle=1
listingeditdir=RinkControl/edit/
locationadmindir=RinkControl/
locationobj=Struct (40)
logindir=Login/
mailinglistobj=Struct (15)
mailobj=Struct (6)
maindir=Checkin/
moduledir=Checkin/Modules/
msnrateperclick=0.15
nocache=False
paypalapipassword=9EEMZCDLUJTMAVFA
paypalapisignature=A47h7NfE8rUOc7ceXuk.19nNXdpKA5Wz296rK8roStIVnLZrKXEE5cBp
paypalapiusername=john_api1.rinktime.com
paypalobj=Struct (3)
paypalserverurl=https://api-3t.paypal.com/nvp
paypalurl=https://www.sandbox.paypal.com/cgi-bin/webscr?cmd=_express-checkout&token=
paypalversion=3.0
ratingobj=Struct (9)
recachenearby=577
requestcount=5605
requesttrottle=1
resourceobj=Struct (27)
reviewdisplayperiod=-6
roleobj=Struct (8)
rssdir=feeds/
rssobj=Struct (11)
s3basedir=//s3.amazonaws.com/RT_ASSETS/
s3bucketname=RT_ASSETS
s3obj=Struct (9)
secureprotocol=https://
securityobj=Struct (1)
sessioncount=1312
sessionobj=Struct (5)
sessiontimeout=30
statobj=Struct (16)
statsobj=Struct (16)
supportemail=support@rinktime.com
supporthours=8:30 - 5:00 pm, Pacific Time
supportphone=714.265.7342
theme=Query (1)
themecode=RINKTIME
themeid=1
themeobj=Struct (2)
transactionobj=Struct (8)
twittersearchstring=%22roller%20skate%22%20OR%20%22roller%20skating%22%20OR%20%22ice%20skate%22%20OR%20%22ice%20skating%22%20OR%20%22hockey%22%20OR%20%22curling%22%20OR%20%22roller%20derby%22%20OR%20%22rinktime%22%20OR%20%22rink%22
udfobj=Struct (35)
webcachedays=1
webdir=skating_rinks/
yahoorateperclick=0.15
zipobj=Struct (12)
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=C:\WWW\v2\skating_rinks\wi\hartland_wi_skating_rinks_arenas.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=Accept: application/xhtml+xml,text/html;q=0.9,text/plain;
HTTP_ACCEPT_ENCODING=gzip
HTTP_ACCEPT_LANGUAGE=en-us,en;q=0.5
HTTP_CONNECTION=close
HTTP_COOKIE=
HTTP_HOST=www.rinktime.com
HTTP_REFERER=
HTTP_USER_AGENT=CCBot/1.0 (+http://www.commoncrawl.org/bot.html)
PATH_INFO=/skating_rinks/wi/hartland_wi_skating_rinks_arenas.cfm
PATH_TRANSLATED=C:\WWW\v2\skating_rinks\wi\hartland_wi_skating_rinks_arenas.cfm
QUERY_STRING=
REMOTE_ADDR=38.103.63.60
REMOTE_HOST=38.103.63.60
REMOTE_USER=
REQUEST_METHOD=GET
SCRIPT_NAME=/skating_rinks/wi/hartland_wi_skating_rinks_arenas.cfm
SERVER_NAME=www.rinktime.com
SERVER_PORT=80
SERVER_PORT_SECURE=0
SERVER_PROTOCOL=HTTP/1.1
SERVER_SOFTWARE=Microsoft-IIS/5.0
WEB_SERVER_API=
Cookie Variables:
CFID=2728514
CFTOKEN=61406740
PARTNER_ID=default
RT_ADSEED_DIRECTORY_RIGHT=2
RT_ADSEED_DIRECTORY_TOP=1
SESSION_ID=
Request Parameters:
displayedrows=16
lasttime=1220685146301
markerlist=Start: 1220685145942,<li style='color: white;'>Start publish_Locations.cfm: 0/0,<li style='color: white;'>---zip.getSimpleStateList: 0/0,<li style='color: white;'>---Location.getLocations: 62/62,<li style='color: white;'>---Start Location.getLocations output (2 records): 16/78,<li style='color: white;'>------Query Record: 63/141,<li style='color: white;'>------Query Record: 46/187,<li style='color: white;'>---End Location.getLocations output: 0/187,<li style='color: white;'>End publish_Locations.cfm: 0/187,<li style='color: white;'>COMLPETE!: 172/359
partnercountry=USA
partnerdir=//s3.amazonaws.com/RT_ASSETS/partners/default/
pid=default
requestthrottle=1
starttime=1220685145942
theme=Query (1)
themecode=RINKTIME
thisdirectory=C:\WWW\v2\
timemarkersinitiated=True
Server Variables:
ACCELERATOR=Struct (1867)
COLDFUSION=Struct (8)
OS=Struct (5)
Session Variables:
cfid=2728514
cftoken=61406740
sessionid=RT_DIRECTORY_2728514_61406740
starttime={ts '2008-09-06 00:12:25'}
urltoken=CFID=2728514&CFTOKEN=61406740
URL Parameters:
DEFAULTSEARCHOPTION=
FORCEMAINT=False
OPENIN=sameWindow
SEARCHSTRING=13
SESSION_ID=
THEME=RINKTIME
Debug Rendering Time: 63 ms