HomeTeeTimesSignupUpdate ProfileForward to FriendFAQ
 
 
SELECT METRO AREA
  SEE AREA COURSES

 


Clickateetimes.com teetimes online
   
   
 



  Sign up for Clickateetime.com free email service and you will be notified of the best tee time offers.  
  Email members frequently see the best rates straight into their inbox. We usually send one update
 
 per week with the latest and newest offers.

 
 

  Check Back Often!   We are adding new courses continually.  If you would like to
  recommend a specific course, please email us at: Customer Service.

  Simply Click, Save and Play                                                                

 
     
 
Tee Time System Designed and Created by
Yodawobe Data Marketing, LLC.

Powered by Nemex, Inc. Technology
Software Copyright 1999,2000,2001,2002,2003,2004,2005,2006 All rights reserved.
Problems displaying the site? Click here for help
 
Home   |  Tee Times   |  Signup   |  Update Profile   |  Forward   |  FAQ   |  Sitemap

   


Debugging Information
ColdFusion Server Standard 8,0,1,195765
Template /clickateetime/home.cfm
Time Stamp 20-Nov-08 07:50 AM
Locale English (US)
User Agent CCBot/1.0 (+http://www.commoncrawl.org/bot.html)
Remote IP 38.103.63.57
Host Name 38.103.63.57


Execution Time

Total Time Avg Time Count Template
515 ms 515 ms 1 C:\www\clubmax4\website\clickateetime\home.cfm
484 ms 484 ms 1 C:\www\clubmax4\website\clickateetime\searchcode.cfm
16 ms 16 ms 1 C:\www\clubmax4\website\clickateetime\Application.cfm
16 ms 16 ms 1 C:\www\clubmax4\website\clickateetime\adserver.cfm
15 ms 15 ms 1 C:\www\clubmax4\website\clickateetime\dcmstools.cfm
0 ms 0 ms 1 C:\www\clubmax4\website\clickateetime\Common_link.cfm
0 ms 0 ms 1 C:\www\clubmax4\website\clickateetime\footer.cfm
0 ms 0 ms 1 C:\www\clubmax4\website\clickateetime\websitelog.cfm
0 ms  STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
531 ms  TOTAL EXECUTION TIME
red = over 250 ms average execution time


SQL Queries

getpagecolors (Datasource=clubmax4, Time=0ms, Records=1) in C:\www\clubmax4\website\clickateetime\home.cfm @ 07:50:10.010
	select pagebg, searchbg, sponsorbg, bodybg
	from pagecolors
	where loadsitecode = ? 
Query Parameter Value(s) -
Parameter #1(CF_SQL_VARCHAR) = click

getteetimecount (Datasource=clubmax4, Time=31ms, Records=1) in C:\www\clubmax4\website\clickateetime\searchcode.cfm @ 07:50:10.010
	select sum(groupsize.inventory) as kount
	from teetimes, groupsize
	where teetimes.groupsize = groupsize.gid
	and teetimes.status = ?
	and teetimes.tdate >= ? 
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 1
Parameter #2(CF_SQL_VARCHAR) = 11/20/2008

getcypressteetimecount (Datasource=clubmax4, Time=0ms, Records=1) in C:\www\clubmax4\website\clickateetime\searchcode.cfm @ 07:50:10.010
	select teetimecount from cypress_teetimecount
selectcourses (Datasource=clubmax4, Time=16ms, Records=788) in C:\www\clubmax4\website\clickateetime\searchcode.cfm @ 07:50:10.010
   select Distinct name, courseid, dbsource
   from cypress_combinedsearch_courses
	where courseid not in (4456,869)
   order by name
selectareas (Datasource=clubmax4, Time=15ms, Records=11) in C:\www\clubmax4\website\clickateetime\searchcode.cfm @ 07:50:10.010
   select Distinct clubs.area
   from clubs
   where clubs.area is not null
   and clubs.area <> ''
	/* --- filter out GM clubs for Callaway and cypress mkts program JJS 6-14-07 */
   and clubs.belongsto <> 1858
   and clubs.area not in ('MD - baltimore','NJ - New York Metro',
						'NJ - Philadelphia','NJ - Atlantic City','VA - Charlottesville',
						'VA - Norfolk','VA - Roanoke-Lynchburg','pa - dc metro')
   and (clubs.area like 'MD%' or clubs.area like 'NJ%' or clubs.area like 'VA%'
		or clubs.area in ('PA - Philadelphia','PA - Central','PA - dc metro','DE - Wilmington / Phila. Area'))
	/* ----------------------------------------------------------------------- JJS */
   order by clubs.area
selectareacourse (Datasource=clubmax4, Time=0ms, Records=789) in C:\www\clubmax4\website\clickateetime\searchcode.cfm @ 07:50:10.010
		   select Distinct name, courseid, dbsource
		   from cypress_combinedsearch_courses
		   order by name
		
selectareacourse (Datasource=clubmax4, Time=31ms, Records=2) in C:\www\clubmax4\website\clickateetime\searchcode.cfm @ 07:50:10.010
		   select Distinct name, courseid, dbsource
		   from cypress_combinedsearch_courses
        	   where  (area = 'MD - Baltimore Metro'
        	   or areaid in (select cypress_areaid from cypress_area_mappings where clubmax_area = 'MD - Baltimore Metro'))
			and courseid not in (4456,869)
		   order by name
		
selectareacourse (Datasource=clubmax4, Time=31ms, Records=1) in C:\www\clubmax4\website\clickateetime\searchcode.cfm @ 07:50:10.010
		   select Distinct name, courseid, dbsource
		   from cypress_combinedsearch_courses
        	   where  (area = 'MD - DC Metro'
        	   or areaid in (select cypress_areaid from cypress_area_mappings where clubmax_area = 'MD - DC Metro'))
			and courseid not in (4456,869)
		   order by name
		
selectareacourse (Datasource=clubmax4, Time=31ms, Records=1) in C:\www\clubmax4\website\clickateetime\searchcode.cfm @ 07:50:10.010
		   select Distinct name, courseid, dbsource
		   from cypress_combinedsearch_courses
        	   where  (area = 'MD - Ocean City'
        	   or areaid in (select cypress_areaid from cypress_area_mappings where clubmax_area = 'MD - Ocean City'))
			and courseid not in (4456,869)
		   order by name
		
selectareacourse (Datasource=clubmax4, Time=16ms, Records=3) in C:\www\clubmax4\website\clickateetime\searchcode.cfm @ 07:50:10.010
		   select Distinct name, courseid, dbsource
		   from cypress_combinedsearch_courses
        	   where  (area = 'MD - Wash / Baltimore Area'
        	   or areaid in (select cypress_areaid from cypress_area_mappings where clubmax_area = 'MD - Wash / Baltimore Area'))
			and courseid not in (4456,869)
		   order by name
		
selectareacourse (Datasource=clubmax4, Time=31ms, Records=1) in C:\www\clubmax4\website\clickateetime\searchcode.cfm @ 07:50:10.010
		   select Distinct name, courseid, dbsource
		   from cypress_combinedsearch_courses
        	   where  (area = 'MD - Western / Frederick'
        	   or areaid in (select cypress_areaid from cypress_area_mappings where clubmax_area = 'MD - Western / Frederick'))
			and courseid not in (4456,869)
		   order by name
		
selectareacourse (Datasource=clubmax4, Time=31ms, Records=0) in C:\www\clubmax4\website\clickateetime\searchcode.cfm @ 07:50:10.010
		   select Distinct name, courseid, dbsource
		   from cypress_combinedsearch_courses
        	   where  (area = 'NJ - South Jersey / Philadelphia'
        	   or areaid in (select cypress_areaid from cypress_area_mappings where clubmax_area = 'NJ - South Jersey / Philadelphia'))
			and courseid not in (4456,869)
		   order by name
		
selectareacourse (Datasource=clubmax4, Time=32ms, Records=1) in C:\www\clubmax4\website\clickateetime\searchcode.cfm @ 07:50:10.010
		   select Distinct name, courseid, dbsource
		   from cypress_combinedsearch_courses
        	   where  (area = 'PA - Central'
        	   or areaid in (select cypress_areaid from cypress_area_mappings where clubmax_area = 'PA - Central'))
			and courseid not in (4456,869)
		   order by name
		
selectareacourse (Datasource=clubmax4, Time=31ms, Records=1) in C:\www\clubmax4\website\clickateetime\searchcode.cfm @ 07:50:10.010
		   select Distinct name, courseid, dbsource
		   from cypress_combinedsearch_courses
        	   where  (area = 'PA - Philadelphia'
        	   or areaid in (select cypress_areaid from cypress_area_mappings where clubmax_area = 'PA - Philadelphia'))
			and courseid not in (4456,869)
		   order by name
		
selectareacourse (Datasource=clubmax4, Time=62ms, Records=6) in C:\www\clubmax4\website\clickateetime\searchcode.cfm @ 07:50:10.010
		   select Distinct name, courseid, dbsource
		   from cypress_combinedsearch_courses
        	   where  (area = 'VA - DC Metro'
        	   or areaid in (select cypress_areaid from cypress_area_mappings where clubmax_area = 'VA - DC Metro'))
			and courseid not in (4456,869)
		   order by name
		
selectareacourse (Datasource=clubmax4, Time=47ms, Records=8) in C:\www\clubmax4\website\clickateetime\searchcode.cfm @ 07:50:10.010
		   select Distinct name, courseid, dbsource
		   from cypress_combinedsearch_courses
        	   where  (area = 'VA - Richmond'
        	   or areaid in (select cypress_areaid from cypress_area_mappings where clubmax_area = 'VA - Richmond'))
			and courseid not in (4456,869)
		   order by name
		
selectareacourse (Datasource=clubmax4, Time=47ms, Records=0) in C:\www\clubmax4\website\clickateetime\searchcode.cfm @ 07:50:10.010
		   select Distinct name, courseid, dbsource
		   from cypress_combinedsearch_courses
        	   where  (area = 'VA - Williamsburg'
        	   or areaid in (select cypress_areaid from cypress_area_mappings where clubmax_area = 'VA - Williamsburg'))
			and courseid not in (4456,869)
		   order by name
		
getads (Datasource=clubmax4, Time=16ms, Records=1) in C:\www\clubmax4\website\clickateetime\adserver.cfm @ 07:50:10.010
	select ad_dates.adid, ad_dates.adimage, ad_dates.clubid, clubs.gui
	from ad_dates, clubs, ad_loadsites
	where ad_dates.clubid = clubs.clubid
	and ad_dates.adid = ad_loadsites.adid
	and adtype = ?
	and sitecode = ?
	and rotate = ?
	and rundate = ? 
	order by priority desc
Query Parameter Value(s) -
Parameter #1(CF_SQL_VARCHAR) = website
Parameter #2(CF_SQL_VARCHAR) = click
Parameter #3(CF_SQL_VARCHAR) = no
Parameter #4(CF_SQL_VARCHAR) = 11/20/2008

getrotateads (Datasource=clubmax4, Time=0ms, Records=0) in C:\www\clubmax4\website\clickateetime\adserver.cfm @ 07:50:10.010
	select ad_dates.adid, ad_dates.adimage, ad_dates.clubid, clubs.gui
	from ad_dates, clubs, ad_loadsites
	where ad_dates.clubid = clubs.clubid
	and ad_dates.adid = ad_loadsites.adid
	and adtype = ?
	and sitecode = ?
	and rotate = ?
	and rundate = ? 
Query Parameter Value(s) -
Parameter #1(CF_SQL_VARCHAR) = website
Parameter #2(CF_SQL_VARCHAR) = click
Parameter #3(CF_SQL_VARCHAR) = yes
Parameter #4(CF_SQL_VARCHAR) = 11/20/2008

getdcms (Datasource=clubmax4, Time=0ms, Records=1) in C:\www\clubmax4\website\clickateetime\dcmstools.cfm @ 07:50:10.010
select editortext
from  dcms
where loadpage = 'home'
and loadsitecode = 'click'
and number = '1'


Scope Variables

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\clubmax4\website\clickateetime\home.cfm
CONTENT_LENGTH=0
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.gogogolf.net
HTTP_REFERER=
HTTP_USER_AGENT=CCBot/1.0 (+http://www.commoncrawl.org/bot.html)
PATH_INFO=/clickateetime/h