select c.company_id, c.company_name, newid() as random_num from company c, company_service cs
	where c.company_id = cs.company_id and c.removal_reason is NULL and c.is_supplier = 1 
		and cs.ssite_id = 1 and cs.service_id = 5 and isnull(cs.suspended_date,dateadd(yy,1,getdate())) > getdate() order by random_num

select distinct top 5 sm.company_id, c.company_name, sm.date_mod, sm.stock_title, sm.main_list, sm.stock_id
	from stock_main sm, company c, users u, company_service cs where sm.removal_date is NULL and stock_id in (select stock_id from stock_items)
	and sm.company_id = c.company_id and sm.wp_userid = u.iuserid
	and c.removal_date is null and u.removal_date is null
	and c.company_id = cs.company_id
	and cs.service_id = 6 and cs.suspended_date is NULL
	order by sm.date_mod DESC

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 = '14'

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 = 32232 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 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 its.item_id from items_for_sale its, company_service cs
	where its.company_id = cs.company_id and 
	cs.service_id in (7,24,25,26) and isnull(cs.suspended_date,dateadd(d,1,getdate())) < getdate()
		and its.datesubmitted > {ts '2026-09-20 17:47:14'}

select top 3 rfq_id, rfq_title, rfq_time, prodgroup_id, state, ship_to_city, ship_to_detailed, buyer_cat
			from rfq_board
			where ssite_id = 1 and prodgroup_id = 53
			
			order by rfq_time DESC

select count(*) as rfqcount from rfq_board where ssite_id = 1 and prodgroup_id = 53

select top 4 ifss.cat_id, ifs.item_id, ifs.item_title, ifs.datesubmitted, 
						case when c.company_country_id = 27 then c.company_state
					     when c.company_country_id = 167 then c.company_state
					     else rn.country_short end as company_state
				from Items_For_Sale ifs, company c, items_for_sale_ssite ifss, ref_countries_new rn
				where c.company_id = ifs.company_id and ifss.item_id = ifs.item_id
				and c.company_country_id = rn.country_id
				and ifs.date_validated is not null
				and ifs.datesubmitted > {ts '2026-09-20 17:47:14'}
				and ifss.ssite_id = 1 and ifss.cat_id = 53 and ifs.item_id not in (911549,901532,901531,901535)
				
                order by ifs.date_validated desc

select count(*) as itemcount from items_for_sale ifs, items_for_sale_ssite ifss
				where ifs.item_id = ifss.item_id and ifss.ssite_id = 1 and ifss.cat_id = 53
				and ifs.date_validated is not null
	 			and ifs.datesubmitted > {ts '2026-09-20 17:47:14'}

select top 3 rfq_id, rfq_title, rfq_time, prodgroup_id, state, ship_to_city, ship_to_detailed, buyer_cat
			from rfq_board
			where ssite_id = 1 and prodgroup_id = 54
			
			order by rfq_time DESC

select count(*) as rfqcount from rfq_board where ssite_id = 1 and prodgroup_id = 54

select top 4 ifss.cat_id, ifs.item_id, ifs.item_title, ifs.datesubmitted, 
						case when c.company_country_id = 27 then c.company_state
					     when c.company_country_id = 167 then c.company_state
					     else rn.country_short end as company_state
				from Items_For_Sale ifs, company c, items_for_sale_ssite ifss, ref_countries_new rn
				where c.company_id = ifs.company_id and ifss.item_id = ifs.item_id
				and c.company_country_id = rn.country_id
				and ifs.date_validated is not null
				and ifs.datesubmitted > {ts '2026-09-20 17:47:14'}
				and ifss.ssite_id = 1 and ifss.cat_id = 54 and ifs.item_id not in (911549,901532,901531,901535)
				
                order by ifs.date_validated desc

select count(*) as itemcount from items_for_sale ifs, items_for_sale_ssite ifss
				where ifs.item_id = ifss.item_id and ifss.ssite_id = 1 and ifss.cat_id = 54
				and ifs.date_validated is not null
	 			and ifs.datesubmitted > {ts '2026-09-20 17:47:14'}

