Springfield XDS 4.0 Single Stack 45ACP Bi-Tone

select style from tb_styles with (nolock) where style_id=?

select a.*,b.scale_id,b.attr1_id,b.attr2_id 
	 from web_all_products a WITH(NOLOCK)
	 inner join tb_styles b WITH(NOLOCK) on (b.style_id = a.style_id) 
	 where a.style_id=? and a.dept <>'California Guns'
	 order by a.dept asc

SELECT *
FROM 
tb_mfg_promo.dbo.tb_mfg_promos a WITH (NOLOCK)
INNER JOIN tb_mfg_promo.dbo.tb_mfg_promo_items b WITH (NOLOCK)
    ON (a.promo_id = b.promo_id)
where b.style_id = 143155 
and (a.start_date<= 'May 20, 2024 15:12:12' or a.active = 1)
and a.end_date >= '05/20/2024'
order by a.promo_id desc

select * from get_promos143155

Select web_url, dept from tb_web_taxonomy with (nolock) where dept = 'Firearms' and typ='EMPTY' and site = 'sportsman' and dept <>'California Guns'

Select web_url from tb_web_taxonomy with (nolock) where dept = 'Firearms' and typ='Handgun Semi-Auto' and subtyp_1='EMPTY' and site = 'sportsman'

Select * FROM tb_mfg_promo.dbo.tb_new_version where new_style_id='143155'

select * from tb_product_reviews with (nolock)
                            where (style_id=?)
                            and status='A' and site = 'sportsman'

select sum(CAST(custom_rating_1 AS INTEGER)) as custom_rating_1 from tb_product_reviews  with (nolock)
                            where (style_id=?)
                            and status='A' 
                            and site = 'sportsman'

select * from tb_alt_pictures with (nolock) where style_id=143155

select e.qc as qc, max(e.sugg_price) as sugg_price, sum(e.qoh + e.qc) as qoh
                        from tb_skus a WITH(NOLOCK)
                        left join tb_sku_buckets e WITH(NOLOCK) on (e.sku_id = a.sku_id)
                        where a.style_id = 143155
                        and e.store_id = 10
                        group by a.style_id, qc

select e.sku_bucket_id, e.price, e.sugg_price, (e.qoh + e.qc) as qoh, z.of15,e.last_cost
	from 
	tb_styles z with (nolock) inner join tb_skus a with (nolock) on (z.style_id=a.style_id)
	inner join tb_parts b with (nolock) on (a.STYLE_ID=b.STYLE_ID)
	inner join tb_sku_buckets e with (nolock) on (e.sku_id = a.sku_id)
	where a.style_id = 143155 and b.contact_id=22620 and (e.qoh + e.qc) >= 1
	and e.store_id = 27 and (e.last_cost>0 and z.of15 is not NULL) 
	and z.brand not in (?,?,?,?,?,?,?,?,?)

select a.style_id, min(e.price) as minprice, max(e.price) as maxprice,max(e.sugg_price) as sugg_price1,max(e.first_price) as first_price, max(e.wholesale_price) as vipprice
		from tb_skus a WITH(NOLOCK)
		left join tb_sku_buckets e WITH(NOLOCK) on (e.sku_id = a.sku_id)
		where a.style_id = ?
		and e.store_id =10
		group by a.style_id
		order by a.style_id

select *
			from tb_term_sale_entries with (nolock)
			where start_date<= 'May 20, 2024 15:12:12' and
			end_date >= 'May 20, 2024 15:12:12'
			and store_id=10 and style_id=?

select * from tb_quantityprice with (nolock) where start_date <{ts '2024-05-20 15:12:12'} and end_date >{ts '2024-05-20 15:12:12'} and quantityprice_id in (select quantityprice_id from tb_quantityprice_items where style_id=? and store_id=10)

select distinct bulk_id, max(prc_dis) as prc_dis, max(qty) as qty, max(qty_multiple) as qty_multiple from tb_mfg_promo.dbo.BULK_ITM_DSCS with (nolock) where bulk_id = ? and site is NULL
							group by bulk_id

SELECT *
FROM 
	tb_mfg_promo.dbo.tb_pkg a WITH (NOLOCK)
	INNER JOIN tb_mfg_promo.dbo.tb_pkg_main_items b WITH (NOLOCK)
		ON (a.pkg_id = b.pkg_id)
