ASTICUS FLIPPER KNIFE

No CIVC200

Be the first to review!

$69.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	BRASS	31507	[empty string]	[empty string]	0	5	0	0	BRASS	14	Y	[empty string]	971266	[empty string]	207410
2	ORANGE	31508	[empty string]	[empty string]	0	4	0	0	COPPER	12	Y	[empty string]	971267	[empty string]	207410

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	207410

struct
INTERNALLISTPRICE	69.95
INTERNALMARKDOWN	false
INTERNALPRICE	69.95
REG	69.95
SALE	69.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	BRASS	31507	[empty string]	[empty string]	0	5	0	0	BRASS	14	Y	[empty string]	971266	[empty string]	207410
2	ORANGE	31508	[empty string]	[empty string]	0	4	0	0	COPPER	12	Y	[empty string]	971267	[empty string]	207410

array
1	207410

struct
INTERNALLISTPRICE	69.95
INTERNALMARKDOWN	false
INTERNALPRICE	69.95
REG	69.95
SALE	69.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

Ready to flip into action

Tackle the day with confidence and the Asticus Flipper Knife from CIVIVI by your side. Featuring a sturdy stonewashed bass handle and durable D2 steel blade, this folding knife was built to handle your everyday cutting, slicing, and whittling needs.

Blade Material: D2
Blade Hardness: 59-61HRC
Blade Grind: Hollow
Blade Finish: Satin
Handle Material: Brass
Handle Color/Finish: Stonewashed
Back Spacer Material: Brass
Back Spacer Color/Finish: Stonewashed
Liner Material: Stainless Steel
Liner Color/Finish: Gray
Pocket Clip: Tip-Up,L/R
Clip Material: Stainless Steel
Screws Material: Stainless Steel
Pivot Assembly: Caged Ceramic Ball Bearing
Locking Mechanism: Liner Lock
Overall Length: 8.81" / 223.7mm
Blade Length: 3.80" / 96.4mm
Closed Length: 5.01" / 127.3mm
Blade Thickness: 0.12" / 3mm
Handle Thickness: 0.47" / 12mm
Weight: 6.59oz / 186.9g
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

Tackle the day with confidence and the Asticus Flipper Knife from CIVIVI by your side. Featuring a sturdy stonewashed bass handle and durable D2 steel blade, this folding knife was built to handle your everyday cutting, slicing, and whittling needs.
Specs
- Blade Material: D2
- Blade Hardness: 59-61HRC
- Blade Grind: Hollow
- Blade Finish: Satin
- Handle Material: Brass
- Handle Color/Finish: Stonewashed
- Back Spacer Material: Brass
- Back Spacer Color/Finish: Stonewashed
- Liner Material: Stainless Steel
- Liner Color/Finish: Gray
- Pocket Clip: Tip-Up,L/R
- Clip Material: Stainless Steel
- Screws Material: Stainless Steel
- Pivot Assembly: Caged Ceramic Ball Bearing
- Locking Mechanism: Liner Lock
- Overall Length: 8.81" / 223.7mm
- Blade Length: 3.80" / 96.4mm
- Closed Length: 5.01" / 127.3mm
- Blade Thickness: 0.12" / 3mm
- Handle Thickness: 0.47" / 12mm
- Weight: 6.59oz / 186.9g
- Imported
Reviews

No Reviews Yet!
Live Chat