select top 3 rfq_id, rfq_title, rfq_time, prodgroup_id, state, ship_to_city, ship_to_detailed, buyer_cat
			from rfq_board
			where ssite_id = 1 and prodgroup_id = 55
			
			order by rfq_time DESC

select count(*) as rfqcount from rfq_board where ssite_id = 1 and prodgroup_id = 55

select top 4 ifss.cat_id, ifs.item_id, ifs.item_title, ifs.datesubmitted, 
						case when c.company_country_id = 27 then c.company_state
					     when c.company_country_id = 167 then c.company_state
					     else rn.country_short end as company_state
				from Items_For_Sale ifs, company c, items_for_sale_ssite ifss, ref_countries_new rn
				where c.company_id = ifs.company_id and ifss.item_id = ifs.item_id
				and c.company_country_id = rn.country_id
				and ifs.date_validated is not null
				and ifs.datesubmitted > {ts '2026-09-20 17:47:15'}
				and ifss.ssite_id = 1 and ifss.cat_id = 55 and ifs.item_id not in (911549,901532,901531,901535)
				
                order by ifs.date_validated desc

select count(*) as itemcount from items_for_sale ifs, items_for_sale_ssite ifss
				where ifs.item_id = ifss.item_id and ifss.ssite_id = 1 and ifss.cat_id = 55
				and ifs.date_validated is not null
	 			and ifs.datesubmitted > {ts '2026-09-20 17:47:15'}

select top 3 rfq_id, rfq_title, rfq_time, prodgroup_id, state, ship_to_city, ship_to_detailed, buyer_cat
			from rfq_board
			where ssite_id = 1 and prodgroup_id = 56
			
			order by rfq_time DESC

select count(*) as rfqcount from rfq_board where ssite_id = 1 and prodgroup_id = 56

select top 4 ifss.cat_id, ifs.item_id, ifs.item_title, ifs.datesubmitted, 
						case when c.company_country_id = 27 then c.company_state
					     when c.company_country_id = 167 then c.company_state
					     else rn.country_short end as company_state
				from Items_For_Sale ifs, company c, items_for_sale_ssite ifss, ref_countries_new rn
				where c.company_id = ifs.company_id and ifss.item_id = ifs.item_id
				and c.company_country_id = rn.country_id
				and ifs.date_validated is not null
				and ifs.datesubmitted > {ts '2026-09-20 17:47:15'}
				and ifss.ssite_id = 1 and ifss.cat_id = 56 and ifs.item_id not in (911549,901532,901531,901535)
				
                order by ifs.date_validated desc

select count(*) as itemcount from items_for_sale ifs, items_for_sale_ssite ifss
				where ifs.item_id = ifss.item_id and ifss.ssite_id = 1 and ifss.cat_id = 56
				and ifs.date_validated is not null
	 			and ifs.datesubmitted > {ts '2026-09-20 17:47:15'}

select top 3 rfq_id, rfq_title, rfq_time, prodgroup_id, state, ship_to_city, ship_to_detailed, buyer_cat
			from rfq_board
			where ssite_id = 1 and prodgroup_id = 118
			
			order by rfq_time DESC

select count(*) as rfqcount from rfq_board where ssite_id = 1 and prodgroup_id = 118

select top 4 ifss.cat_id, ifs.item_id, ifs.item_title, ifs.datesubmitted, 
						case when c.company_country_id = 27 then c.company_state
					     when c.company_country_id = 167 then c.company_state
					     else rn.country_short end as company_state
				from Items_For_Sale ifs, company c, items_for_sale_ssite ifss, ref_countries_new rn
				where c.company_id = ifs.company_id and ifss.item_id = ifs.item_id
				and c.company_country_id = rn.country_id
				and ifs.date_validated is not null
				and ifs.datesubmitted > {ts '2026-09-20 17:47:15'}
				and ifss.ssite_id = 1 and ifss.cat_id = 118 and ifs.item_id not in (911549,901532,901531,901535)
				
                order by ifs.date_validated desc