where 
b.main_id = 143155 and a.start_date<= '05/20/2024 23:59:00' and a.end_date >= '05/20/2024' and site='sportsman'

select distinct 
	b.style_id, max(b.web_desc) as web_desc, max(b.brand) as brand, max(b.picture_id) as picture_id, min(a.price) as price, max(d.price) as max_price, sum(d.qoh + d.qc) as qoh, max(a.end_date) as end_date
	from tb_mfg_promo.dbo.tb_discount_offer a with (nolock)
	INNER JOIN tb_styles b WITH (NOLOCK) ON (a.child_id = b.style_id) 
	INNER JOIN tb_skus c WITH (NOLOCK) ON (b.style_id = c.style_id) 
	INNER JOIN tb_sku_buckets d WITH (NOLOCK) ON (c.sku_id = d.sku_id) 
	where a.parent_id=143155 and a.start_date<= 'May 20, 2024 15:12:12' and a.end_date >= 'May 20, 2024 15:12:12' and a.site='sportsman' and d.store_id=10 and qoh>0 
	group by b.style_id

SELECT * from GetAssociatedMain with (nolock)

select distinct style_id, min(min_price) as min_price,	max(max_price) as max_price,	max(web_style) as web_style, max(style) as style,	max(web_desc) as web_desc,	max(web_description) as web_description,	max(picture_id) as picture_id,   max(dept) as dept, max(typ) as typ, max(subtyp_1) as subtyp_1,   max(qoh) as qoh,	max(qc) as qc,	max(qs) as qs,	sum(qoh + qc) as available,	sum(qs - qc) as sold, max(of1) as of1,	max(of2) as of2,max(of3) as of3, max(of4) as of4,	max(of5) as of5,max(of6) as of6,max(of12) as of12, max(brand) as brand,	MAX(max_sugg_price) AS max_sugg_price, max(non_invt) as non_invt
from GetAssociatedMain where style_id is not null and dept='Firearms' and style_id<>143155 and (available>0 or non_invt='Y')
AND 


(of2='XDS' or of3='45 ACP') 
AND 
typ='Handgun Semi-Auto' 
AND 
(of4='' or of5='CARRY CONCEAL' or brand='SPRINGFIELD')

group by Style_id order by qc asc, sold desc

select distinct style_id, min(min_price) as min_price,	max(max_price) as max_price,	max(web_style) as web_style, max(style) as style,	max(web_desc) as web_desc,	max(web_description) as web_description,	max(picture_id) as picture_id,   max(dept) as dept, max(typ) as typ, max(subtyp_1) as subtyp_1,   max(qoh) as qoh,	max(qc) as qc,	max(qs) as qs,	sum(qoh + qc) as available,	sum(qs - qc) as sold, max(of1) as of1,	max(of2) as of2,max(of3) as of3, max(of4) as of4,	max(of5) as of5, max(of6) as of6, max(of9) as of9,max(of12) as of12, max(brand) as brand,	MAX(max_sugg_price) AS max_sugg_price
from GetAssociatedMain where style_id is not null and dept='Ammo' and style_id<>143155 and available>0 
AND

of3='45 ACP'

group by Style_id order by qc asc, sold desc

select distinct style_id, min(min_price) as min_price,	max(max_price) as max_price,	max(web_style) as web_style, max(style) as style,	max(web_desc) as web_desc,	max(web_description) as web_description,	max(picture_id) as picture_id,   max(dept) as dept, max(typ) as typ, max(subtyp_1) as subtyp_1,   max(qoh) as qoh,	max(qc) as qc,	max(qs) as qs,	sum(qoh + qc) as available,	sum(qs - qc) as sold, max(of1) as of1,	max(of2) as of2,max(of3) as of3, max(of4) as of4,	max(of5) as of5,max(of6) as of6,max(of12) as of12, max(brand) as brand,	MAX(max_sugg_price) AS max_sugg_price
from GetAssociatedMain where style_id is not null and typ='Magazines' and style_id<>143155 and available>0 and 

(of2='XDS' or (of4='' and of4 <>''))
AND
of3='45 ACP'

group by Style_id order by qc asc, sold desc

select typ,amount,end_date,term_sale_id
from tb_term_sale_entries with (nolock)
where start_date<= 'May 20, 2024 15:12:12' and
end_date >= 'May 20, 2024 15:12:12'
and store_id=10 and style_id=282860

