Skating Rink Directory - RinkTime - We are All About Rinks! MyHockeySpace.com - MyHockeySpace.com

Cutlerville, MI Skating Rinks, Skating Arenas & Hockey Rinks Directory




 
Skating Rinks, Skating Arenas
 
Kentwood Funspot in Cutlerville ROLLER
Kentwood Ice Arena in Cutlerville ICE

 
Recent Community Pictures
 

 
Community Video
 

Teemu Selanne Anaheim Duck

NHL Plays of The Week - 4/24/2007

Animal Winter Games - Polar Bear Ice Hockey

Teemu Selänne - Stanley Cup tunnelmia

St. Louis Blues Monday Night Miracle

Nike Goalie - "Landscaper"

Chip & Pepper C7P Launch Party 2

NHL Plays of The Week - 5/1/2007
 
Community Members
 

Top User-Rated Rinks

- No Rated Rinks -

 


Debugging Information
ColdFusion Server Enterprise 8,0,1,195765
Template /skating_rinks/mi/cutlerville_mi_skating_rinks_arenas.cfm
Time Stamp 05-Sep-08 11:51 PM
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
1516 ms 1516 ms 1 CFC[ C:\WWW\v2\Application.cfc | onRequest(/skating_rinks/mi/cutlerville_mi_skating_rinks_arenas.cfm) ] from C:\WWW\v2\Application.cfc
1203 ms 1203 ms 1 C:\WWW\v2\skating_rinks\mi\cutlerville_mi_skating_rinks_arenas.cfm
1203 ms 1203 ms 1 C:\WWW\v2\skating_rinks\template_City.cfm
437 ms 437 ms 1 C:\WWW\v2\skating_rinks\publish_Locations.cfm
235 ms 235 ms 1 C:\WWW\v2\vars_Request.cfm
157 ms 157 ms 1 C:\WWW\v2\skating_rinks\TopLocations.cfm
157 ms 157 ms 1 C:\WWW\v2\skating_rinks\dsp_BannerRotator.cfm
110 ms 110 ms 1 C:\WWW\v2\Events\dsp_CategoryEvents.cfm
110 ms 55 ms 2 C:\WWW\v2\Extensions\Link.cfm
110 ms 110 ms 1 CFC[ C:\WWW\v2\Components\Event.cfc | PromoEvents(CityName = Cutlerville, MaxResults = 50, isHost = False, Featured = True, StateCode = MI) ] from C:\WWW\v2\Components\Event.cfc
110 ms 110 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
94 ms 94 ms 1 CFC[ C:\WWW\v2\Components\Link.cfc | display(LINK_ID = 70, STYLE = , RESOURCE_ID = ) ] from C:\WWW\v2\Components\Link.cfc
93 ms 93 ms 1 CFC[ C:\WWW\v2\Components\Rating.cfc | TopLocations(COUNTRY = USA, CITY = Cutlerville, Level = City, LOCATION_ID = 1580, COUNTY = Kent, STATEPROV = MI, MaxResults = 15, THRESHOLD = 3) ] from C:\WWW\v2\Components\Rating.cfc
93 ms 93 ms 1 CFC[ C:\WWW\v2\Components\Rating.cfc | getRating(Threshold = 3, StateProv = MI, MaxResults = 15, City = Cutlerville) ] from C:\WWW\v2\Components\Rating.cfc
79 ms 79 ms 1 CFC[ C:\WWW\v2\Components\Location.cfc | getLocations(COUNTY_NAME = Kent, CITY_NAME = Cutlerville, STATE_CODE = MI) ] from C:\WWW\v2\Components\Location.cfc
62 ms 62 ms 1 C:\WWW\v2\skating_rinks\autoSuggest.cfm
47 ms 47 ms 1 C:\WWW\v2\skating_rinks\top_nav.cfm
47 ms 47 ms 1 CFC[ C:\WWW\v2\Components\Feature.cfc | getLocationFeatures(LOCATIONID = 1580) ] from C:\WWW\v2\Components\Feature.cfc
47 ms 47 ms 1 CFC[ C:\WWW\v2\Components\Location.cfc | hasFeature(NOADS, 1580) ] from C:\WWW\v2\Components\Location.cfc
32 ms 32 ms 1 CFC[ C:\WWW\v2\Components\Description.cfc | numberOfAreas(1580, ICE) ] from C:\WWW\v2\Components\Description.cfc
31 ms 31 ms 1 C:\WWW\v2\skating_rinks\dsp_Footer.cfm
31 ms 31 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
31 ms 31 ms 1 CFC[ C:\WWW\v2\Components\Location.cfc | seasonStatus(1586) ] from C:\WWW\v2\Components\Location.cfc
16 ms 2 ms 7 C:\WWW\v2\Extensions\Theme.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 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 | numberOfAreas(1586, ICE) ] from C:\WWW\v2\Components\Description.cfc
16 ms 16 ms 1 CFC[ C:\WWW\v2\Components\Description.cfc | numberOfAreas(1586, ROLLER) ] from C:\WWW\v2\Components\Description.cfc
16 ms 16 ms 1 CFC[ C:\WWW\v2\Components\Link.cfc | display(LINK_ID = 38, STYLE = , RESOURCE_ID = ) ] from C:\WWW\v2\Components\Link.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
15 ms 2 ms 7 C:\WWW\v2\Extensions\accelerate.cfm
15 ms 15 ms 1 C:\WWW\v2\skating_rinks\dsp_news.cfm
15 ms 15 ms 1 CFC[ C:\WWW\v2\Components\Activity.cfc | getActivityList() ] from C:\WWW\v2\Components\Activity.cfc
15 ms 15 ms 1 CFC[ C:\WWW\v2\Components\Description.cfc | getall() ] from C:\WWW\v2\Components\Description.cfc
15 ms 15 ms 1 CFC[ C:\WWW\v2\Components\Description.cfc | numberOfAreas(1580, ROLLER) ] from C:\WWW\v2\Components\Description.cfc
15 ms 15 ms 1 CFC[ C:\WWW\v2\Components\Location.cfc | seasonStatus(1580) ] from C:\WWW\v2\Components\Location.cfc
15 ms 15 ms 1 CFC[ C:\WWW\v2\Components\Zip.cfc | getSimpleStateList(STATE_CODE = MI) ] from C:\WWW\v2\Components\Zip.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\statTrackers.cfm
0 ms 0 ms 1 CFC[ C:\WWW\v2\Application.cfc | onRequestEnd(/skating_rinks/mi/cutlerville_mi_skating_rinks_arenas.cfm) ] from C:\WWW\v2\Application.cfc
0 ms 0 ms 1 CFC[ C:\WWW\v2\Application.cfc | onRequestStart(/skating_rinks/mi/cutlerville_mi_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\Community.cfc | displayLogins(ImageSize = 50, Columns = 4, MaxResults = 8) ] from C:\WWW\v2\Components\Community.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 7 CFC[ C:\WWW\v2\Components\Theme.cfc | getThemeVerbiage(THEMEID = 1, THEMEVERBIAGE_STANDARDNAME = ) ] 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(1178674188) ] from C:\WWW\v2\Components\UDF.cfc
0 ms 0 ms 1 CFC[ C:\WWW\v2\Components\UDF.cfc | EpochTimeToDate(1178674405) ] from C:\WWW\v2\Components\UDF.cfc
0 ms 0 ms 1 CFC[ C:\WWW\v2\Components\UDF.cfc | EpochTimeToDate(1181604872) ] from C:\WWW\v2\Components\UDF.cfc
0 ms 0 ms 1 CFC[ C:\WWW\v2\Components\UDF.cfc | EpochTimeToDate(1182220146) ] from C:\WWW\v2\Components\UDF.cfc
0 ms 0 ms 1 CFC[ C:\WWW\v2\Components\UDF.cfc | EpochTimeToDate(1182220625) ] from C:\WWW\v2\Components\UDF.cfc
0 ms 0 ms 1 CFC[ C:\WWW\v2\Components\UDF.cfc | EpochTimeToDate(1186089062) ] from C:\WWW\v2\Components\UDF.cfc
0 ms 0 ms 1 CFC[ C:\WWW\v2\Components\UDF.cfc | EpochTimeToDate(1186184968) ] from C:\WWW\v2\Components\UDF.cfc
0 ms 0 ms 1 CFC[ C:\WWW\v2\Components\UDF.cfc | EpochTimeToDate(1193245117) ] from C:\WWW\v2\Components\UDF.cfc
0 ms 0 ms 1 CFC[ C:\WWW\v2\Components\UDF.cfc | EpochTimeToDate(1203671338) ] from C:\WWW\v2\Components\UDF.cfc
0 ms 0 ms 1 CFC[ C:\WWW\v2\Components\UDF.cfc | EpochTimeToDate(1204407599) ] from C:\WWW\v2\Components\UDF.cfc
0 ms 0 ms 1 CFC[ C:\WWW\v2\Components\UDF.cfc | EpochTimeToDate(1205115040) ] from C:\WWW\v2\Components\UDF.cfc
0 ms 0 ms 1 CFC[ C:\WWW\v2\Components\UDF.cfc | EpochTimeToDate(1205262226) ] from C:\WWW\v2\Components\UDF.cfc
0 ms 0 ms 1 CFC[ C:\WWW\v2\Components\UDF.cfc | EpochTimeToDate(1205262931) ] from C:\WWW\v2\Components\UDF.cfc
0 ms 0 ms 1 CFC[ C:\WWW\v2\Components\UDF.cfc | EpochTimeToDate(1205379224) ] from C:\WWW\v2\Components\UDF.cfc
0 ms 0 ms 1 CFC[ C:\WWW\v2\Components\UDF.cfc | EpochTimeToDate(1205727749) ] from C:\WWW\v2\Components\UDF.cfc
0 ms 0 ms 1 CFC[ C:\WWW\v2\Components\UDF.cfc | EpochTimeToDate(1205771212) ] from C:\WWW\v2\Components\UDF.cfc
0 ms 0 ms 1 CFC[ C:\WWW\v2\Components\UDF.cfc | EpochTimeToDate(1205774443) ] from C:\WWW\v2\Components\UDF.cfc
0 ms 0 ms 1 CFC[ C:\WWW\v2\Components\UDF.cfc | EpochTimeToDate(1205776129) ] from C:\WWW\v2\Components\UDF.cfc
0 ms 0 ms 1 CFC[ C:\WWW\v2\Components\UDF.cfc | EpochTimeToDate(1205777131) ] from C:\WWW\v2\Components\UDF.cfc
0 ms 0 ms 1 CFC[ C:\WWW\v2\Components\UDF.cfc | EpochTimeToDate(1205779378) ] 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
78 ms  STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
1594 ms  TOTAL EXECUTION TIME
red = over 250 ms average execution time


