Skating Rink Directory - RinkTime - We are All About Rinks! Top Secret Fat Loss Secret - Top Secret Fat Loss Secret

Lincoln County TN Skating Rink, Skating Arena & Hockey Rink Directory




 
Skating Rinks, Skating Arenas by City
 
Fayetteville      

 
Skating Rinks, Skating Arenas
 
Star Wheels Skate Ctr in Fayetteville ROLLER

Top User-Rated Rinks

- No Rated Rinks -

 


Debugging Information
ColdFusion Server Enterprise 8,0,1,195765
Template /skating_rinks/tn/lincoln_county_tn_skating_rinks_arenas.cfm
Time Stamp 06-Sep-08 12:27 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
2297 ms 2297 ms 1 CFC[ C:\WWW\v2\Application.cfc | onRequest(/skating_rinks/tn/lincoln_county_tn_skating_rinks_arenas.cfm) ] from C:\WWW\v2\Application.cfc
2281 ms 2281 ms 1 C:\WWW\v2\skating_rinks\template_County.cfm
2281 ms 2281 ms 1 C:\WWW\v2\skating_rinks\tn\lincoln_county_tn_skating_rinks_arenas.cfm
1281 ms 1281 ms 1 CFC[ C:\WWW\v2\Components\Zip.cfc | getStateList(STATE_CODE = TN) ] from C:\WWW\v2\Components\Zip.cfc
391 ms 391 ms 1 C:\WWW\v2\skating_rinks\publish_Cities.cfm
375 ms 375 ms 1 CFC[ C:\WWW\v2\Components\Zip.cfc | getActiveCityListByState(COUNTY_NAME = Lincoln, STATE_CODE = TN) ] from C:\WWW\v2\Components\Zip.cfc
188 ms 188 ms 1 C:\WWW\v2\skating_rinks\publish_Locations.cfm
109 ms 109 ms 1 C:\WWW\v2\skating_rinks\TopLocations.cfm
93 ms 93 ms 1 C:\WWW\v2\Events\dsp_CategoryEvents.cfm
93 ms 93 ms 1 CFC[ C:\WWW\v2\Components\Location.cfc | getLocations(COUNTY_NAME = Lincoln, STATE_CODE = TN) ] from C:\WWW\v2\Components\Location.cfc
78 ms 78 ms 1 CFC[ C:\WWW\v2\Components\Event.cfc | PromoEvents(isHost = False, Featured = True, MaxResults = 50, StateCode = TN, CountyName = Lincoln) ] from C:\WWW\v2\Components\Event.cfc
78 ms 78 ms 1 CFC[ C:\WWW\v2\Components\Rating.cfc | TopLocations(COUNTRY = USA, MaxResults = 15, Level = County, LOCATION_ID = 0, COUNTY = Lincoln, STATEPROV = TN, THRESHOLD = 3) ] from C:\WWW\v2\Components\Rating.cfc
78 ms 78 ms 1 CFC[ C:\WWW\v2\Components\Rating.cfc | getRating(Threshold = 3, StateProv = TN, MaxResults = 15, County = Lincoln) ] from C:\WWW\v2\Components\Rating.cfc
63 ms 63 ms 1 C:\WWW\v2\skating_rinks\autoSuggest.cfm
32 ms 16 ms 2 C:\WWW\v2\Extensions\Link.cfm
31 ms 31 ms 1 C:\WWW\v2\skating_rinks\dsp_AdvertisementBanner.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_Header.cfm
31 ms 31 ms 1 C:\WWW\v2\skating_rinks\top_nav.cfm
31 ms 31 ms 1 CFC[ C:\WWW\v2\Components\Description.cfc | numberOfAreas(1089, ICE) ] from C:\WWW\v2\Components\Description.cfc
31 ms 31 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 C:\WWW\v2\vars_Request.cfm
16 ms 16 ms 1 CFC[ C:\WWW\v2\Components\Activity.cfc | getActivityList() ] from C:\WWW\v2\Components\Activity.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(1089, ROLLER) ] from C:\WWW\v2\Components\Description.cfc
16 ms 16 ms 1 CFC[ C:\WWW\v2\Components\Link.cfc | display(LINK_ID = 70, STYLE = , RESOURCE_ID = ) ] 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
16 ms 16 ms 1 CFC[ C:\WWW\v2\Components\Location.cfc | seasonStatus(1089) ] from C:\WWW\v2\Components\Location.cfc
15 ms 15 ms 1 C:\WWW\v2\skating_rinks\dsp_Footer.cfm
15 ms 15 ms 1 CFC[ C:\WWW\v2\Components\Feature.cfc | getLocationFeatures(LOCATIONID = 0) ] from C:\WWW\v2\Components\Feature.cfc
15 ms 15 ms 1 CFC[ C:\WWW\v2\Components\Location.cfc | hasFeature(NOADS, 0) ] from C:\WWW\v2\Components\Location.cfc
15 ms 4 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 17 C:\CFusionMX7\CustomTags\Capitalize.cfm
0 ms 0 ms 14 C:\WWW\v2\Extensions\Capitalize.cfm
0 ms 0 ms 3 C:\WWW\v2\Extensions\GetFilePath.cfm
0 ms 0 ms 7 C:\WWW\v2\Extensions\Theme.cfm
0 ms 0 ms 6 C:\WWW\v2\Extensions\accelerate.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\dsp_news.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/tn/lincoln_county_tn_skating_rinks_arenas.cfm) ] from C:\WWW\v2\Application.cfc
0 ms 0 ms 1 CFC[ C:\WWW\v2\Application.cfc | onRequestStart(/skating_rinks/tn/lincoln_county_tn_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\Link.cfc | display(LINK_ID = 80, STYLE = , RESOURCE_ID = ) ] from C:\WWW\v2\Components\Link.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 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 | SortVertically([complex value], 2) ] from C:\WWW\v2\Components\UDF.cfc
0 ms 0 ms 1 CFC[ C:\WWW\v2\Components\UDF.cfc | SortVertically([complex value], 4) ] from C:\WWW\v2\Components\UDF.cfc
0 ms 0 ms 1 CFC[ C:\WWW\v2\Components\UDF.cfc | setTimeMarker(--- End City query output) ] from C:\WWW\v2\Components\UDF.cfc
0 ms 0 ms 1 CFC[ C:\WWW\v2\Components\UDF.cfc | setTimeMarker(--- Starting City query output (4 records)) ] from C:\WWW\v2\Components\UDF.cfc
0 ms 0 ms 1 CFC[ C:\WWW\v2\Components\UDF.cfc | setTimeMarker(--- zip.getActiveCityListByState Done) ] from C:\WWW\v2\Components\UDF.cfc
0 ms 0 ms 1 CFC[ C:\WWW\v2\Components\UDF.cfc | setTimeMarker(--- zip.getSimpleStateList Done) ] 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_Cities.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\UDF.cfc | setTimeMarker(publish_Cities.cfm Done) ] from C:\WWW\v2\Components\UDF.cfc
0 ms 0 ms 2 CFC[ C:\WWW\v2\Components\Zip.cfc | getSimpleStateList(STATE_CODE = TN) ] from C:\WWW\v2\Components\Zip.cfc
250 ms  STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
2547 ms  TOTAL EXECUTION TIME
red = over 250 ms average execution time