select typ,amount,end_date,term_sale_id
from tb_term_sale_entries with (nolock)
where start_date<= 'May 20, 2024 15:12:12' and
end_date >= 'May 20, 2024 15:12:12'
and store_id=10 and style_id=303569

select typ,amount,end_date,term_sale_id
from tb_term_sale_entries with (nolock)
where start_date<= 'May 20, 2024 15:12:12' and
end_date >= 'May 20, 2024 15:12:12'
and store_id=10 and style_id=23552

select typ,amount,end_date,term_sale_id
from tb_term_sale_entries with (nolock)
where start_date<= 'May 20, 2024 15:12:12' and
end_date >= 'May 20, 2024 15:12:12'
and store_id=10 and style_id=273596

select typ,amount,end_date,term_sale_id
from tb_term_sale_entries with (nolock)
where start_date<= 'May 20, 2024 15:12:12' and
end_date >= 'May 20, 2024 15:12:12'
and store_id=10 and style_id=169806

select typ,amount,end_date,term_sale_id
from tb_term_sale_entries with (nolock)
where start_date<= 'May 20, 2024 15:12:12' and
end_date >= 'May 20, 2024 15:12:12'
and store_id=10 and style_id=289944

select typ,amount,end_date,term_sale_id
from tb_term_sale_entries with (nolock)
where start_date<= 'May 20, 2024 15:12:12' and
end_date >= 'May 20, 2024 15:12:12'
and store_id=10 and style_id=278322

select typ,amount,end_date,term_sale_id
from tb_term_sale_entries with (nolock)
where start_date<= 'May 20, 2024 15:12:12' and
end_date >= 'May 20, 2024 15:12:12'
and store_id=10 and style_id=219779

select typ,amount,end_date,term_sale_id
from tb_term_sale_entries with (nolock)
where start_date<= 'May 20, 2024 15:12:12' and
end_date >= 'May 20, 2024 15:12:12'
and store_id=10 and style_id=122481

select typ,amount,end_date,term_sale_id
from tb_term_sale_entries with (nolock)
where start_date<= 'May 20, 2024 15:12:12' and
end_date >= 'May 20, 2024 15:12:12'
and store_id=10 and style_id=245845

select typ,amount,end_date,term_sale_id
from tb_term_sale_entries with (nolock)
where start_date<= 'May 20, 2024 15:12:12' and
end_date >= 'May 20, 2024 15:12:12'
and store_id=10 and style_id=273595

select typ,amount,end_date,term_sale_id
from tb_term_sale_entries with (nolock)
where start_date<= 'May 20, 2024 15:12:12' and
end_date >= 'May 20, 2024 15:12:12'
and store_id=10 and style_id=262879

select typ,amount,end_date,term_sale_id
from tb_term_sale_entries with (nolock)
where start_date<= 'May 20, 2024 15:12:12' and
end_date >= 'May 20, 2024 15:12:12'
and store_id=10 and style_id=172052

select sum(e.qoh + e.qc) as qoh ,sum(e.qc) as qc,sum(e.qs - e.qc) as sold
								from tb_skus a  with (nolock)
								left join tb_sku_buckets e with (nolock) on (e.sku_id = a.sku_id) 
								where a.style_id = 143155 and e.store_id = 10 
								group by a.style_id, e.qc

select distinct bulk_id, max(prc_dis) as prc_dis, max(qty) as qty from tb_mfg_promo.dbo.BULK_ITM_DSCS with (nolock) where bulk_id = ? and site is NULL
											group by bulk_id

select typ,amount,end_date,term_sale_id
from tb_term_sale_entries with (nolock)
where start_date<= 'May 20, 2024 15:12:12' and
end_date >= 'May 20, 2024 15:12:12'
and store_id=10 and style_id=309573

select sum(e.qoh + e.qc) as qoh ,sum(e.qc) as qc,sum(e.qs - e.qc) as sold
								from tb_skus a  with (nolock)
								left join tb_sku_buckets e with (nolock) on (e.sku_id = a.sku_id) 
								where a.style_id = 143155 and e.store_id = 10 
								group by a.style_id, e.qc

select distinct bulk_id, max(prc_dis) as prc_dis, max(qty) as qty from tb_mfg_promo.dbo.BULK_ITM_DSCS with (nolock) where bulk_id = ? and site is NULL
											group by bulk_id