Exceptions

23:51:02.002 - Application Exception - in C:\WWW\v2\Components\Event.cfc : line 671
	    No data returned.
	    
23:51:02.002 - Expression Exception - in C:\WWW\v2\skating_rinks\dsp_news.cfm : line 83
	    Invalid list index 1.
	    


SQL Queries

Result.Data (Datasource=RINKTIME_v2, Time=0ms, Records=1, Cached Query) in C:\WWW\v2\Components\Theme.cfc @ 23:51:01.001
			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 @ 23:51:02.002
			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 @ 23:51:02.002
					SELECT TOP 1 *
					FROM TBL_LINK
					INNER JOIN TBL_PARTNER ON TBL_PARTNER.PARTNER_ID = TBL_LINK.PARTNER_ID
					WHERE TBL_LINK.LINK_ID = 38
					AND LINK_ACTIVE = 1
					AND PARTNER_ACTIVE = 1
					and 1=1
				
LinkLog (Datasource=RINKTIME_v2, Time=16ms, Records=1) in C:\WWW\v2\Components\Link.cfc @ 23:51:02.002
					INSERT INTO TBL_LINKLOG 
					(
						LINK_ID,
						RESOURCE_ID,
						LINKLOG_IP,
						LINKLOG_DATE,
						LINKLOG_REFERER,
						LINKLOG_TYPE
					) 
	  				VALUES 
					(
						38,
						0,
						'38.103.63.60',
						GetDate(),
						'',
						'VIEW'
					)
				