select count(*) as itemcount from items_for_sale ifs, items_for_sale_ssite ifss
				where ifs.item_id = ifss.item_id and ifss.ssite_id = 1 and ifss.cat_id = 118
				and ifs.date_validated is not null
	 			and ifs.datesubmitted > {ts '2026-09-20 17:47:15'}

select top 3 rfq_id, rfq_title, rfq_time, prodgroup_id, state, ship_to_city, ship_to_detailed, buyer_cat
			from rfq_board
			where ssite_id = 1 and prodgroup_id = 57
			
			order by rfq_time DESC

select count(*) as rfqcount from rfq_board where ssite_id = 1 and prodgroup_id = 57

select top 4 ifss.cat_id, ifs.item_id, ifs.item_title, ifs.datesubmitted, 
						case when c.company_country_id = 27 then c.company_state
					     when c.company_country_id = 167 then c.company_state
					     else rn.country_short end as company_state
				from Items_For_Sale ifs, company c, items_for_sale_ssite ifss, ref_countries_new rn
				where c.company_id = ifs.company_id and ifss.item_id = ifs.item_id
				and c.company_country_id = rn.country_id
				and ifs.date_validated is not null
				and ifs.datesubmitted > {ts '2026-09-20 17:47:15'}
				and ifss.ssite_id = 1 and ifss.cat_id = 57 and ifs.item_id not in (911549,901532,901531,901535)
				
                order by ifs.date_validated desc

select count(*) as itemcount from items_for_sale ifs, items_for_sale_ssite ifss
				where ifs.item_id = ifss.item_id and ifss.ssite_id = 1 and ifss.cat_id = 57
				and ifs.date_validated is not null
	 			and ifs.datesubmitted > {ts '2026-09-20 17:47:15'}

select top 3 rfq_id, rfq_title, rfq_time, prodgroup_id, state, ship_to_city, ship_to_detailed, buyer_cat
			from rfq_board
			where ssite_id = 1 and prodgroup_id = 58
			
			order by rfq_time DESC

select count(*) as rfqcount from rfq_board where ssite_id = 1 and prodgroup_id = 58

select top 4 ifss.cat_id, ifs.item_id, ifs.item_title, ifs.datesubmitted, 
						case when c.company_country_id = 27 then c.company_state
					     when c.company_country_id = 167 then c.company_state
					     else rn.country_short end as company_state
				from Items_For_Sale ifs, company c, items_for_sale_ssite ifss, ref_countries_new rn
				where c.company_id = ifs.company_id and ifss.item_id = ifs.item_id
				and c.company_country_id = rn.country_id
				and ifs.date_validated is not null
				and ifs.datesubmitted > {ts '2026-09-20 17:47:15'}
				and ifss.ssite_id = 1 and ifss.cat_id = 58 and ifs.item_id not in (911549,901532,901531,901535)
				
                order by ifs.date_validated desc

select count(*) as itemcount from items_for_sale ifs, items_for_sale_ssite ifss
				where ifs.item_id = ifss.item_id and ifss.ssite_id = 1 and ifss.cat_id = 58
				and ifs.date_validated is not null
	 			and ifs.datesubmitted > {ts '2026-09-20 17:47:15'}

select top 3 rfq_id, rfq_title, rfq_time, prodgroup_id, state, ship_to_city, ship_to_detailed, buyer_cat
			from rfq_board
			where ssite_id = 1 and prodgroup_id = 115
			
			order by rfq_time DESC

select count(*) as rfqcount from rfq_board where ssite_id = 1 and prodgroup_id = 115

