DURUS FLIPPER KNIFE

No CIVC906

Be the first to review!

$74.95

Choose Color

query
	ATTR1	ATTR1_ENTRY_ID	FAM	HEX	MAXQC	MAXQOH	MINQC	MINQOH	ORIGATTR1	QOH	SELL_WEB	SKUOF16	SKU_ID	SORT_ORDER	STYLE_ID
1	ORANGE_G10	119909	[empty string]	[empty string]	0	5	0	0	ORANGE_G10	10	Y	[empty string]	971271	[empty string]	207412
2	GRAY_G10	119910	[empty string]	[empty string]	0	3	0	0	GRAY_G10	11	Y	[empty string]	971272	[empty string]	207412
3	BROWN_G10	119911	[empty string]	[empty string]	0	3	0	0	BROWN_G10	12	Y	[empty string]	971273	[empty string]	207412

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,8,6,5,9,14,15,7,2,1,3,97) group by sku_id having sum(qoh+qc) >= 1 ) 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,8,6,5,9,14,15,7,2,1,3,97) GROUP BY b.attr1 HAVING sum(e.qoh+e.qc) >= 1 ORDER BY max(b.attr1_order), max(b.attr1_entry_id)

SQLPARAMETERS

array
1	207412

struct
INTERNALLISTPRICE	74.95
INTERNALMARKDOWN	false
INTERNALPRICE	74.95
REG	74.95
SALE	74.95
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	ORANGE_G10	119909	[empty string]	[empty string]	0	5	0	0	ORANGE_G10	10	Y	[empty string]	971271	[empty string]	207412
2	GRAY_G10	119910	[empty string]	[empty string]	0	3	0	0	GRAY_G10	11	Y	[empty string]	971272	[empty string]	207412
3	BROWN_G10	119911	[empty string]	[empty string]	0	3	0	0	BROWN_G10	12	Y	[empty string]	971273	[empty string]	207412

array
1	207412

struct
INTERNALLISTPRICE	74.95
INTERNALMARKDOWN	false
INTERNALPRICE	74.95
REG	74.95
SALE	74.95
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	ORANGE_G10	119909	[empty string]	[empty string]	0	5	0	0	ORANGE_G10	10	Y	[empty string]	971271	[empty string]	207412
2	GRAY_G10	119910	[empty string]	[empty string]	0	3	0	0	GRAY_G10	11	Y	[empty string]	971272	[empty string]	207412
3	BROWN_G10	119911	[empty string]	[empty string]	0	3	0	0	BROWN_G10	12	Y	[empty string]	971273	[empty string]	207412

array
1	207412

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

Qty

Check Store Availability

Add to Basket

Please login or create an account to save this product to your wish list.

Description
Specs
Reviews
Live Chat

Sharp & ready to flip into action

The Durus Flipper Knife from CIVIVI is ready to handle your everyday cutting needs with a sharp edge. Featuring a sturdy G10 handle paired with a durable D2 steel blade, this pocket knife was built to last and put in the work along the way.

Blade Material: D2
Blade Hardness: HRC59-61
Blade Grind: Hollow
Handle Length: 3.88”(98.6mm)
Handle Overall Thickness: 0.55”(14mm)
Handle Material: G10
Liner Material: Stainless Steel
Clip Material: Stainless Steel
Screws Material: Stainless Steel
Pivot Cap: Stainless Steel
Back Spacer Material: G10
Washers Material: Caged Steel Ball Bearing
Weight: 104 g / 3.67oz
Lock Type: Liner Lock
Reversible Clip
Overall Length: 6.88”(174.8mm)
Blade Length: 3”(76.2mm)
Blade Thickness: 0.12”(3mm)
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

The Durus Flipper Knife from CIVIVI is ready to handle your everyday cutting needs with a sharp edge. Featuring a sturdy G10 handle paired with a durable D2 steel blade, this pocket knife was built to last and put in the work along the way.
Specs
- Blade Material: D2
- Blade Hardness: HRC59-61
- Blade Grind: Hollow
- Handle Length: 3.88”(98.6mm)
- Handle Overall Thickness: 0.55”(14mm)
- Handle Material: G10
- Liner Material: Stainless Steel
- Clip Material: Stainless Steel
- Screws Material: Stainless Steel
- Pivot Cap: Stainless Steel
- Back Spacer Material: G10
- Washers Material: Caged Steel Ball Bearing
- Weight: 104 g / 3.67oz
- Lock Type: Liner Lock
- Reversible Clip
- Overall Length: 6.88”(174.8mm)
- Blade Length: 3”(76.2mm)
- Blade Thickness: 0.12”(3mm)
- Imported
Reviews

No Reviews Yet!
Live Chat