Theme (Datasource=RINKTIME_v2, Time=0ms, Records=0, Cached Query) in C:\WWW\v2\Components\Theme.cfc @ 23:51:02.002
			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 @ 23:51:02.002
			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 @ 23:51:02.002
			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 @ 23:51:02.002
			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 @ 23:51:02.002
			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 @ 23:51:02.002
			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 @ 23:51:02.002
			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 @ 23:51:02.002
			SELECT * FROM TBL_THEMEVERBIAGE 
			WHERE THEME_ID = 1
			AND THEMEVERBIAGE_STANDARD = 'Location'
		
Result.Data (Datasource=RINKTIME_v2, Time=15ms, Records=81) in C:\WWW\v2\Components\Activity.cfc @ 23:51:02.002
				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=94ms, Records=0) in C:\WWW\v2\Components\Event.cfc @ 23:51:02.002
				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 = 'MI'
				
					and TBL_LOCATION.LOCATION_CITY = 'Cutlerville'
				
					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 @ 23:51:02.002
			SELECT * FROM TBL_STATE
			WHERE STATE_CODE = 'MI' 
qry_AllLocations (Datasource=RINKTIME_v2, Time=79ms, Records=2) in C:\WWW\v2\Components\Location.cfc @ 23:51:02.002
			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 = 'MI' AND TBL_POSTAL.POSTAL_COUNTY = 'Kent' 
				AND (
					TBL_LOCATION.LOCATION_CITY = 'Cutlerville'
					OR REPLACE(REPLACE(TBL_LOCATION.LOCATION_CITY,'-',''),'.','') =  'Cutlerville' 
					)
			AND TBL_LOCATION.LOCATION_ACTIVE = 1 
			order by LOCATION_NAME
		
