No data returned.
	    

			SELECT * FROM TBL_THEME
			WHERE 1=1
			
				and THEME_CODE = 'RINKTIME'
			

			SELECT * 
			FROM TBL_WEBCATEGORY
			INNER JOIN TBL_WEBCATEGORY_ACTIVITY_DIVISION_DESCRIPTION ON TBL_WEBCATEGORY_ACTIVITY_DIVISION_DESCRIPTION.WEBCATEGORY_ID = TBL_WEBCATEGORY.WEBCATEGORY_ID
			WHERE WEBCATEGORY_NAME = 'Freestyle Roller Rinks'
		

			SELECT distinct TBL_WEBCATEGORY_ACTIVITY_DIVISION_DESCRIPTION.*
			FROM TBL_WEBCATEGORY_ACTIVITY_DIVISION_DESCRIPTION
			inner join TBL_LOCATION_ACTIVITY_DIVISION_DESCRIPTION on (
				TBL_LOCATION_ACTIVITY_DIVISION_DESCRIPTION.ACTIVITY_ID = TBL_WEBCATEGORY_ACTIVITY_DIVISION_DESCRIPTION.ACTIVITY_ID 
				and TBL_LOCATION_ACTIVITY_DIVISION_DESCRIPTION.DIVISION_ID = TBL_WEBCATEGORY_ACTIVITY_DIVISION_DESCRIPTION.DIVISION_ID 
				and TBL_LOCATION_ACTIVITY_DIVISION_DESCRIPTION.DESCRIPTION_ID = TBL_WEBCATEGORY_ACTIVITY_DIVISION_DESCRIPTION.DESCRIPTION_ID 
				)
			WHERE WEBCATEGORY_ID = 9 

			SELECT * FROM TBL_STATE
			WHERE STATE_CODE = 'fl' 

			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
		

					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
				

					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'
					)
				

			SELECT * FROM TBL_THEMEVERBIAGE 
			WHERE THEME_ID = 1
			AND THEMEVERBIAGE_STANDARD = ''
		

			SELECT * FROM TBL_THEMEVERBIAGE 
			WHERE THEME_ID = 1
			AND THEMEVERBIAGE_STANDARD = 'Location'
		

			SELECT * FROM TBL_THEMEVERBIAGE 
			WHERE THEME_ID = 1
			AND THEMEVERBIAGE_STANDARD = ''
		

			SELECT * FROM TBL_THEMEVERBIAGE 
			WHERE THEME_ID = 1
			AND THEMEVERBIAGE_STANDARD = 'Location'
		

			SELECT * FROM TBL_THEMEVERBIAGE 
			WHERE THEME_ID = 1
			AND THEMEVERBIAGE_STANDARD = ''
		

			SELECT * FROM TBL_THEMEVERBIAGE 
			WHERE THEME_ID = 1
			AND THEMEVERBIAGE_STANDARD = 'location'
		

			SELECT * FROM TBL_THEMEVERBIAGE 
			WHERE THEME_ID = 1
			AND THEMEVERBIAGE_STANDARD = ''
		

			SELECT * FROM TBL_THEMEVERBIAGE 
			WHERE THEME_ID = 1
			AND THEMEVERBIAGE_STANDARD = 'Location'
		

				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
			

				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 TBL_ACTIVITY.ACTIVITY_ID in (19)
				
					and TBL_DIVISION.DIVISION_ID in (1)
				
					and TBL_DESCRIPTION.DESCRIPTION_ID in (2)
				
					and TBL_LOCATION.LOCATION_STATE = 'fl'
				
					and TBL_EVENT.EVENT_FEATURED = 0 
				order by EVENT_START_DATE asc
			

			select *
			from TBL_COMMUNITY_news_category
			order by newscat_order ASC
		

	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 = 12
	order by news_date DESC, news_votes DESC

				select top 10 TBL_COMMUNITY_user.id, TBL_COMMUNITY_journal.id as JournalID, TBL_COMMUNITY_journal.[user], TBL_COMMUNITY_journal.title, TBL_COMMUNITY_journal.time, TBL_COMMUNITY_journal.text, '' as link, '' as cleanText
				from TBL_COMMUNITY_user
				inner join TBL_COMMUNITY_journal on TBL_COMMUNITY_journal.[user] = TBL_COMMUNITY_user.[user]
				where friends_only = 0
				and private = 0
				order by TBL_COMMUNITY_journal.time DESC
			

				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
			

			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
		

					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
				

					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'
					)
				

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=566
requestcount=5544
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=1314
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\404.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=/404.cfm
PATH_TRANSLATED=C:\WWW\v2\404.cfm
QUERY_STRING=404;http://www.rinktime.com/freestyle-roller-rinks/state/fl/florida-freestyle-roller-rinks
REMOTE_ADDR=38.103.63.60
REMOTE_HOST=38.103.63.60
REMOTE_USER=
REQUEST_METHOD=GET
SCRIPT_NAME=/404.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=2728475
CFTOKEN=43393920
PARTNER_ID=default
RT_ADSEED_DIRECTORY_RIGHT=1
RT_ADSEED_DIRECTORY_TOP=3
SESSION_ID=

Request Parameters:
displayedrows=15
lasttime=1220685031723
markerlist=Start: 1220685031239,<li style='color: white;'>--- End City query output: 0/0,<li style='color: white;'>COMLPETE!: 484/484
partnercountry=USA
partnerdir=//s3.amazonaws.com/RT_ASSETS/partners/default/
pid=default
requestthrottle=1
starttime=1220685031239
theme=Query (1)
themecode=RINKTIME
thisdirectory=C:\WWW\v2\
timemarkersinitiated=True

Server Variables:
ACCELERATOR=Struct (1843)
COLDFUSION=Struct (8)
OS=Struct (5)

Session Variables:
cfid=2728475
cftoken=43393920
sessionid=RT_DIRECTORY_2728475_43393920
starttime={ts '2008-09-06 00:10:30'}
urltoken=CFID=2728475&CFTOKEN=43393920

URL Parameters:
404;HTTP://WWW.RINKTIME.COM/FREESTYLE-ROLLER-RINKS/STATE/FL/FLORIDA-FREESTYLE-ROLLER-RINKS=