Henry 45/70 Lever Action Rifle with Adjustable Semi-Buckhorn Sight

  • Item Number: H010
  • /
  • View More Items by Henry
  • /
  • Condition: NEW
$799.99 $893.00

No Longer Available
This product is no longer available. We don't know when or if it will be back in stock.
  • HENRY REPEATING ARMS BIG BOY BRASS SIDE GATE 357 MAGNUM/38 SPECIAL LEVER ACTION RIFLE WITH 20 INCH OC

    Henry Big Boy Brass Side Gate 357 Magnum/38 Special Lever Action Rifle with 20 inch Oc
    $1,124.00 $859.99

  • HENRY REPEATING ARMS H004M GOLDEN BOY 22MAG LEVER ACTION

    Henry Golden Boy 22 Magnum Lever Action Rimfire Rifle
    $688.00 $529.99

  • HENRY REPEATING ARMS BIG BOY 45LC COLT 20 IN BBL SIDE GATE

    Henry Big Boy Brass Side Gate 45 Colt Lever Action Rifle with 20 inch Octgonal Barrel
    $1,124.00 $849.99

  • HENRY REPEATING ARMS SIDE GATE 360 BUCKHAMMER

    Henry Side Gate 360 Buckhammer Lever Action Rifle with 20 Inch Barrel
    $1,248.00 $919.99

  • HENRY REPEATING ARMS H004 GOLDEN BOY 22LR LEVER ACTION RIFLE

    Henry Golden Boy 22 Caliber Lever Action Rimfire Rifle
    $617.00 $479.99

  • HENRY REPEATING ARMS SIDE GATE BIG BOY STEEL 357MAG/38SPL LEVER ACTION

    Henry Big Boy Steel 357 Magnum/38 Special Side Gate Lever Action Rifle
    $1,017.00 $809.99

  • HENRY REPEATING ARMS H001MLL 22 MAG LEVER ACTION LARGE LOOP

    Henry 22 Magnum Lever Action Rifle with Large Loop
    $597.00 $499.99

  • HENRY REPEATING ARMS SIDE GATE BIG BOY STEEL 44 MAG LARGE LOOP

    Henry Big Boy Steel 44 Magnum Lever Action Side Gate Rifle with Large Loop
    $1,110.00 $819.99

  • HENRY REPEATING ARMS H009X-360BH 360BUCKHAMMER LEVER ACTION X MODEL

    Henry Lever-Action X Model 360 Buckhammer with Black Synthetic Stock
    $1,091.00 $829.99

  • HENRY REPEATING ARMS SIDE GATE 45COLT 10+1 20` BLUED OCTAGON BARREL

    Henry Big Boy Brass Side Gate 45 Colt Lever-Action Rifle w/Large Loop
    $1,142.00 $869.99

  • ROSSI R95 45-70 GOVERNMENT 16.5 IN BBL TRAPPER

    Rossi R95 Trapper 45-70 Govt. Lever-Action Rifle with Threaded Barrel
    $1,060.99 $799.99

  • HENRY REPEATING ARMS H001 .22 LEVER ACTION RIFLE

    Henry 22 Caliber Lever Action Rifle
    $405.00 $324.99

  • Hornady 45-70 Govt 325 gr FTX LEVERevolution 20/Box

    Hornady 45-70 Govt 325 gr FTX LEVERevolution 20/Box
    $36.99
    ($1.85 / round)

  • Hornady 45-70 Govt 250 gr Monoflex LEVERevolution 20/Box

    Hornady 45-70 Govt 250 gr Monoflex LEVERevolution 20/Box
    $53.97 $44.99
    ($2.25 / round)

  • Winchester 45-70 Govt 300 gr Jacketed Hollow Point JHP Super X 20/Box

    Winchester 45-70 Govt 300 gr Jacketed Hollow Point JHP Super X 20/Box
    $44.99
    ($2.25 / round)

  • Federal 45-70 Govt 300 gr Speer Hot-Cor HP Power-Shok 20/Box

    Federal 45-70 Govt 300 gr Speer Hot-Cor HP Power-Shok 20/Box
    $61.99 $42.99
    ($2.15 / round)

  • Federal 45-70 Govt 300 gr Soft Point Fusion 20/Box

    Federal 45-70 Govt 300 gr Soft Point Fusion 20/Box
    $67.99 $51.99
    ($2.60 / round)

  • Remington 45-70 Govt 300 gr SJHP High Performance Full-Pressure 20/Box

    Remington 45-70 Govt 300 gr SJHP High Performance Full-Pressure 20/Box
    $48.99
    ($2.45 / round)

  • Grizzly Ammo 45-70 Govt 405 gr Lead Round Nose FP Cowboy 20/Box

    Grizzly Ammo 45-70 Govt 405 gr Lead Round Nose FP Cowboy 20/Box
    $44.99
    ($2.25 / round)

  • Grizzly Ammo 45-70 Govt 410 gr Kodiak FMJ Flat Point Subsonic 20/Box

    Grizzly Ammo 45-70 Govt 410 gr Kodiak FMJ Flat Point Subsonic 20/Box
    $44.99
    ($2.25 / round)

Product Description

What’s in the Box

  • Henry H010 Lever-Action Rifle
  • Owner’s Manual

A caliber that traces its origins from the battlefield to its modern-day presence in hunting camps across the country.

Introduced by the U.S. Army in 1873, this cartridge was first known as the .45 Government. As it made its way into commercially produced firearms the name .45-70 appeared, because it was loaded with a 70 grain blackpowder charge with 405 and 500 grain bullets. Virtually all rifle making companies of the late 19th century chambered their single shots and lever actions for the .45-70. As those companies and their rifles faded away, the .45-70’s popularity did not. Factory .45-70 ammunition has been cataloged continuously since 1873 but never in the variety of loadings available now, in the 21st century. They range from 405 grain lead bullet, low-velocity loads for deer hunting and target shooting to high-velocity 300 to 400 grain jacketed bullet ones meant for even the largest game in North America.

The Model H010 .45-70 can handle them all. Its receiver is blued steel fitted with an 18.43” round barrel underneath and a tubular magazine of four-round capacity. Its pistol-grip buttstock and steel-capped forend are crafted of beautiful American walnut and cut with checkering to provide a sure grip. The buttstock wears a soft rubber pad to help shooters handle .45-70 recoil from a 7.08 lb. rifle.

If you need a handy yet powerful lever gun capable of fast repeat shots in the bear country of Alaska, or just a short, light rifle for deer hunting in the mountains of Pennsylvania, the Model H010 will provide the accuracy and reliability you can count on.

Firearm Specifications

  • Manufacturer: Henry
  • Model Number: H010
  • Action Type: Lever Action
  • Caliber: .45-70
  • Capacity: 4 rounds
  • Length (inches): 39
  • Barrel Length (inches): 18.43
  • Weight: 7.08 lbs.
  • Stock: Pistol-grip American walnut with buttplate
  • Sights: Fully adjustable semi-buckhorn rear and brass beaded front sight
  • Finish: Blued steel drilled and tapped for easy scope mounting

Customer Comments & Questions

Customer Reviews

(5 out of 5) A great, easy handling gun for any thick brush hunting.
by from Roswell, NM on

First of all, I am a fan of the .45-70. I have 4. I bought this short barreled rifle since I hunt in thickened areas where the ability to move is often hampered by vegetation and shots are at close range. The 18 inch barrel is ideal for these conditions. I was fortunate enough to have drawn a cow elk tag last year.
 On the second day, the Henry was put to the test. One shot and a 700 pound cow elk was on the ground. As I was using cast bullets there was little meat damage but the hydrostatic shock of the 406 grain bullet jellied the heart and lungs, and it left a .458 diameter hole on the off side. The shot was at 50 yards. I keep it zeroed at 100 and it stays there. If you want a great hunting firearm at a reasonable price, I highly recommend the Henry .45-70.


Debugging Information
ColdFusion Server Evaluation 2021,0,13,330286
Template /products2.cfm
Time Stamp 20-May-24 02:56 PM
Locale English (US)
User Agent Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)
Remote IP 10.200.2.4
Host Name 10.200.2.4


Execution Time

Total Time Avg Time Count Template
288 ms 288 ms 1 E:/inetpub/wwwroot/products2.cfm
225 ms 225 ms 1 E:/inetpub/wwwroot/products2_similaritems.cfm
130 ms 130 ms 1 E:/inetpub/wwwroot/products2_similaritems_firearms.cfm
100 ms 5 ms 20 C:/inetpub/wwwroot/includes/qry_term_sale_price.cfm
95 ms 95 ms 1 E:/inetpub/wwwroot/products2_similaritems_qry.cfm
16 ms 16 ms 1 E:/inetpub/wwwroot/itemdetail/dsp_analyze_pricing_structures_new.cfm
16 ms 16 ms 1 E:/inetpub/wwwroot/products2_discount_offers.cfm
15 ms 15 ms 1 E:/inetpub/wwwroot/products2_mfgpromo_qry.cfm
0 ms 0 ms 21 C:/inetpub/wwwroot/includes/brands.cfm
0 ms 0 ms 1 C:/inetpub/wwwroot/includes/dropship.cfm
0 ms 0 ms 1 C:/inetpub/wwwroot/includes/newfooter.cfm
0 ms 0 ms 1 C:/inetpub/wwwroot/includes/security/block_access.cfm
0 ms 0 ms 1 C:/inetpub/wwwroot/includes/security/library.cfm
0 ms 0 ms 1 C:/inetpub/wwwroot/includes/security/sql_injection.cfm
0 ms 0 ms 1 C:/inetpub/wwwroot/includes/shipping_disclaimer.cfm
0 ms 0 ms 1 E:/inetpub/wwwroot/Application.cfm
0 ms 0 ms 1 E:/inetpub/wwwroot/includes/metatags.cfm
0 ms 0 ms 1 E:/inetpub/wwwroot/includes/newheader.cfm
0 ms 0 ms 1 E:/inetpub/wwwroot/itemdetail/qry_get_price.cfm
0 ms 0 ms 1 E:/inetpub/wwwroot/itemdetail/qry_getproducts.cfm
0 ms 0 ms 1 E:/inetpub/wwwroot/products2_breadcrumbs.cfm
0 ms 0 ms 1 E:/inetpub/wwwroot/products2_combos.cfm
0 ms 0 ms 1 E:/inetpub/wwwroot/products2_mfgpromo.cfm
0 ms 0 ms 1 E:/inetpub/wwwroot/products2_reviews.cfm
0 ms  STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
288 ms  TOTAL EXECUTION TIME
red = over 250 ms average execution time


SQL Queries

find_heirloom (Datasource=celerantsql, Time=0ms, Records=1) in E:\inetpub\wwwroot\itemdetail\qry_getproducts.cfm @ 14:56:06.006
select style from tb_styles with (nolock) where style_id=?
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 124747

GetProducts (Datasource=celerantsql, Time=0ms, Records=1) in E:\inetpub\wwwroot\itemdetail\qry_getproducts.cfm @ 14:56:06.006
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
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 124747

get_promos124747 (Datasource=celerantsql, Time=15ms, Records=0) in E:\inetpub\wwwroot\products2_mfgpromo_qry.cfm @ 14:56:06.006
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 = 124747 
and (a.start_date<= 'May 20, 2024 14:56:06' or a.active = 1)
and a.end_date >= '05/20/2024'
order by a.promo_id desc
get_promos (Datasource=, Time=0ms, Records=0) in E:\inetpub\wwwroot\products2_mfgpromo_qry.cfm @ 14:56:06.006
select * from get_promos124747
get_web_url (Datasource=celerantsql, Time=0ms, Records=1) in E:\inetpub\wwwroot\products2_breadcrumbs.cfm @ 14:56:06.006
Select web_url, dept from tb_web_taxonomy with (nolock) where dept = 'Firearms' and typ='EMPTY' and site = 'sportsman' and dept <>'California Guns'
get_web_url (Datasource=celerantsql, Time=0ms, Records=1) in E:\inetpub\wwwroot\products2_breadcrumbs.cfm @ 14:56:06.006
Select web_url from tb_web_taxonomy with (nolock) where dept = 'Firearms' and typ='Lever Action' and subtyp_1='EMPTY' and site = 'sportsman'
get_old (Datasource=celerantsql, Time=0ms, Records=0) in E:\inetpub\wwwroot\products2.cfm @ 14:56:06.006
Select * FROM tb_mfg_promo.dbo.tb_new_version where new_style_id='124747'
get_reviews (Datasource=celerantsql, Time=0ms, Records=1) in E:\inetpub\wwwroot\products2.cfm @ 14:56:06.006
select * from tb_product_reviews with (nolock)
                            where (style_id=?)
                            and status='A' and site = 'sportsman'
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 124747

get_reviews_average (Datasource=celerantsql, Time=0ms, Records=1) in E:\inetpub\wwwroot\products2.cfm @ 14:56:06.006
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'
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 124747

get_alt (Datasource=celerantsql, Time=16ms, Records=0) in E:\inetpub\wwwroot\products2.cfm @ 14:56:06.006
select * from tb_alt_pictures with (nolock) where style_id=124747
check_qoh (Datasource=celerantsql, Time=0ms, Records=1) in E:\inetpub\wwwroot\products2.cfm @ 14:56:06.006
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 = 124747
                        and e.store_id = 10
                        group by a.style_id, qc
check_ss_qoh (Datasource=celerantsql, Time=0ms, Records=0) in C:\inetpub\wwwroot\includes\dropship.cfm @ 14:56:06.006
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 = 124747 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 (?,?,?,?,?,?,?,?,?)
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = BERETTA
Parameter #2(cf_sql_varchar) = GLOCK
Parameter #3(cf_sql_varchar) = RUGER
Parameter #4(cf_sql_varchar) = SMITH AND WESSON
Parameter #5(cf_sql_varchar) = LEUPOLD
Parameter #6(cf_sql_varchar) = SPRINGFIELD
Parameter #7(cf_sql_varchar) = THOMPSON CENTER
Parameter #8(cf_sql_varchar) = TIKKA
Parameter #9(cf_sql_varchar) = WALTHER

GetPrice (Datasource=celerantsql, Time=0ms, Records=1) in E:\inetpub\wwwroot\itemdetail\qry_get_price.cfm @ 14:56:06.006
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
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 124747

get_term_sale_info (Datasource=celerantsql, Time=16ms, Records=0) in E:\inetpub\wwwroot\itemdetail\dsp_analyze_pricing_structures_new.cfm @ 14:56:06.006
select *
			from tb_term_sale_entries with (nolock)
			where start_date<= 'May 20, 2024 14:56:06' and
			end_date >= 'May 20, 2024 14:56:06'
			and store_id=10 and style_id=?
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 124747

get_group_quantity_pricing (Datasource=celerantsql, Time=0ms, Records=0) in E:\inetpub\wwwroot\itemdetail\dsp_analyze_pricing_structures_new.cfm @ 14:56:06.006
select * from tb_quantityprice with (nolock) where start_date <{ts '2024-05-20 14:56:06'} and end_date >{ts '2024-05-20 14:56:06'} and quantityprice_id in (select quantityprice_id from tb_quantityprice_items where style_id=? and store_id=10)
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 124747

bulkitems (Datasource=celerantsql, Time=0ms, Records=0) in E:\inetpub\wwwroot\products2.cfm @ 14:56:06.006
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
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 124747

n_v (Datasource=celerantsql, Time=0ms, Records=0) in E:\inetpub\wwwroot\products2.cfm @ 14:56:06.006
Select * FROM tb_mfg_promo.dbo.tb_new_version where old_style_id='124747'
get_pkg (Datasource=celerantsql, Time=0ms, Records=0) in E:\inetpub\wwwroot\products2_combos.cfm @ 14:56:06.006
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 = 124747 and a.start_date<= '05/20/2024 23:59:00' and a.end_date >= '05/20/2024' and site='sportsman'
discount_offer (Datasource=celerantsql, Time=16ms, Records=0) in E:\inetpub\wwwroot\products2_discount_offers.cfm @ 14:56:06.006
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=124747 and a.start_date<= 'May 20, 2024 14:56:06' and a.end_date >= 'May 20, 2024 14:56:06' and a.site='sportsman' and d.store_id=10 and qoh>0 
	group by b.style_id
GetAssociatedMain (Datasource=celerantsql, Time=0ms, Records=41373, Cached Query) in E:\inetpub\wwwroot\products2_similaritems_qry.cfm @ 14:56:06.006
SELECT * from GetAssociatedMain with (nolock)
associated (Datasource=, Time=49ms, Records=12) in E:\inetpub\wwwroot\products2_similaritems_qry.cfm @ 14:56:06.006
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<>124747 and (available>0 or non_invt='Y')
AND 


typ='Lever Action' and 
	
	(brand='HENRY REPEATING ARMS' or of2='H010' or of3='45-70 GOVERNMENT')
	
group by Style_id order by qc asc, sold desc
associatedammo (Datasource=, Time=31ms, Records=8) in E:\inetpub\wwwroot\products2_similaritems_qry.cfm @ 14:56:06.006
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<>124747 and available>0 
AND

of3='45-70 GOVERNMENT'

group by Style_id order by qc asc, sold desc
associatedmagazines (Datasource=, Time=15ms, Records=0) in E:\inetpub\wwwroot\products2_similaritems_qry.cfm @ 14:56:06.006
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<>124747 and available>0 and 

(of2='H010' or (of4='' and of4 <>''))
AND
of3='45-70 GOVERNMENT'

group by Style_id order by qc asc, sold desc
get_term_sale_info (Datasource=celerantsql, Time=0ms, Records=1) in C:\inetpub\wwwroot\includes\qry_term_sale_price.cfm @ 14:56:06.006
select typ,amount,end_date,term_sale_id
from tb_term_sale_entries with (nolock)
where start_date<= 'May 20, 2024 14:56:06' and
end_date >= 'May 20, 2024 14:56:06'
and store_id=10 and style_id=291989
get_term_sale_info (Datasource=celerantsql, Time=16ms, Records=1) in C:\inetpub\wwwroot\includes\qry_term_sale_price.cfm @ 14:56:06.006
select typ,amount,end_date,term_sale_id
from tb_term_sale_entries with (nolock)
where start_date<= 'May 20, 2024 14:56:06' and
end_date >= 'May 20, 2024 14:56:06'
and store_id=10 and style_id=23391
get_term_sale_info (Datasource=celerantsql, Time=0ms, Records=1) in C:\inetpub\wwwroot\includes\qry_term_sale_price.cfm @ 14:56:06.006
select typ,amount,end_date,term_sale_id
from tb_term_sale_entries with (nolock)
where start_date<= 'May 20, 2024 14:56:06' and
end_date >= 'May 20, 2024 14:56:06'
and store_id=10 and style_id=291988
get_term_sale_info (Datasource=celerantsql, Time=0ms, Records=1) in C:\inetpub\wwwroot\includes\qry_term_sale_price.cfm @ 14:56:06.006
select typ,amount,end_date,term_sale_id
from tb_term_sale_entries with (nolock)
where start_date<= 'May 20, 2024 14:56:06' and
end_date >= 'May 20, 2024 14:56:06'
and store_id=10 and style_id=302585
get_term_sale_info (Datasource=celerantsql, Time=0ms, Records=1) in C:\inetpub\wwwroot\includes\qry_term_sale_price.cfm @ 14:56:06.006
select typ,amount,end_date,term_sale_id
from tb_term_sale_entries with (nolock)
where start_date<= 'May 20, 2024 14:56:06' and
end_date >= 'May 20, 2024 14:56:06'
and store_id=10 and style_id=23389
get_term_sale_info (Datasource=celerantsql, Time=18ms, Records=1) in C:\inetpub\wwwroot\includes\qry_term_sale_price.cfm @ 14:56:06.006
select typ,amount,end_date,term_sale_id
from tb_term_sale_entries with (nolock)
where start_date<= 'May 20, 2024 14:56:06' and
end_date >= 'May 20, 2024 14:56:06'
and store_id=10 and style_id=257201
get_term_sale_info (Datasource=celerantsql, Time=0ms, Records=1) in C:\inetpub\wwwroot\includes\qry_term_sale_price.cfm @ 14:56:06.006
select typ,amount,end_date,term_sale_id
from tb_term_sale_entries with (nolock)
where start_date<= 'May 20, 2024 14:56:06' and
end_date >= 'May 20, 2024 14:56:06'
and store_id=10 and style_id=141248
get_term_sale_info (Datasource=celerantsql, Time=0ms, Records=1) in C:\inetpub\wwwroot\includes\qry_term_sale_price.cfm @ 14:56:06.006
select typ,amount,end_date,term_sale_id
from tb_term_sale_entries with (nolock)
where start_date<= 'May 20, 2024 14:56:06' and
end_date >= 'May 20, 2024 14:56:06'
and store_id=10 and style_id=257199
get_term_sale_info (Datasource=celerantsql, Time=16ms, Records=1) in C:\inetpub\wwwroot\includes\qry_term_sale_price.cfm @ 14:56:06.006
select typ,amount,end_date,term_sale_id
from tb_term_sale_entries with (nolock)
where start_date<= 'May 20, 2024 14:56:06' and
end_date >= 'May 20, 2024 14:56:06'
and store_id=10 and style_id=296108
get_term_sale_info (Datasource=celerantsql, Time=0ms, Records=1) in C:\inetpub\wwwroot\includes\qry_term_sale_price.cfm @ 14:56:06.006
select typ,amount,end_date,term_sale_id
from tb_term_sale_entries with (nolock)
where start_date<= 'May 20, 2024 14:56:06' and
end_date >= 'May 20, 2024 14:56:06'
and store_id=10 and style_id=296224
get_term_sale_info (Datasource=celerantsql, Time=0ms, Records=1) in C:\inetpub\wwwroot\includes\qry_term_sale_price.cfm @ 14:56:06.006
select typ,amount,end_date,term_sale_id
from tb_term_sale_entries with (nolock)
where start_date<= 'May 20, 2024 14:56:06' and
end_date >= 'May 20, 2024 14:56:06'
and store_id=10 and style_id=302046
get_term_sale_info (Datasource=celerantsql, Time=15ms, Records=1) in C:\inetpub\wwwroot\includes\qry_term_sale_price.cfm @ 14:56:06.006
select typ,amount,end_date,term_sale_id
from tb_term_sale_entries with (nolock)
where start_date<= 'May 20, 2024 14:56:06' and
end_date >= 'May 20, 2024 14:56:06'
and store_id=10 and style_id=23377
get_term_sale_info (Datasource=celerantsql, Time=3ms, Records=1) in C:\inetpub\wwwroot\includes\qry_term_sale_price.cfm @ 14:56:06.006
select typ,amount,end_date,term_sale_id
from tb_term_sale_entries with (nolock)
where start_date<= 'May 20, 2024 14:56:06' and
end_date >= 'May 20, 2024 14:56:06'
and store_id=10 and style_id=24654
check_qoh (Datasource=celerantsql, Time=0ms, Records=1) in E:\inetpub\wwwroot\products2_similaritems_firearms.cfm @ 14:56:06.006
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 = 124747 and e.store_id = 10 
								group by a.style_id, e.qc
bulk_price (Datasource=celerantsql, Time=0ms, Records=0) in E:\inetpub\wwwroot\products2_similaritems_firearms.cfm @ 14:56:06.006
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
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 24654

get_term_sale_info (Datasource=celerantsql, Time=0ms, Records=1) in C:\inetpub\wwwroot\includes\qry_term_sale_price.cfm @ 14:56:06.006
select typ,amount,end_date,term_sale_id
from tb_term_sale_entries with (nolock)
where start_date<= 'May 20, 2024 14:56:06' and
end_date >= 'May 20, 2024 14:56:06'
and store_id=10 and style_id=105569
check_qoh (Datasource=celerantsql, Time=0ms, Records=1) in E:\inetpub\wwwroot\products2_similaritems_firearms.cfm @ 14:56:06.006
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 = 124747 and e.store_id = 10 
								group by a.style_id, e.qc
bulk_price (Datasource=celerantsql, Time=15ms, Records=0) in E:\inetpub\wwwroot\products2_similaritems_firearms.cfm @ 14:56:06.006
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
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 105569

get_term_sale_info (Datasource=celerantsql, Time=0ms, Records=0) in C:\inetpub\wwwroot\includes\qry_term_sale_price.cfm @ 14:56:06.006
select typ,amount,end_date,term_sale_id
from tb_term_sale_entries with (nolock)
where start_date<= 'May 20, 2024 14:56:06' and
end_date >= 'May 20, 2024 14:56:06'
and store_id=10 and style_id=61472
check_qoh (Datasource=celerantsql, Time=0ms, Records=1) in E:\inetpub\wwwroot\products2_similaritems_firearms.cfm @ 14:56:06.006
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 = 124747 and e.store_id = 10 
								group by a.style_id, e.qc
bulk_price (Datasource=celerantsql, Time=0ms, Records=0) in E:\inetpub\wwwroot\products2_similaritems_firearms.cfm @ 14:56:06.006
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
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 61472

get_term_sale_info (Datasource=celerantsql, Time=16ms, Records=1) in C:\inetpub\wwwroot\includes\qry_term_sale_price.cfm @ 14:56:06.006
select typ,amount,end_date,term_sale_id
from tb_term_sale_entries with (nolock)
where start_date<= 'May 20, 2024 14:56:06' and
end_date >= 'May 20, 2024 14:56:06'
and store_id=10 and style_id=19084
check_qoh (Datasource=celerantsql, Time=0ms, Records=1) in E:\inetpub\wwwroot\products2_similaritems_firearms.cfm @ 14:56:06.006
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 = 124747 and e.store_id = 10 
								group by a.style_id, e.qc
bulk_price (Datasource=celerantsql, Time=0ms, Records=0) in E:\inetpub\wwwroot\products2_similaritems_firearms.cfm @ 14:56:06.006
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
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 19084

get_term_sale_info (Datasource=celerantsql, Time=0ms, Records=0) in C:\inetpub\wwwroot\includes\qry_term_sale_price.cfm @ 14:56:06.006
select typ,amount,end_date,term_sale_id
from tb_term_sale_entries with (nolock)
where start_date<= 'May 20, 2024 14:56:06' and
end_date >= 'May 20, 2024 14:56:06'
and store_id=10 and style_id=77464
check_qoh (Datasource=celerantsql, Time=0ms, Records=1) in E:\inetpub\wwwroot\products2_similaritems_firearms.cfm @ 14:56:06.006
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 = 124747 and e.store_id = 10 
								group by a.style_id, e.qc
bulk_price (Datasource=celerantsql, Time=0ms, Records=0) in E:\inetpub\wwwroot\products2_similaritems_firearms.cfm @ 14:56:06.006
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
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 77464

get_term_sale_info (Datasource=celerantsql, Time=16ms, Records=0) in C:\inetpub\wwwroot\includes\qry_term_sale_price.cfm @ 14:56:06.006
select typ,amount,end_date,term_sale_id
from tb_term_sale_entries with (nolock)
where start_date<= 'May 20, 2024 14:56:06' and
end_date >= 'May 20, 2024 14:56:06'
and store_id=10 and style_id=306885
check_qoh (Datasource=celerantsql, Time=0ms, Records=1) in E:\inetpub\wwwroot\products2_similaritems_firearms.cfm @ 14:56:06.006
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 = 124747 and e.store_id = 10 
								group by a.style_id, e.qc
bulk_price (Datasource=celerantsql, Time=0ms, Records=0) in E:\inetpub\wwwroot\products2_similaritems_firearms.cfm @ 14:56:06.006
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
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 306885

get_term_sale_info (Datasource=celerantsql, Time=0ms, Records=0) in C:\inetpub\wwwroot\includes\qry_term_sale_price.cfm @ 14:56:06.006
select typ,amount,end_date,term_sale_id
from tb_term_sale_entries with (nolock)
where start_date<= 'May 20, 2024 14:56:06' and
end_date >= 'May 20, 2024 14:56:06'
and store_id=10 and style_id=309554
check_qoh (Datasource=celerantsql, Time=0ms, Records=1) in E:\inetpub\wwwroot\products2_similaritems_firearms.cfm @ 14:56:06.006
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 = 124747 and e.store_id = 10 
								group by a.style_id, e.qc
bulk_price (Datasource=celerantsql, Time=0ms, Records=0) in E:\inetpub\wwwroot\products2_similaritems_firearms.cfm @ 14:56:06.006
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
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 309554

get_term_sale_info (Datasource=celerantsql, Time=0ms, Records=0) in C:\inetpub\wwwroot\includes\qry_term_sale_price.cfm @ 14:56:06.006
select typ,amount,end_date,term_sale_id
from tb_term_sale_entries with (nolock)
where start_date<= 'May 20, 2024 14:56:06' and
end_date >= 'May 20, 2024 14:56:06'
and store_id=10 and style_id=309556
check_qoh (Datasource=celerantsql, Time=15ms, Records=1) in E:\inetpub\wwwroot\products2_similaritems_firearms.cfm @ 14:56:06.006
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 = 124747 and e.store_id = 10 
								group by a.style_id, e.qc
bulk_price (Datasource=celerantsql, Time=0ms, Records=0) in E:\inetpub\wwwroot\products2_similaritems_firearms.cfm @ 14:56:06.006
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
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 309556

vid_url (Datasource=celerantsql, Time=0ms, Records=0) in E:\inetpub\wwwroot\products2.cfm @ 14:56:06.006
select * from tb_mfg_promo.dbo.tb_video_url where style_id=124747 and site <> 'outdoors'
get_reviews (Datasource=celerantsql, Time=0ms, Records=1) in E:\inetpub\wwwroot\products2_reviews.cfm @ 14:56:06.006
select * from tb_product_reviews  with (nolock)
where (style_id=?)  
and status='A' and site = 'sportsman'
order by dte desc
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 124747

get_reviews_average (Datasource=celerantsql, Time=0ms, Records=1) in E:\inetpub\wwwroot\products2_reviews.cfm @ 14:56:06.006
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'
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 124747

get_response (Datasource=celerantsql, Time=0ms, Records=0) in E:\inetpub\wwwroot\products2_reviews.cfm @ 14:56:06.006
select * from tb_mfg_promo.dbo.tb_product_review_responses where product_review_id=209263


Scope Variables

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=CFTOKEN=Z98olbwg5rxrj4kxa625akg5dpmaa354uo66g173yqvk4tox9o-ee4e16a37a9175ca-E994AB14-9E00-26DC-57DC0CDC4B6F2AFF; CFGLOBALS=urltoken%3DCFID%23%3D8512%26CFTOKEN%23%3Dee4e16a37a9175ca%2DE994AB14%2D9E00%2D26DC%2D57DC0CDC4B6F2AFF%23lastvisit%3D%7Bts%20%272024%2D05%2D20%2014%3A56%3A06%27%7D%23hitcount%3D86%23timecreated%3D%7Bts%20%272024%2D05%2D20%2014%3A55%3A18%27%7D%23cftoken%3Dee4e16a37a9175ca%2DE994AB14%2D9E00%2D26DC%2D57DC0CDC4B6F2AFF%23cfid%3D8512%23; CFID=Z98olbwg5rxrj4kxa625akg5dpmaa354uo66g173yqvk4tox9o-8512; CT_U=2359; PRD_U=131922%2C85; LAST_NAME=; USERNAME=; CUSTOMER_ID=; EMAIL=; PASSWORD=; FIRST_NAME=
HTTP_HOST=www.sportsmansoutdoorsuperstore.com
HTTP_REFERER=
HTTP_URL=/products2.cfm/ID/124747/h010/henry-repeating-arms-h010-lever-action-45-70
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/124747/h010/henry-repeating-arms-h010-lever-action-45-70
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=8512
cftoken=ee4e16a37a9175ca-E994AB14-9E00-26DC-57DC0CDC4B6F2AFF
hitcount=86
lastvisit={ts '2024-05-20 14:56:06'}
timecreated={ts '2024-05-20 14:55:18'}
urltoken=CFID=8512&CFTOKEN=ee4e16a37a9175ca-E994AB14-9E00-26DC-57DC0CDC4B6F2AFF
Cookie Variables:
CFGLOBALS=urltoken=CFID#=8512&CFTOKEN#=ee4e16a37a9175ca-E994AB14-9E00-26DC-57DC0CDC4B6F2AFF#lastvisit={ts '2024-05-20 14:56:06'}#hitcount=86#timecreated={ts '2024-05-20 14:55:18'}#cftoken=ee4e16a37a9175ca-E994AB14-9E00-26DC-57DC0CDC4B6F2AFF#cfid=8512#
CFID=8512
CFTOKEN=ee4e16a37a9175ca-E994AB14-9E00-26DC-57DC0CDC4B6F2AFF
CT_U=2359
CUSTOMER_ID=
EMAIL=
FIRST_NAME=
LAST_NAME=
PASSWORD=
PRD_U=124747,762
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=8512
cftoken=ee4e16a37a9175ca-E994AB14-9E00-26DC-57DC0CDC4B6F2AFF
cs=/category.cfm/sportsman/brand/savage/currentpage/14
displaycount=18
employeeloggedin=N
executed=YES
fflnote=
firearm_agreement=NO
imgarray=Array (0)
memberloggedin=N
pickupstore=10
prodtype=none
selected_ffl=NO
sessionid=SOS_8512_ee4e16a37a9175ca-E994AB14-9E00-26DC-57DC0CDC4B6F2AFF
strarray=Array (0)
urltoken=CFID=8512&CFTOKEN=ee4e16a37a9175ca-E994AB14-9E00-26DC-57DC0CDC4B6F2AFF
URL Parameters:
ATTR1=
ATTR2=
BRAND=
CLEARANCE=
DEPT=Firearms
ID=124747
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=Lever Action
WHATSNEW=
h010=henry-repeating-arms-h010-lever-action-45-70
Debug Rendering Time: 17 ms