select top 4 ifss.cat_id, ifs.item_id, ifs.item_title, ifs.datesubmitted, 
						case when c.company_country_id = 27 then c.company_state
					     when c.company_country_id = 167 then c.company_state
					     else rn.country_short end as company_state
				from Items_For_Sale ifs, company c, items_for_sale_ssite ifss, ref_countries_new rn
				where c.company_id = ifs.company_id and ifss.item_id = ifs.item_id
				and c.company_country_id = rn.country_id
				and ifs.date_validated is not null
				and ifs.datesubmitted > {ts '2026-09-20 17:47:15'}
				and ifss.ssite_id = 1 and ifss.cat_id = 115 and ifs.item_id not in (911549,901532,901531,901535)
				
                order by ifs.date_validated desc

select count(*) as itemcount from items_for_sale ifs, items_for_sale_ssite ifss
				where ifs.item_id = ifss.item_id and ifss.ssite_id = 1 and ifss.cat_id = 115
				and ifs.date_validated is not null
	 			and ifs.datesubmitted > {ts '2026-09-20 17:47:15'}

select top 3 rfq_id, rfq_title, rfq_time, prodgroup_id, state, ship_to_city, ship_to_detailed, buyer_cat
			from rfq_board
			where ssite_id = 1 and prodgroup_id = 121
			
			order by rfq_time DESC

select count(*) as rfqcount from rfq_board where ssite_id = 1 and prodgroup_id = 121

select top 4 ifss.cat_id, ifs.item_id, ifs.item_title, ifs.datesubmitted, 
						case when c.company_country_id = 27 then c.company_state
					     when c.company_country_id = 167 then c.company_state
					     else rn.country_short end as company_state
				from Items_For_Sale ifs, company c, items_for_sale_ssite ifss, ref_countries_new rn
				where c.company_id = ifs.company_id and ifss.item_id = ifs.item_id
				and c.company_country_id = rn.country_id
				and ifs.date_validated is not null
				and ifs.datesubmitted > {ts '2026-09-20 17:47:15'}
				and ifss.ssite_id = 1 and ifss.cat_id = 121 and ifs.item_id not in (911549,901532,901531,901535)
				
                order by ifs.date_validated desc

select count(*) as itemcount from items_for_sale ifs, items_for_sale_ssite ifss
				where ifs.item_id = ifss.item_id and ifss.ssite_id = 1 and ifss.cat_id = 121
				and ifs.date_validated is not null
	 			and ifs.datesubmitted > {ts '2026-09-20 17:47:15'}

select top 3 rfq_id, rfq_title, rfq_time, prodgroup_id, state, ship_to_city, ship_to_detailed, buyer_cat
			from rfq_board
			where ssite_id = 1 and prodgroup_id = 59
			
			order by rfq_time DESC

select count(*) as rfqcount from rfq_board where ssite_id = 1 and prodgroup_id = 59

select top 4 ifss.cat_id, ifs.item_id, ifs.item_title, ifs.datesubmitted, 
						case when c.company_country_id = 27 then c.company_state
					     when c.company_country_id = 167 then c.company_state
					     else rn.country_short end as company_state
				from Items_For_Sale ifs, company c, items_for_sale_ssite ifss, ref_countries_new rn
				where c.company_id = ifs.company_id and ifss.item_id = ifs.item_id
				and c.company_country_id = rn.country_id
				and ifs.date_validated is not null
				and ifs.datesubmitted > {ts '2026-09-20 17:47:15'}
				and ifss.ssite_id = 1 and ifss.cat_id = 59 and ifs.item_id not in (911549,901532,901531,901535)
				
                order by ifs.date_validated desc

select count(*) as itemcount from items_for_sale ifs, items_for_sale_ssite ifss
				where ifs.item_id = ifss.item_id and ifss.ssite_id = 1 and ifss.cat_id = 59
				and ifs.date_validated is not null
	 			and ifs.datesubmitted > {ts '2026-09-20 17:47:15'}