Result.Data (Datasource=RINKTIME_v2, Time=15ms, Records=2) in C:\WWW\v2\Components\Description.cfc @ 23:51:02.002
				SELECT * 
				FROM TBL_DESCRIPTION
				WHERE DESCRIPTION_ACTIVE = 1
			
Result.Data (Datasource=RINKTIME_v2, Time=31ms, Records=1) in C:\WWW\v2\Components\Location.cfc @ 23:51:02.002
					select LOCATION_SEASONSTART, LOCATION_SEASONEND
					from TBL_LOCATION
					where LOCATION_ID = 1586 
Result.Data (Datasource=RINKTIME_v2, Time=16ms, Records=1) in C:\WWW\v2\Components\Description.cfc @ 23:51:02.002
				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 = 1586 AND TBL_DESCRIPTION.DESCRIPTION_CODE = 'ICE' 
Result.Data (Datasource=RINKTIME_v2, Time=16ms, Records=1) in C:\WWW\v2\Components\Description.cfc @ 23:51:02.002
				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 = 1586 AND TBL_DESCRIPTION.DESCRIPTION_CODE = 'ROLLER' 
Result.Data (Datasource=RINKTIME_v2, Time=15ms, Records=1) in C:\WWW\v2\Components\Location.cfc @ 23:51:02.002
					select LOCATION_SEASONSTART, LOCATION_SEASONEND
					from TBL_LOCATION
					where LOCATION_ID = 1580 
Result.Data (Datasource=RINKTIME_v2, Time=32ms, Records=1) in C:\WWW\v2\Components\Description.cfc @ 23:51:02.002
				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 = 1580 AND TBL_DESCRIPTION.DESCRIPTION_CODE = 'ICE' 
Result.Data (Datasource=RINKTIME_v2, Time=15ms, Records=1) in C:\WWW\v2\Components\Description.cfc @ 23:51:02.002
				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 = 1580 AND TBL_DESCRIPTION.DESCRIPTION_CODE = 'ROLLER' 
