select ssite_id from ref_ssite where ssite_home = 'www.woodplanet.com'
		

		select ad_id, g_weight from ad_ads where ad_id != 10 and ssite_id = 1 and ad_type = 0 
        	and g_weight <> 0 
        	and (requires_service = 0 or (requires_service = 11 and company_id in (select company_id from company_service where service_id = 11)))	
	

		select * from ad_ads
		where ad_id = '1'
	

 	select top 1 msg_id from wp_newsletter_include where msg_id is not null and date_sent is not null order by date_sent desc

	select msg_id from wp_newsletter_include where msg_id = 28399 and date_sent between dateadd(d,-1,getdate()) and getdate()

	SELECT ph.prod_id, prod_descr
	FROM prod_hier ph, ref_prod ref
	WHERE ph.prod_id = ref.prod_id and ph.parent_id is NULL and ph.ssite_id = 1
		order by ref.list_order asc

		  select distinct c.company_id, company_name from company c, comp_prod_map cpm where c.is_supplier = 1 and
		  c.removal_date is NULL and c.company_id = cpm.company_id and
		  
		  c.company_id in (select company_id from company_service 
		  where service_id = 5 and ssite_id = 1 and isnull(suspended_date,dateadd(yy,1,getdate())) > getdate())
		    
		  order by company_name asc

ads_updatetracktable (Datasource=westmain, Time=62ms) in C:\inetpub\wwwroot\release_new\include\ad_track.cfm @ 11:12:47.047

	parameters type CFSQLType value variable dbVarName  IN  cf_sql_integer  99      IN  cf_sql_timestamp  2019-10-11 11:12:47.723      IN  cf_sql_varchar  74.115.231.227      IN  cf_sql_varchar  imp      IN  cf_sql_varchar  newuser      IN  cf_sql_varchar  /directory/directory.cfm      IN  cf_sql_varchar  page=FC&count=1      IN  cf_sql_varchar
	resultsets name resultset

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:\inetpub\wwwroot\release_new\directory\directory.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=
HTTP_ACCEPT_ENCODING=gzip,deflate
HTTP_ACCEPT_LANGUAGE=
HTTP_CONNECTION=close
HTTP_COOKIE=
HTTP_HOST=www.woodplanet.com
HTTP_REFERER=
HTTP_URL=
HTTP_USER_AGENT=ColdFusion
LOCAL_ADDR=www.woodplanet.com
PATH_INFO=
PATH_TRANSLATED=C:\inetpub\wwwroot\release_new\directory\directory.cfm
QUERY_STRING=page=FC&count=1
REMOTE_ADDR=74.115.231.227
REMOTE_HOST=74.115.231.227
REMOTE_USER=
REQUEST_METHOD=GET
SCRIPT_NAME=/directory/directory.cfm
SERVER_NAME=www.woodplanet.com
SERVER_PORT=80
SERVER_PORT_SECURE=0
SERVER_PROTOCOL=HTTP/1.1
SERVER_SOFTWARE=Microsoft-IIS/7.5
WEB_SERVER_API=

Cookie Variables:
AD=1
AD_DTSTAMP={ts '2019-10-11 11:12:47'}

URL Parameters:
count=1
page=FC