select pagebg, searchbg, sponsorbg, bodybg
	from pagecolors
	where loadsitecode = ? 

	select sum(groupsize.inventory) as kount
	from teetimes, groupsize
	where teetimes.groupsize = groupsize.gid
	and teetimes.status = ?
	and teetimes.tdate >= ? 

	select teetimecount from cypress_teetimecount

   select Distinct name, courseid, dbsource
   from cypress_combinedsearch_courses
	where courseid not in (4456,869)
   order by name

   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

		   select Distinct name, courseid, dbsource
		   from cypress_combinedsearch_courses
		   order by name
		

		   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
		

		   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
		

		   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
		

		   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
		

		   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
		

		   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
		

		   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
		

		   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
		

		   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
		

		   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
		

		   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
		

	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

	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 = ? 

select editortext
from  dcms
where loadpage = 'home'
and loadsitecode = 'click'
and number = '1'

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