NO. 9 JOURNAL

colonel littleton

No LJ

Be the first to review!

$150.00

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	BROWN	45534	[empty string]	[empty string]	0	2	0	0	BROWN	11	Y	[empty string]	637098	[empty string]	130428
2	BLACK_WITH_BROWN	45535	[empty string]	[empty string]	0	0	0	0	BLACK_WITH_BROWN	0	Y	[empty string]	637099	[empty string]	130428

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

SQLPARAMETERS

array
1	130428

struct
INTERNALLISTPRICE	150
INTERNALMARKDOWN	false
INTERNALPRICE	150
REG	150
SALE	150
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	BROWN	45534	[empty string]	[empty string]	0	2	0	0	BROWN	11	Y	[empty string]	637098	[empty string]	130428
2	BLACK_WITH_BROWN	45535	[empty string]	[empty string]	0	0	0	0	BLACK_WITH_BROWN	0	Y	[empty string]	637099	[empty string]	130428

array
1	130428

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

Choose One

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
Video

Document your dreams

It always does one good to just slow down, put pen to paper, and hand write observations, ideas and experiences, especially in this modern world of high-tech computers, gadgets and other devices that will be out of date next month. The handsome No. 9 Journal from Colonel Littleton offers the perfect tangible archive for that very purpose and will stand the test of time. Made of vintage brown leather, it has a stylish two position closure and edge stitching. The filler contains 130 sheets of ruled, recycled "desert Haze" paper that is laced into the journal with 1/8-inch leather lacing. The insert may be removed and filed away when it is full. The journal may be personalized with three initials on the front strap making it even more special.

Made of dry-milled, vintage brown leather
Includes 130 sheets of recycled "desert haze" paper, laced into the journal with 1/8-inch leather lacing
When full, insert may be removed and filed away
Replacement fillers available
Two position closure.
Col. Littleton's No. 2 Lead Expedition Pencil included
Dimensions: 9 x 7 inches (height x width)
Weight: 1.4 pounds
Made in the Col. Littleton's Workshop in Lynnville, TN, USA
Front strap may be personalized at an additional cost with three initials
Please call Mast Store's Customer Service line toll-free for engraving or embossing options at 1.866.367.6278

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

It always does one good to just slow down, put pen to paper, and hand write observations, ideas and experiences, especially in this modern world of high-tech computers, gadgets and other devices that will be out of date next month. The handsome No. 9 Journal from Colonel Littleton offers the perfect tangible archive for that very purpose and will stand the test of time. Made of vintage brown leather, it has a stylish two position closure and edge stitching. The filler contains 130 sheets of ruled, recycled "desert Haze" paper that is laced into the journal with 1/8-inch leather lacing. The insert may be removed and filed away when it is full. The journal may be personalized with three initials on the front strap making it even more special.
Specs
- Made of dry-milled, vintage brown leather
- Includes 130 sheets of recycled "desert haze" paper, laced into the journal with 1/8-inch leather lacing
- When full, insert may be removed and filed away
- Replacement fillers available
- Two position closure.
- Col. Littleton's No. 2 Lead Expedition Pencil included
- Dimensions: 9 x 7 inches (height x width)
- Weight: 1.4 pounds
- Made in the Col. Littleton's Workshop in Lynnville, TN, USA
- Front strap may be personalized at an additional cost with three initials
- Please call Mast Store's Customer Service line toll-free for engraving or embossing options at 1.866.367.6278
Reviews

No Reviews Yet!
Live Chat

NO. 9 JOURNAL

$150.00

Choose Color

Choose One

Qty

Spill the Beans

You may also like