select typ,amount,end_date,term_sale_id
from tb_term_sale_entries with (nolock)
where start_date<= 'May 20, 2024 15:12:12' and
end_date >= 'May 20, 2024 15:12:12'
and store_id=10 and style_id=172271

select sum(e.qoh + e.qc) as qoh ,sum(e.qc) as qc,sum(e.qs - e.qc) as sold
								from tb_skus a  with (nolock)
								left join tb_sku_buckets e with (nolock) on (e.sku_id = a.sku_id) 
								where a.style_id = 143155 and e.store_id = 10 
								group by a.style_id, e.qc

select distinct bulk_id, max(prc_dis) as prc_dis, max(qty) as qty from tb_mfg_promo.dbo.BULK_ITM_DSCS with (nolock) where bulk_id = ? and site is NULL
											group by bulk_id

select typ,amount,end_date,term_sale_id
from tb_term_sale_entries with (nolock)
where start_date<= 'May 20, 2024 15:12:12' and
end_date >= 'May 20, 2024 15:12:12'
and store_id=10 and style_id=86668

select sum(e.qoh + e.qc) as qoh ,sum(e.qc) as qc,sum(e.qs - e.qc) as sold
								from tb_skus a  with (nolock)
								left join tb_sku_buckets e with (nolock) on (e.sku_id = a.sku_id) 
								where a.style_id = 143155 and e.store_id = 10 
								group by a.style_id, e.qc

select distinct bulk_id, max(prc_dis) as prc_dis, max(qty) as qty from tb_mfg_promo.dbo.BULK_ITM_DSCS with (nolock) where bulk_id = ? and site is NULL
											group by bulk_id

select typ,amount,end_date,term_sale_id
from tb_term_sale_entries with (nolock)
where start_date<= 'May 20, 2024 15:12:12' and
end_date >= 'May 20, 2024 15:12:12'
and store_id=10 and style_id=290145

select sum(e.qoh + e.qc) as qoh ,sum(e.qc) as qc,sum(e.qs - e.qc) as sold
								from tb_skus a  with (nolock)
								left join tb_sku_buckets e with (nolock) on (e.sku_id = a.sku_id) 
								where a.style_id = 143155 and e.store_id = 10 
								group by a.style_id, e.qc

select distinct bulk_id, max(prc_dis) as prc_dis, max(qty) as qty from tb_mfg_promo.dbo.BULK_ITM_DSCS with (nolock) where bulk_id = ? and site is NULL
											group by bulk_id

select typ,amount,end_date,term_sale_id
from tb_term_sale_entries with (nolock)
where start_date<= 'May 20, 2024 15:12:12' and
end_date >= 'May 20, 2024 15:12:12'
and store_id=10 and style_id=61122

select sum(e.qoh + e.qc) as qoh ,sum(e.qc) as qc,sum(e.qs - e.qc) as sold
								from tb_skus a  with (nolock)
								left join tb_sku_buckets e with (nolock) on (e.sku_id = a.sku_id) 
								where a.style_id = 143155 and e.store_id = 10 
								group by a.style_id, e.qc

select distinct bulk_id, max(prc_dis) as prc_dis, max(qty) as qty from tb_mfg_promo.dbo.BULK_ITM_DSCS with (nolock) where bulk_id = ? and site is NULL
											group by bulk_id

select typ,amount,end_date,term_sale_id
from tb_term_sale_entries with (nolock)
where start_date<= 'May 20, 2024 15:12:12' and
end_date >= 'May 20, 2024 15:12:12'
and store_id=10 and style_id=121694

select sum(e.qoh + e.qc) as qoh ,sum(e.qc) as qc,sum(e.qs - e.qc) as sold
								from tb_skus a  with (nolock)
								left join tb_sku_buckets e with (nolock) on (e.sku_id = a.sku_id) 
								where a.style_id = 143155 and e.store_id = 10 
								group by a.style_id, e.qc

select distinct bulk_id, max(prc_dis) as prc_dis, max(qty) as qty from tb_mfg_promo.dbo.BULK_ITM_DSCS with (nolock) where bulk_id = ? and site is NULL
											group by bulk_id

select typ,amount,end_date,term_sale_id
from tb_term_sale_entries with (nolock)
where start_date<= 'May 20, 2024 15:12:12' and
end_date >= 'May 20, 2024 15:12:12'
and store_id=10 and style_id=150679