Result.Data (Datasource=RINKTIME_v2, Time=16ms, Records=12) in C:\WWW\v2\Components\Community.cfc @ 23:51:02.002
				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=16ms, Records=8) in C:\WWW\v2\Components\Community.cfc @ 23:51:02.002
				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=0ms, Records=8) in C:\WWW\v2\Components\Community.cfc @ 23:51:02.002
				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=93ms, Records=0) in C:\WWW\v2\Components\Rating.cfc @ 23:51:02.002
				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 = 'MI' AND LOCATION_CITY = 'Cutlerville'
					AND LOCATION_ACTIVE = 1
					and REVIEW_DATE > {d '2008-03-05'}
				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 @ 23:51:02.002
			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 @ 23:51:02.002
			SELECT * FROM TBL_THEMEVERBIAGE 
			WHERE THEME_ID = 1
			AND THEMEVERBIAGE_STANDARD = 'location'
		
qry_Categories (Datasource=RINKTIME_v2, Time=0ms, Records=0, Cached Query) in C:\WWW\v2\skating_rinks\dsp_news.cfm @ 23:51:02.002
			select *
			from TBL_COMMUNITY_news_category
			order by newscat_order ASC
		
Features (Datasource=RINKTIME_v2, Time=47ms, Records=4) in C:\WWW\v2\Components\Feature.cfc @ 23:51:03.003
				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 = 1580 
					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=16ms, Records=1) in C:\WWW\v2\Components\Link.cfc @ 23:51:03.003
			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=15ms, Records=1) in C:\WWW\v2\Components\Link.cfc @ 23:51:03.003
					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=16ms, Records=1) in C:\WWW\v2\Components\Link.cfc @ 23:51:03.003
					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 @ 23:51:03.003
			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 @ 23:51:03.003
			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 @ 23:51:03.003
			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 @ 23:51:03.003
			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=510
requestcount=5006
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=1329
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\mi\cutlerville_mi_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/mi/cutlerville_mi_skating_rinks_arenas.cfm
PATH_TRANSLATED=C:\WWW\v2\skating_rinks\mi\cutlerville_mi_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/mi/cutlerville_mi_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=2728053
CFTOKEN=81291608
PARTNER_ID=default
RT_ADSEED_DIRECTORY_RIGHT=1
RT_ADSEED_DIRECTORY_TOP=2
SESSION_ID=
Request Parameters:
displayedrows=1
lasttime=1220683863171
markerlist=Start: 1220683862296,<li style='color: white;'>Start publish_Locations.cfm: 0/0,<li style='color: white;'>---zip.getSimpleStateList: 15/15,<li style='color: white;'>---Location.getLocations: 79/94,<li style='color: white;'>---Start Location.getLocations output (2 records): 15/109,<li style='color: white;'>------Query Record: 63/172,<li style='color: white;'>------Query Record: 265/437,<li style='color: white;'>---End Location.getLocations output: 0/437,<li style='color: white;'>End publish_Locations.cfm: 0/437,<li style='color: white;'>COMLPETE!: 438/875
partnercountry=USA
partnerdir=//s3.amazonaws.com/RT_ASSETS/partners/default/
pid=default
requestthrottle=1
starttime=1220683862296
theme=Query (1)
themecode=RINKTIME
thisdirectory=C:\WWW\v2\
timemarkersinitiated=True
Server Variables:
ACCELERATOR=Struct (1560)
COLDFUSION=Struct (8)
OS=Struct (5)
Session Variables:
cfid=2728053
cftoken=81291608
sessionid=RT_DIRECTORY_2728053_81291608
starttime={ts '2008-09-05 23:51:01'}
urltoken=CFID=2728053&CFTOKEN=81291608
URL Parameters:
DEFAULTSEARCHOPTION=
FORCEMAINT=False
OPENIN=sameWindow
SESSION_ID=
THEME=RINKTIME
Debug Rendering Time: 125 ms