select top 3 rfq_id, rfq_title, rfq_time, prodgroup_id, state, ship_to_city, ship_to_detailed, buyer_cat
			from rfq_board
			where ssite_id = 1 and prodgroup_id = 66
			
			order by rfq_time DESC

select count(*) as rfqcount from rfq_board where ssite_id = 1 and prodgroup_id = 66

select top 4 ifss.cat_id, ifs.item_id, ifs.item_title, ifs.datesubmitted, 
						case when c.company_country_id = 27 then c.company_state
					     when c.company_country_id = 167 then c.company_state
					     else rn.country_short end as company_state
				from Items_For_Sale ifs, company c, items_for_sale_ssite ifss, ref_countries_new rn
				where c.company_id = ifs.company_id and ifss.item_id = ifs.item_id
				and c.company_country_id = rn.country_id
				and ifs.date_validated is not null
				and ifs.datesubmitted > {ts '2026-09-20 17:47:15'}
				and ifss.ssite_id = 1 and ifss.cat_id = 66 and ifs.item_id not in (911549,901532,901531,901535)
				
                order by ifs.date_validated desc

select count(*) as itemcount from items_for_sale ifs, items_for_sale_ssite ifss
				where ifs.item_id = ifss.item_id and ifss.ssite_id = 1 and ifss.cat_id = 66
				and ifs.date_validated is not null
	 			and ifs.datesubmitted > {ts '2026-09-20 17:47:15'}

select top 3 rfq_id, rfq_title, rfq_time, prodgroup_id, state, ship_to_city, ship_to_detailed, buyer_cat
			from rfq_board
			where ssite_id = 1 and prodgroup_id = 73
			
			order by rfq_time DESC

select count(*) as rfqcount from rfq_board where ssite_id = 1 and prodgroup_id = 73

select top 4 ifss.cat_id, ifs.item_id, ifs.item_title, ifs.datesubmitted, 
						case when c.company_country_id = 27 then c.company_state
					     when c.company_country_id = 167 then c.company_state
					     else rn.country_short end as company_state
				from Items_For_Sale ifs, company c, items_for_sale_ssite ifss, ref_countries_new rn
				where c.company_id = ifs.company_id and ifss.item_id = ifs.item_id
				and c.company_country_id = rn.country_id
				and ifs.date_validated is not null
				and ifs.datesubmitted > {ts '2026-09-20 17:47:15'}
				and ifss.ssite_id = 1 and ifss.cat_id = 73 and ifs.item_id not in (911549,901532,901531,901535)
				
                order by ifs.date_validated desc

select count(*) as itemcount from items_for_sale ifs, items_for_sale_ssite ifss
				where ifs.item_id = ifss.item_id and ifss.ssite_id = 1 and ifss.cat_id = 73
				and ifs.date_validated is not null
	 			and ifs.datesubmitted > {ts '2026-09-20 17:47:15'}

select top 3 rfq_id, rfq_title, rfq_time, prodgroup_id, state, ship_to_city, ship_to_detailed, buyer_cat
			from rfq_board
			where ssite_id = 1 and prodgroup_id = 137
			
			order by rfq_time DESC

select count(*) as rfqcount from rfq_board where ssite_id = 1 and prodgroup_id = 137

select top 4 ifss.cat_id, ifs.item_id, ifs.item_title, ifs.datesubmitted, 
						case when c.company_country_id = 27 then c.company_state
					     when c.company_country_id = 167 then c.company_state
					     else rn.country_short end as company_state
				from Items_For_Sale ifs, company c, items_for_sale_ssite ifss, ref_countries_new rn
				where c.company_id = ifs.company_id and ifss.item_id = ifs.item_id
				and c.company_country_id = rn.country_id
				and ifs.date_validated is not null
				and ifs.datesubmitted > {ts '2026-09-20 17:47:15'}
				and ifss.ssite_id = 1 and ifss.cat_id = 137 and ifs.item_id not in (911549,901532,901531,901535)
				
                order by ifs.date_validated desc