Exceptions

12:27:19.019 - Application Exception - in C:\WWW\v2\Components\Event.cfc : line 671
	    No data returned.
	    
12:27:20.020 - 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 @ 12:27:17.017
			SELECT * FROM TBL_THEME
			WHERE 1=1
			
				and THEME_CODE = 'RINKTIME'
			
Link (Datasource=RINKTIME_v2, Time=15ms, Records=3) in C:\WWW\v2\Components\Link.cfc @ 12:27:17.017
			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 @ 12:27:17.017
					SELECT TOP 1 *
					FROM TBL_LINK
					INNER JOIN TBL_PARTNER ON TBL_PARTNER.PARTNER_ID = TBL_LINK.PARTNER_ID
					WHERE TBL_LINK.LINK_ID = 80
					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 @ 12:27:17.017
					INSERT INTO TBL_LINKLOG 
					(
						LINK_ID,
						RESOURCE_ID,
						LINKLOG_IP,
						LINKLOG_DATE,
						LINKLOG_REFERER,
						LINKLOG_TYPE
					) 
	  				VALUES 
					(
						80,
						0,
						'38.103.63.60',
						GetDate(),
						'',
						'VIEW'
					)
				
Theme (Datasource=RINKTIME_v2, Time=0ms, Records=0, Cached Query) in C:\WWW\v2\Components\Theme.cfc @ 12:27:17.017
			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 @ 12:27:17.017
			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 @ 12:27:17.017
			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 @ 12:27:17.017
			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 @ 12:27:17.017
			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 @ 12:27:17.017
			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 @ 12:27:17.017
			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 @ 12:27:17.017
			SELECT * FROM TBL_THEMEVERBIAGE 
			WHERE THEME_ID = 1
			AND THEMEVERBIAGE_STANDARD = 'Location'
		
