IRIDA LINERLOCK FOLDING KNIFE

No BTKG25

Description
Specs
Reviews
Live Chat

Quality Performance

Unfold quality with this excellent pocket knife! Made of beautifully stonewashed 154CM steel, the blade has an extended tang for perfect balance. The handle is made with sturdy G10 that has plenty of grip, plus a pocket clip for easy carrying. Enjoy streamlined design and performance with this classic folding knife!

Blade Material: 154CM Stainless Steel
Blade Length: 3.88 inches
Blade Finish: Black stonewash
Extended tang
Handle Material: G10
Overall Length: 4.88 inches
Pocket clip
Includes nylon, zippered storage case
Imported

No Reviews Yet!

Spill the Beans

Headline Name Email Overall Rating

Review

We want to make sure you know: All reviews become the property of Mast General Store. Your review requires staff approval before posting. See our Terms of Use for details.

Description

Unfold quality with this excellent pocket knife! Made of beautifully stonewashed 154CM steel, the blade has an extended tang for perfect balance. The handle is made with sturdy G10 that has plenty of grip, plus a pocket clip for easy carrying. Enjoy streamlined design and performance with this classic folding knife!
Specs
- Blade Material: 154CM Stainless Steel
- Blade Length: 3.88 inches
- Blade Finish: Black stonewash
- Extended tang
- Handle Material: G10
- Overall Length: 4.88 inches
- Pocket clip
- Includes nylon, zippered storage case
- Imported
Reviews

No Reviews Yet!
Live Chat

$104.99

Choose Color

query

RESULTSET

query
	ATTR1	ATTR1_ENTRY_ID	FAM	HEX	MAXQC	MAXQOH	MINQC	MINQOH	ORIGATTR1	QOH	SELL_WEB	SKUOF16	SKU_ID	SORT_ORDER	STYLE_ID
1	BEIGE	121238	[empty string]	[empty string]	0	2	0	0	BEIGE	5	Y	[empty string]	977562	[empty string]	208961
2	BLACK	121239	[empty string]	[empty string]	0	3	0	0	BLACK	6	Y	[empty string]	977563	[empty string]	208961
3	BLUE	121240	[empty string]	[empty string]	0	1	0	0	BLUE	3	Y	[empty string]	977564	[empty string]	208961

SELECT distinct (b.attr1) as origAttr1, max(CASE WHEN b.attr1_alias IS NULL OR RTRIM(LTRIM(b.attr1_alias)) = '' THEN b.attr1 ELSE b.attr1_alias END) as attr1, max(a.sku_id) as sku_id, max(b.attr1_entry_id) as attr1_entry_id, sum(e.qoh+e.qc) as qoh , max(b.attr1_order) as sort_order, max(c.attr1_hex) as hex,max(d.attr1_fam) as fam,max(a.SKU_OF16) as skuOF16,max(e.qoh) as maxqoh,max(e.qc) as maxqc,min(e.qoh) as minqoh,min(e.qc) as minqc,max(a.style_id) as style_id,max(a.sell_web) as sell_web FROM tb_skus a with (nolock) inner join (select distinct sku_id as sku_id from TB_SKU_BUCKETS with (nolock) where 1=1 and store_id in (11,14,6,5,9,8,15,7,2,1,3,97) group by sku_id having sum(qoh+qc) > 0 ) skuqoh on (skuqoh.sku_id=a.sku_id) LEFT JOIN tb_attr1_entries b WITH (NOLOCK) ON (b.attr1_entry_id = a.attr1_entry_id) LEFT JOIN tb_sku_buckets e WITH (NOLOCK) ON (e.sku_id = a.sku_id) LEFT JOIN tb_attr1_hexes c WITH (NOLOCK) ON (b.attr1=c.attr1) LEFT JOIN tb_attr1_families d WITH (NOLOCK) ON (c.attr1_fam_id = d.attr1_fam_id) WHERE (a.sell_web in ('Y','YES') ) and a.style_id=? AND e.store_id in(11,14,6,5,9,8,15,7,2,1,3,97) GROUP BY b.attr1 HAVING sum(e.qoh+e.qc) >= 0 ORDER BY max(b.attr1_order), max(b.attr1_entry_id)

SQLPARAMETERS

array
1	208961

struct
INTERNALLISTPRICE	104.99
INTERNALMARKDOWN	false
INTERNALPRICE	104.99
REG	104.99
SALE	104.99
TERMSALE	false
TERMSALELISTPRICE	0
TERMSALEPRICE	0

query

RESULTSET

query
	ATTR1	ATTR1_ENTRY_ID	FAM	HEX	MAXQC	MAXQOH	MINQC	MINQOH	ORIGATTR1	QOH	SELL_WEB	SKUOF16	SKU_ID	SORT_ORDER	STYLE_ID
1	BEIGE	121238	[empty string]	[empty string]	0	2	0	0	BEIGE	5	Y	[empty string]	977562	[empty string]	208961
2	BLACK	121239	[empty string]	[empty string]	0	3	0	0	BLACK	6	Y	[empty string]	977563	[empty string]	208961
3	BLUE	121240	[empty string]	[empty string]	0	1	0	0	BLUE	3	Y	[empty string]	977564	[empty string]	208961

array
1	208961

struct
INTERNALLISTPRICE	104.99
INTERNALMARKDOWN	false
INTERNALPRICE	104.99
REG	104.99
SALE	104.99
TERMSALE	false
TERMSALELISTPRICE	0
TERMSALEPRICE	0

query

RESULTSET

query
	ATTR1	ATTR1_ENTRY_ID	FAM	HEX	MAXQC	MAXQOH	MINQC	MINQOH	ORIGATTR1	QOH	SELL_WEB	SKUOF16	SKU_ID	SORT_ORDER	STYLE_ID
1	BEIGE	121238	[empty string]	[empty string]	0	2	0	0	BEIGE	5	Y	[empty string]	977562	[empty string]	208961
2	BLACK	121239	[empty string]	[empty string]	0	3	0	0	BLACK	6	Y	[empty string]	977563	[empty string]	208961
3	BLUE	121240	[empty string]	[empty string]	0	1	0	0	BLUE	3	Y	[empty string]	977564	[empty string]	208961