select sum(e.qoh + e.qc) as qoh ,sum(e.qc) as qc,sum(e.qs - e.qc) as sold
								from tb_skus a  with (nolock)
								left join tb_sku_buckets e with (nolock) on (e.sku_id = a.sku_id) 
								where a.style_id = 143155 and e.store_id = 10 
								group by a.style_id, e.qc

select distinct bulk_id, max(prc_dis) as prc_dis, max(qty) as qty from tb_mfg_promo.dbo.BULK_ITM_DSCS with (nolock) where bulk_id = ? and site is NULL
											group by bulk_id

select typ,amount,end_date,term_sale_id
from tb_term_sale_entries with (nolock)
where start_date<= 'May 20, 2024 15:12:12' and
end_date >= 'May 20, 2024 15:12:12'
and store_id=10 and style_id=24727

select sum(e.qoh + e.qc) as qoh ,sum(e.qc) as qc,sum(e.qs - e.qc) as sold
								from tb_skus a  with (nolock)
								left join tb_sku_buckets e with (nolock) on (e.sku_id = a.sku_id) 
								where a.style_id = 143155 and e.store_id = 10 
								group by a.style_id, e.qc

select distinct bulk_id, max(prc_dis) as prc_dis, max(qty) as qty from tb_mfg_promo.dbo.BULK_ITM_DSCS with (nolock) where bulk_id = ? and site is NULL
											group by bulk_id

select typ,amount,end_date,term_sale_id
from tb_term_sale_entries with (nolock)
where start_date<= 'May 20, 2024 15:12:12' and
end_date >= 'May 20, 2024 15:12:12'
and store_id=10 and style_id=161435

select sum(e.qoh + e.qc) as qoh ,sum(e.qc) as qc,sum(e.qs - e.qc) as sold
								from tb_skus a  with (nolock)
								left join tb_sku_buckets e with (nolock) on (e.sku_id = a.sku_id) 
								where a.style_id = 143155 and e.store_id = 10 
								group by a.style_id, e.qc

select distinct bulk_id, max(prc_dis) as prc_dis, max(qty) as qty from tb_mfg_promo.dbo.BULK_ITM_DSCS with (nolock) where bulk_id = ? and site is NULL
											group by bulk_id

select typ,amount,end_date,term_sale_id
from tb_term_sale_entries with (nolock)
where start_date<= 'May 20, 2024 15:12:12' and
end_date >= 'May 20, 2024 15:12:12'
and store_id=10 and style_id=72706

select sum(e.qoh + e.qc) as qoh ,sum(e.qc) as qc,sum(e.qs - e.qc) as sold
								from tb_skus a  with (nolock)
								left join tb_sku_buckets e with (nolock) on (e.sku_id = a.sku_id) 
								where a.style_id = 143155 and e.store_id = 10 
								group by a.style_id, e.qc

select distinct bulk_id, max(prc_dis) as prc_dis, max(qty) as qty from tb_mfg_promo.dbo.BULK_ITM_DSCS with (nolock) where bulk_id = ? and site is NULL
											group by bulk_id

select typ,amount,end_date,term_sale_id
from tb_term_sale_entries with (nolock)
where start_date<= 'May 20, 2024 15:12:12' and
end_date >= 'May 20, 2024 15:12:12'
and store_id=10 and style_id=39334

select sum(e.qoh + e.qc) as qoh ,sum(e.qc) as qc,sum(e.qs - e.qc) as sold
								from tb_skus a  with (nolock)
								left join tb_sku_buckets e with (nolock) on (e.sku_id = a.sku_id) 
								where a.style_id = 143155 and e.store_id = 10 
								group by a.style_id, e.qc

select distinct bulk_id, max(prc_dis) as prc_dis, max(qty) as qty from tb_mfg_promo.dbo.BULK_ITM_DSCS with (nolock) where bulk_id = ? and site is NULL
											group by bulk_id

select typ,amount,end_date,term_sale_id
from tb_term_sale_entries with (nolock)
where start_date<= 'May 20, 2024 15:12:12' and
end_date >= 'May 20, 2024 15:12:12'
and store_id=10 and style_id=168824

select * from tb_mfg_promo.dbo.tb_video_url where style_id=143155 and site <> 'outdoors'

select * from tb_product_reviews  with (nolock)
where (style_id=?)  
and status='A' and site = 'sportsman'
order by dte desc