Result.Data (Datasource=RINKTIME_v2, Time=16ms, Records=81) in C:\WWW\v2\Components\Activity.cfc @ 12:27:18.018
				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
			
States (Datasource=RINKTIME_v2, Time=1281ms, Records=1) in C:\WWW\v2\Components\Zip.cfc @ 12:27:19.019
				SELECT DISTINCT TBL_STATE.*, POSTAL_COUNTRY
				FROM TBL_STATE
				INNER JOIN TBL_POSTAL ON TBL_POSTAL.POSTAL_STATE = TBL_STATE.STATE_CODE	
				WHERE 1=1
				
					AND STATE_CODE = 'TN'
				
				ORDER BY POSTAL_COUNTRY DESC, STATE_CODE 
			
Result.Data (Datasource=RINKTIME_v2, Time=78ms, Records=0) in C:\WWW\v2\Components\Event.cfc @ 12:27:19.019
				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
				
				
					left join TBL_POSTAL on TBL_POSTAL.POSTAL_CODE = TBL_LOCATION.LOCATION_ZIP
				
				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 = 'TN'
				
					and POSTAL_COUNTY = 'Lincoln'
				
					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 @ 12:27:19.019
			SELECT * FROM TBL_STATE
			WHERE STATE_CODE = 'TN' 
Cities (Datasource=RINKTIME_v2, Time=375ms, Records=1) in C:\WWW\v2\Components\Zip.cfc @ 12:27:19.019
			SELECT DISTINCT 
				LOCATION_CITY, 
				POSTAL_COUNTY
			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 POSTAL_STATE = 'TN'
			AND LOCATIONTYPE_CODE = 'RINK'
			AND LOCATION_ACTIVE = 1
			AND POSTAL_COUNTY = 'Lincoln' 
			ORDER BY LOCATION_CITY
		
States (Datasource=RINKTIME_v2, Time=0ms, Records=1) in C:\WWW\v2\Components\Zip.cfc @ 12:27:19.019
			SELECT * FROM TBL_STATE
			WHERE STATE_CODE = 'TN' 
qry_AllLocations (Datasource=RINKTIME_v2, Time=93ms, Records=1) in C:\WWW\v2\Components\Location.cfc @ 12:27:19.019
			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 = 'TN' AND TBL_POSTAL.POSTAL_COUNTY = 'Lincoln' 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 @ 12:27:19.019
				SELECT * 
				FROM TBL_DESCRIPTION
				WHERE DESCRIPTION_ACTIVE = 1
			
Result.Data (Datasource=RINKTIME_v2, Time=0ms, Records=1) in C:\WWW\v2\Components\Location.cfc @ 12:27:19.019
					select LOCATION_SEASONSTART, LOCATION_SEASONEND
					from TBL_LOCATION
					where LOCATION_ID = 1089 