select count(*) as itemcount from items_for_sale ifs, items_for_sale_ssite ifss
				where ifs.item_id = ifss.item_id and ifss.ssite_id = 1 and ifss.cat_id = 137
				and ifs.date_validated is not null
	 			and ifs.datesubmitted > {ts '2026-09-20 17:47:15'}

select top 3 rfq_id, rfq_title, rfq_time, prodgroup_id, state, ship_to_city, ship_to_detailed, buyer_cat
			from rfq_board
			where ssite_id = 1 and prodgroup_id = 128
			
			order by rfq_time DESC

select count(*) as rfqcount from rfq_board where ssite_id = 1 and prodgroup_id = 128

select top 4 ifss.cat_id, ifs.item_id, ifs.item_title, ifs.datesubmitted, 
						case when c.company_country_id = 27 then c.company_state
					     when c.company_country_id = 167 then c.company_state
					     else rn.country_short end as company_state
				from Items_For_Sale ifs, company c, items_for_sale_ssite ifss, ref_countries_new rn
				where c.company_id = ifs.company_id and ifss.item_id = ifs.item_id
				and c.company_country_id = rn.country_id
				and ifs.date_validated is not null
				and ifs.datesubmitted > {ts '2026-09-20 17:47:15'}
				and ifss.ssite_id = 1 and ifss.cat_id = 128 and ifs.item_id not in (911549,901532,901531,901535)
				
                order by ifs.date_validated desc

select count(*) as itemcount from items_for_sale ifs, items_for_sale_ssite ifss
				where ifs.item_id = ifss.item_id and ifss.ssite_id = 1 and ifss.cat_id = 128
				and ifs.date_validated is not null
	 			and ifs.datesubmitted > {ts '2026-09-20 17:47:15'}

select top 3 rfq_id, rfq_title, rfq_time, prodgroup_id, state, ship_to_city, ship_to_detailed, buyer_cat
			from rfq_board
			where ssite_id = 1 and prodgroup_id = 125
			
			order by rfq_time DESC

select count(*) as rfqcount from rfq_board where ssite_id = 1 and prodgroup_id = 125

ads_updatetracktable (Datasource=westmain, Time=47ms) in C:\home\woodplanet.com\wwwroot\devtest_release_new\include\ad_track.cfm @ 17:47:14.014

	parameters type CFSQLType value variable dbVarName  IN  cf_sql_integer  99      IN  cf_sql_timestamp  2026-10-20 17:47:14.761      IN  cf_sql_varchar  216.73.216.254      IN  cf_sql_varchar  imp      IN  cf_sql_varchar  newuser      IN  cf_sql_varchar  /woodplanet_home.cfm      IN  cf_sql_varchar        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:\home\woodplanet.com\wwwroot\release_new\woodplanet_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=*/*
HTTP_ACCEPT_ENCODING=gzip, br, zstd, deflate
HTTP_ACCEPT_LANGUAGE=
HTTP_CONNECTION=keep-alive
HTTP_COOKIE=
HTTP_HOST=www.woodplanet.com
HTTP_REFERER=
HTTP_URL=/woodplanet_home.cfm
HTTP_USER_AGENT=Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)
LOCAL_ADDR=45.86.37.204
PATH_INFO=
PATH_TRANSLATED=C:\home\woodplanet.com\wwwroot\release_new\woodplanet_home.cfm
QUERY_STRING=
REMOTE_ADDR=216.73.216.254
REMOTE_HOST=216.73.216.254
REMOTE_USER=
REQUEST_METHOD=GET
SCRIPT_NAME=/woodplanet_home.cfm
SERVER_NAME=www.woodplanet.com
SERVER_PORT=80
SERVER_PORT_SECURE=0
SERVER_PROTOCOL=HTTP/1.1
SERVER_SOFTWARE=Microsoft-IIS/10.0
WEB_SERVER_API=

Cookie Variables:
AD=14
AD_DTSTAMP={ts '2026-10-20 17:47:14'}