select sum(CAST(custom_rating_1 AS INTEGER)) as custom_rating_1 from tb_product_reviews with (nolock)
where (style_id=?)
and status='A' 
and site = 'sportsman'

Application Variables:
acceptorid=011668467
accountid=1027380
accounttoken=64BB6980FDEAF842266AC866F250CA9877FF24AE92795FB9BE490EAF527645FC4E54DC01
adminurl=https://www.sportsmansoutdoorsuperstore.com/web_admin/products/menu.cfm?style_id=
applicationname=SOS
bannerurl=https://www.sportsmansoutdoorsuperstore.com/images/banners/
ccprocessor=VANTIV
checkinventory=Struct (3)
companyname=Vance Outdoors
credova=Struct (5)
ds=celerantsql
enter_inscription=OFF
feedsdir=E:\inetpub\feeds\
forumemail=info@sportsmansoutdoorsuperstore.com
forumtitle=Sportsmans Outdoor Superstore
giftcardimgpath=file:///C:/websites/images/
giftcardpdfpath=E:\websites\giftcardPDF\
googlefeedproducttype=
homeurl=https://www.sportsmansoutdoorsuperstore.com/
hostedpagelink=https://transaction.hostedpayments.com/
iconurl=https://www.sportsmansoutdoorsuperstore.com/images/icons/
imagedir=E:\inetpub\images\
logdir=E:\inetpub\logs
metadesc=
metatags=
mydomain=https://www.sportsmansoutdoorsuperstore.com/
pagetitle=
picurl=https://www.sportsmansoutdoorsuperstore.com/images/
prodimgdir=E:\inetpub\prodimages\
prodimgurl=https://www.sportsmansoutdoorsuperstore.com/prodimages/
qoh_store=10
safety_stock=0
salesemail=sales@sportsmansoutdoorsuperstore.com
secureurl=https://www.sportsmansoutdoorsuperstore.com/
site=sportsman
tempmailport=25
tempmailserver=127.0.0.1
tokenurl=https://services.elementexpress.com/express.asmx
use_multi_buy=OFF
vantivurl=https://transaction.elementexpress.com/express.asmx
webadminurl=https://www.sportsmansoutdoorsuperstore.com/web_admin/
websitename=Sportsmans Outdoor Superstore