Result.Data (Datasource=RINKTIME_v2, Time=31ms, Records=1) in C:\WWW\v2\Components\Description.cfc @ 12:27:19.019
				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 = 1089 AND TBL_DESCRIPTION.DESCRIPTION_CODE = 'ICE' 
Result.Data (Datasource=RINKTIME_v2, Time=16ms, Records=1) in C:\WWW\v2\Components\Description.cfc @ 12:27:20.020
				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 = 1089 AND TBL_DESCRIPTION.DESCRIPTION_CODE = 'ROLLER' 
qry_getAllRatings (Datasource=RINKTIME_v2, Time=78ms, Records=0) in C:\WWW\v2\Components\Rating.cfc @ 12:27:20.020
				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 = 'TN' AND POSTAL_COUNTY = 'Lincoln' 
					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 @ 12:27:20.020
			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 @ 12:27:20.020
			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 @ 12:27:20.020
			select *
			from TBL_COMMUNITY_news_category
			order by newscat_order ASC
		
Features (Datasource=RINKTIME_v2, Time=15ms, Records=0) in C:\WWW\v2\Components\Feature.cfc @ 12:27:20.020
				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 = 0 
					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 @ 12:27:20.020
			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 @ 12:27:20.020
					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 @ 12:27:20.020
					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 @ 12:27:20.020
			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 @ 12:27:20.020
			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 @ 12:27:20.020
			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 @ 12:27:20.020
			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-06 10:31:38'}
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=386
requestcount=6706
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=1666
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\tn\lincoln_county_tn_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/tn/lincoln_county_tn_skating_rinks_arenas.cfm
PATH_TRANSLATED=C:\WWW\v2\skating_rinks\tn\lincoln_county_tn_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/tn/lincoln_county_tn_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=2745965
CFTOKEN=73947816
PARTNER_ID=default
RT_ADSEED_DIRECTORY_RIGHT=1
RT_ADSEED_DIRECTORY_TOP=3
SESSION_ID=
Request Parameters:
displayedrows=2
lasttime=1220729240187
markerlist=Start: 1220729239421,<li style='color: white;'>START publish_Cities.cfm: 0/0,<li style='color: white;'>--- zip.getSimpleStateList Done: 16/16,<li style='color: white;'>--- zip.getActiveCityListByState Done: 375/391,<li style='color: white;'>--- Starting City query output (4 records): 0/391,<li style='color: white;'>--- End City query output: 0/391,<li style='color: white;'>publish_Cities.cfm Done: 0/391,<li style='color: white;'>Start publish_Locations.cfm: 0/391,<li style='color: white;'>---zip.getSimpleStateList: 16/407,<li style='color: white;'>---Location.getLocations: 93/500,<li style='color: white;'>---Start Location.getLocations output (2 records): 16/516,<li style='color: white;'>------Query Record: 63/579,<li style='color: white;'>------Query Record: 0/579,<li style='color: white;'>---End Location.getLocations output: 0/579,<li style='color: white;'>End publish_Locations.cfm: 0/579,<li style='color: white;'>COMLPETE!: 187/766
partnercountry=USA
partnerdir=//s3.amazonaws.com/RT_ASSETS/partners/default/
pid=default
requestthrottle=1
starttime=1220729239421
theme=Query (1)
themecode=RINKTIME
thisdirectory=C:\WWW\v2\
timemarkersinitiated=True
Server Variables:
ACCELERATOR=Struct (1248)
COLDFUSION=Struct (8)
OS=Struct (5)
Session Variables:
cfid=2745965
cftoken=73947816
sessionid=RT_DIRECTORY_2745965_73947816
starttime={ts '2008-09-06 12:27:17'}
urltoken=CFID=2745965&CFTOKEN=73947816
URL Parameters:
DEFAULTSEARCHOPTION=
FORCEMAINT=False
OPENIN=sameWindow
SESSION_ID=
THEME=RINKTIME
Debug Rendering Time: 63 ms