|
|
| Home | Tournaments and Events | RinkTime Blog | News/Blogs | Forums | Videos | Community | Add Rink | Rink Staff |
|---|
|
|
|
| Home | Tournaments and Events | RinkTime Blog | News/Blogs | Forums | Videos | Community | Add Rink | Rink Staff |
|---|
|
Debugging Information
Execution Time
Exceptions 23:52:59.059 - Application Exception - in C:\WWW\v2\Components\Event.cfc : line 671
No data returned. 23:53:01.001 - 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:52:59.059SELECT * FROM TBL_THEME WHERE 1=1 and THEME_CODE = 'RINKTIME' WebCategory (Datasource=RINKTIME_v2, Time=0ms, Records=2) in C:\WWW\v2\DynamicDirectory.cfm @ 23:52:59.059SELECT * 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 = 'Hockey Camps' ActivityDivisionDescriptionQuery.Result (Datasource=RINKTIME_v2, Time=110ms, Records=2) in C:\WWW\v2\DynamicDirectory.cfm @ 23:52:59.059SELECT 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 = 19 States (Datasource=RINKTIME_v2, Time=15ms, Records=1) in C:\WWW\v2\Components\Zip.cfc @ 23:52:59.059SELECT * FROM TBL_STATE WHERE STATE_CODE = 'ri' Link (Datasource=RINKTIME_v2, Time=16ms, Records=3) in C:\WWW\v2\Components\Link.cfc @ 23:52:59.059SELECT 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:52:59.059SELECT 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 @ 23:52:59.059INSERT 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 @ 23:52:59.059SELECT * 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:52:59.059SELECT * 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:52:59.059SELECT * 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:52:59.059SELECT * 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:52:59.059SELECT * 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:52:59.059SELECT * 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:52:59.059SELECT * 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:52:59.059SELECT * 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:52:59.059SELECT 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 @ 23:52:59.059select 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 (13,13) and TBL_DIVISION.DIVISION_ID in (1,1) and TBL_DESCRIPTION.DESCRIPTION_ID in (1,2) and TBL_LOCATION.LOCATION_STATE = 'ri' and TBL_EVENT.EVENT_FEATURED = 0 order by EVENT_START_DATE asc States (Datasource=RINKTIME_v2, Time=0ms, Records=1) in C:\WWW\v2\Components\Zip.cfc @ 23:52:59.059SELECT * FROM TBL_STATE WHERE STATE_CODE = 'ri' Counties (Datasource=RINKTIME_v2, Time=250ms, Records=2) in C:\WWW\v2\Components\Zip.cfc @ 23:53:00.000SELECT DISTINCT POSTAL_COUNTY, POSTAL_COUNTRY FROM TBL_POSTAL INNER JOIN TBL_LOCATION ON TBL_LOCATION.LOCATION_ZIP = TBL_POSTAL.POSTAL_CODE INNER JOIN TBL_LOCATIONTYPE ON TBL_LOCATIONTYPE.LOCATIONTYPE_ID = TBL_LOCATION.LOCATIONTYPE_ID WHERE POSTAL_STATE = 'ri' AND LOCATIONTYPE_CODE = 'RINK' AND LOCATION_ACTIVE = 1 and TBL_LOCATION.LOCATION_ID in ( select TBL_LOCATION_ACTIVITY_DIVISION_DESCRIPTION.LOCATION_ID from TBL_LOCATION_ACTIVITY_DIVISION_DESCRIPTION where TBL_LOCATION_ACTIVITY_DIVISION_DESCRIPTION.LOCATION_ID = TBL_LOCATION.LOCATION_ID and TBL_LOCATION_ACTIVITY_DIVISION_DESCRIPTION.ACTIVITY_ID in (13,13) and TBL_LOCATION_ACTIVITY_DIVISION_DESCRIPTION.DIVISION_ID in (1,1) and TBL_LOCATION_ACTIVITY_DIVISION_DESCRIPTION.DESCRIPTION_ID in (1,2) ) ORDER BY POSTAL_COUNTY States (Datasource=RINKTIME_v2, Time=0ms, Records=1) in C:\WWW\v2\Components\Zip.cfc @ 23:53:00.000SELECT * FROM TBL_STATE WHERE STATE_CODE = 'ri' Cities (Datasource=RINKTIME_v2, Time=313ms, Records=2) in C:\WWW\v2\Components\Zip.cfc @ 23:53:00.000SELECT 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 = 'ri' AND LOCATIONTYPE_CODE = 'RINK' AND LOCATION_ACTIVE = 1 and TBL_LOCATION.LOCATION_ID in ( select TBL_LOCATION_ACTIVITY_DIVISION_DESCRIPTION.LOCATION_ID from TBL_LOCATION_ACTIVITY_DIVISION_DESCRIPTION where TBL_LOCATION_ACTIVITY_DIVISION_DESCRIPTION.LOCATION_ID = TBL_LOCATION.LOCATION_ID and TBL_LOCATION_ACTIVITY_DIVISION_DESCRIPTION.ACTIVITY_ID in (13,13) and TBL_LOCATION_ACTIVITY_DIVISION_DESCRIPTION.DIVISION_ID in (1,1) and TBL_LOCATION_ACTIVITY_DIVISION_DESCRIPTION.DESCRIPTION_ID in (1,2) ) ORDER BY LOCATION_CITY States (Datasource=RINKTIME_v2, Time=16ms, Records=1) in C:\WWW\v2\Components\Zip.cfc @ 23:53:00.000SELECT * FROM TBL_STATE WHERE STATE_CODE = 'ri' qry_AllLocations (Datasource=RINKTIME_v2, Time=79ms, Records=2) in C:\WWW\v2\Components\Location.cfc @ 23:53:00.000SELECT 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 = 'ri' AND TBL_LOCATION.LOCATION_ACTIVE = 1 and TBL_LOCATION.LOCATION_ID in ( select TBL_LOCATION_ACTIVITY_DIVISION_DESCRIPTION.LOCATION_ID from TBL_LOCATION_ACTIVITY_DIVISION_DESCRIPTION where TBL_LOCATION_ACTIVITY_DIVISION_DESCRIPTION.LOCATION_ID = TBL_LOCATION.LOCATION_ID and TBL_LOCATION_ACTIVITY_DIVISION_DESCRIPTION.ACTIVITY_ID in (13,13) and TBL_LOCATION_ACTIVITY_DIVISION_DESCRIPTION.DIVISION_ID in (1,1) and TBL_LOCATION_ACTIVITY_DIVISION_DESCRIPTION.DESCRIPTION_ID in (1,2) ) order by LOCATION_NAME Result.Data (Datasource=RINKTIME_v2, Time=0ms, Records=2) in C:\WWW\v2\Components\Description.cfc @ 23:53:00.000SELECT * FROM TBL_DESCRIPTION WHERE DESCRIPTION_ACTIVE = 1 Result.Data (Datasource=RINKTIME_v2, Time=0ms, Records=1) in C:\WWW\v2\Components\Location.cfc @ 23:53:00.000select LOCATION_SEASONSTART, LOCATION_SEASONEND from TBL_LOCATION where LOCATION_ID = 35254 Result.Data (Datasource=RINKTIME_v2, Time=16ms, Records=1) in C:\WWW\v2\Components\Description.cfc @ 23:53:00.000SELECT Count(*) AS count FROM TBL_LOCATION_DESCRIPTION INNER JOIN TBL_DESCRIPTION ON TBL_DESCRIPTION.DESCRIPTION_ID = TBL_LOCATION_DESCRIPTION.DESCRIPTION_ID WHERE LOCATION_ID = 35254 AND TBL_DESCRIPTION.DESCRIPTION_CODE = 'ICE' Result.Data (Datasource=RINKTIME_v2, Time=16ms, Records=1) in C:\WWW\v2\Components\Description.cfc @ 23:53:00.000SELECT Count(*) AS count FROM TBL_LOCATION_DESCRIPTION INNER JOIN TBL_DESCRIPTION ON TBL_DESCRIPTION.DESCRIPTION_ID = TBL_LOCATION_DESCRIPTION.DESCRIPTION_ID WHERE LOCATION_ID = 35254 AND TBL_DESCRIPTION.DESCRIPTION_CODE = 'ROLLER' Result.Data (Datasource=RINKTIME_v2, Time=47ms, Records=1) in C:\WWW\v2\Components\Location.cfc @ 23:53:00.000select LOCATION_SEASONSTART, LOCATION_SEASONEND from TBL_LOCATION where LOCATION_ID = 35255 Result.Data (Datasource=RINKTIME_v2, Time=15ms, Records=1) in C:\WWW\v2\Components\Description.cfc @ 23:53:00.000SELECT Count(*) AS count FROM TBL_LOCATION_DESCRIPTION INNER JOIN TBL_DESCRIPTION ON TBL_DESCRIPTION.DESCRIPTION_ID = TBL_LOCATION_DESCRIPTION.DESCRIPTION_ID WHERE LOCATION_ID = 35255 AND TBL_DESCRIPTION.DESCRIPTION_CODE = 'ICE' Result.Data (Datasource=RINKTIME_v2, Time=16ms, Records=1) in C:\WWW\v2\Components\Description.cfc @ 23:53:00.000SELECT Count(*) AS count FROM TBL_LOCATION_DESCRIPTION INNER JOIN TBL_DESCRIPTION ON TBL_DESCRIPTION.DESCRIPTION_ID = TBL_LOCATION_DESCRIPTION.DESCRIPTION_ID WHERE LOCATION_ID = 35255 AND TBL_DESCRIPTION.DESCRIPTION_CODE = 'ROLLER' qry_getAllRatings (Datasource=RINKTIME_v2, Time=188ms, Records=15) in C:\WWW\v2\Components\Rating.cfc @ 23:53:00.000
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_COUNTRY = 'USA'
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
getCount (Datasource=RINKTIME_v2, Time=16ms, Records=1) in C:\WWW\v2\Components\Rating.cfc @ 23:53:00.000
select count(1) as Total
FROM TBL_REVIEW
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 LOCATION_ID = 206
and REVIEW_DATE > {d '2008-03-05'}
getCount (Datasource=RINKTIME_v2, Time=15ms, Records=1) in C:\WWW\v2\Components\Rating.cfc @ 23:53:00.000
select count(1) as Total
FROM TBL_REVIEW
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 LOCATION_ID = 200
and REVIEW_DATE > {d '2008-03-05'}
getCount (Datasource=RINKTIME_v2, Time=16ms, Records=1) in C:\WWW\v2\Components\Rating.cfc @ 23:53:00.000
select count(1) as Total
FROM TBL_REVIEW
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 LOCATION_ID = 147
and REVIEW_DATE > {d '2008-03-05'}
getCount (Datasource=RINKTIME_v2, Time=15ms, Records=1) in C:\WWW\v2\Components\Rating.cfc @ 23:53:00.000
select count(1) as Total
FROM TBL_REVIEW
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 LOCATION_ID = 127
and REVIEW_DATE > {d '2008-03-05'}
getCount (Datasource=RINKTIME_v2, Time=32ms, Records=1) in C:\WWW\v2\Components\Rating.cfc @ 23:53:00.000
select count(1) as Total
FROM TBL_REVIEW
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 LOCATION_ID = 119
and REVIEW_DATE > {d '2008-03-05'}
getCount (Datasource=RINKTIME_v2, Time=15ms, Records=1) in C:\WWW\v2\Components\Rating.cfc @ 23:53:00.000
select count(1) as Total
FROM TBL_REVIEW
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 LOCATION_ID = 268
and REVIEW_DATE > {d '2008-03-05'}
getCount (Datasource=RINKTIME_v2, Time=63ms, Records=1) in C:\WWW\v2\Components\Rating.cfc @ 23:53:01.001
select count(1) as Total
FROM TBL_REVIEW
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 LOCATION_ID = 354
and REVIEW_DATE > {d '2008-03-05'}
getCount (Datasource=RINKTIME_v2, Time=0ms, Records=1) in C:\WWW\v2\Components\Rating.cfc @ 23:53:01.001
select count(1) as Total
FROM TBL_REVIEW
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 LOCATION_ID = 446
and REVIEW_DATE > {d '2008-03-05'}
getCount (Datasource=RINKTIME_v2, Time=15ms, Records=1) in C:\WWW\v2\Components\Rating.cfc @ 23:53:01.001
select count(1) as Total
FROM TBL_REVIEW
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 LOCATION_ID = 562
and REVIEW_DATE > {d '2008-03-05'}
getCount (Datasource=RINKTIME_v2, Time=16ms, Records=1) in C:\WWW\v2\Components\Rating.cfc @ 23:53:01.001
select count(1) as Total
FROM TBL_REVIEW
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 LOCATION_ID = 605
and REVIEW_DATE > {d '2008-03-05'}
getCount (Datasource=RINKTIME_v2, Time=16ms, Records=1) in C:\WWW\v2\Components\Rating.cfc @ 23:53:01.001
select count(1) as Total
FROM TBL_REVIEW
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 LOCATION_ID = 641
and REVIEW_DATE > {d '2008-03-05'}
getCount (Datasource=RINKTIME_v2, Time=0ms, Records=1) in C:\WWW\v2\Components\Rating.cfc @ 23:53:01.001
select count(1) as Total
FROM TBL_REVIEW
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 LOCATION_ID = 643
and REVIEW_DATE > {d '2008-03-05'}
getCount (Datasource=RINKTIME_v2, Time=15ms, Records=1) in C:\WWW\v2\Components\Rating.cfc @ 23:53:01.001
select count(1) as Total
FROM TBL_REVIEW
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 LOCATION_ID = 648
and REVIEW_DATE > {d '2008-03-05'}
getCount (Datasource=RINKTIME_v2, Time=32ms, Records=1) in C:\WWW\v2\Components\Rating.cfc @ 23:53:01.001
select count(1) as Total
FROM TBL_REVIEW
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 LOCATION_ID = 695
and REVIEW_DATE > {d '2008-03-05'}
getCount (Datasource=RINKTIME_v2, Time=15ms, Records=1) in C:\WWW\v2\Components\Rating.cfc @ 23:53:01.001
select count(1) as Total
FROM TBL_REVIEW
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 LOCATION_ID = 707
and REVIEW_DATE > {d '2008-03-05'}
qry_Categories (Datasource=RINKTIME_v2, Time=0ms, Records=0, Cached Query) in C:\WWW\v2\skating_rinks\dsp_news.cfm @ 23:53:01.001select * from TBL_COMMUNITY_news_category order by newscat_order ASC Result.Data (Datasource=RINKTIME_v2, Time=16ms, Records=10) in C:\WWW\v2\Components\Community.cfc @ 23:53:01.001select 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 Features (Datasource=RINKTIME_v2, Time=47ms, Records=0) in C:\WWW\v2\Components\Feature.cfc @ 23:53:01.001SELECT 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 = 35255 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=46ms, Records=1) in C:\WWW\v2\Components\Link.cfc @ 23:53:01.001SELECT 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=32ms, Records=1) in C:\WWW\v2\Components\Link.cfc @ 23:53:01.001SELECT 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 @ 23:53:01.001INSERT 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:53:02.002SELECT * 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:53:02.002SELECT * 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:53:02.002SELECT * 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:53:02.002SELECT * 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=520
requestcount=5073
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=1323
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/
| ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