CGI Variables:
AUTH_PASSWORD=
AUTH_TYPE=
AUTH_USER=
CERT_COOKIE=
CERT_FLAGS=
CERT_ISSUER=
CERT_KEYSIZE=256
CERT_SECRETKEYSIZE=2048
CERT_SERIALNUMBER=
CERT_SERVER_ISSUER=C=US, O=Let's Encrypt, CN=R3
CERT_SERVER_SUBJECT=CN=www.sportsmansoutdoorsuperstore.com
CERT_SUBJECT=
CF_TEMPLATE_PATH=E:\inetpub\wwwroot\products2.cfm
CONTENT_LENGTH=0
CONTENT_TYPE=
CONTEXT_PATH=
GATEWAY_INTERFACE=CGI/1.1
HTTPS=on
HTTPS_KEYSIZE=256
HTTPS_SECRETKEYSIZE=2048
HTTPS_SERVER_ISSUER=C=US, O=Let's Encrypt, CN=R3
HTTPS_SERVER_SUBJECT=CN=www.sportsmansoutdoorsuperstore.com
HTTP_ACCEPT=*/*
HTTP_ACCEPT_ENCODING=gzip, br, zstd, deflate
HTTP_ACCEPT_LANGUAGE=
HTTP_CONNECTION=close
HTTP_COOKIE=CFGLOBALS=urltoken%3DCFID%23%3D12753%26CFTOKEN%23%3D1c4d342fd6495c7e%2DEA2A66A4%2DCFBF%2DC554%2DA293F0DF44349D8F%23lastvisit%3D%7Bts%20%272024%2D05%2D20%2015%3A12%3A12%27%7D%23hitcount%3D55%23timecreated%3D%7Bts%20%272024%2D05%2D20%2015%3A11%3A39%27%7D%23cftoken%3D1c4d342fd6495c7e%2DEA2A66A4%2DCFBF%2DC554%2DA293F0DF44349D8F%23cfid%3D12753%23; CFTOKEN=Z98olbwg5rxrj4kxa625akg5dpmaa354uo66g173yqvk4tox9o-1c4d342fd6495c7e-EA2A66A4-CFBF-C554-A293F0DF44349D8F; CFID=Z98olbwg5rxrj4kxa625akg5dpmaa354uo66g173yqvk4tox9o-12753; USERNAME=; CUSTOMER_ID=; CT_U=2236; EMAIL=; FIRST_NAME=; LAST_NAME=; PASSWORD=; PRD_U=307931%2C3809
HTTP_HOST=www.sportsmansoutdoorsuperstore.com
HTTP_REFERER=
HTTP_URL=/products2.cfm/ID/143155/xds94045s/springfield-xds-4.0-single-stack-45acp-bi-tone
HTTP_USER_AGENT=Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)
LOCAL_ADDR=10.200.30.6
PATH_INFO=/ID/143155/xds94045s/springfield-xds-4.0-single-stack-45acp-bi-tone
PATH_TRANSLATED=E:\inetpub\wwwroot\products2.cfm
QUERY_STRING=
REMOTE_ADDR=10.200.2.4
REMOTE_HOST=10.200.2.4
REMOTE_USER=
REQUEST_METHOD=GET
SCRIPT_NAME=/products2.cfm
SERVER_NAME=www.sportsmansoutdoorsuperstore.com
SERVER_PORT=443
SERVER_PORT_SECURE=1
SERVER_PROTOCOL=HTTP/1.1
SERVER_SOFTWARE=Microsoft-IIS/10.0
WEB_SERVER_API=

Client Variables:
cfid=12753
cftoken=1c4d342fd6495c7e-EA2A66A4-CFBF-C554-A293F0DF44349D8F
hitcount=55
lastvisit={ts '2024-05-20 15:12:12'}
timecreated={ts '2024-05-20 15:11:39'}
urltoken=CFID=12753&CFTOKEN=1c4d342fd6495c7e-EA2A66A4-CFBF-C554-A293F0DF44349D8F

Cookie Variables:
CFGLOBALS=urltoken=CFID#=12753&CFTOKEN#=1c4d342fd6495c7e-EA2A66A4-CFBF-C554-A293F0DF44349D8F#lastvisit={ts '2024-05-20 15:12:12'}#hitcount=55#timecreated={ts '2024-05-20 15:11:39'}#cftoken=1c4d342fd6495c7e-EA2A66A4-CFBF-C554-A293F0DF44349D8F#cfid=12753#
CFID=12753
CFTOKEN=1c4d342fd6495c7e-EA2A66A4-CFBF-C554-A293F0DF44349D8F
CT_U=2236
CUSTOMER_ID=
EMAIL=
FIRST_NAME=
LAST_NAME=
PASSWORD=
PRD_U=143155,85
USERNAME=

Form Fields:
RETURN_TO_PAGE=null

Request Parameters:
samesite_value=

Server Variables:
coldfusion=Struct (10)
os=Struct (5)
system=Struct (2)

Session Variables:
cfid=12753
cftoken=1c4d342fd6495c7e-EA2A66A4-CFBF-C554-A293F0DF44349D8F
cs=/category.cfm/sportsman/belt-holsters/brand/desantis/make/keltec/model/p238
displaycount=18
employeeloggedin=N
fflnote=
firearm_agreement=NO
imgarray=Array (0)
memberloggedin=N
pickupstore=10
prodtype=none
selected_ffl=NO
sessionid=SOS_12753_1c4d342fd6495c7e-EA2A66A4-CFBF-C554-A293F0DF44349D8F
strarray=Array (0)
urltoken=CFID=12753&CFTOKEN=1c4d342fd6495c7e-EA2A66A4-CFBF-C554-A293F0DF44349D8F

URL Parameters:
ATTR1=
ATTR2=
BRAND=
CLEARANCE=
DEPT=Firearms
ID=143155
MULTIBUYITEM=NO
NAV_CHOOSER=
OF1=
OF10=
OF2=
OF3=
OF4=
OF5=
OF6=
ORDER_BY=
PRODTYPE=none
RETURN_TO_PAGE=null
SECTION=
SIZ=
SORTBY=
SPORTSMAN=
SUBTYP_1=EMPTY
SUBTYP_2=
SUBTYP_3=
TYP=Handgun Semi-Auto
WHATSNEW=
xds94045s=springfield-xds-4.0-single-stack-45acp-bi-tone