80C
- Home
- Paper
- Basis Weight
- 80C
SELECT DISTINCT `e`.*, `cat_index`.`position` AS `cat_index_position`, `price_index`.`price`, `price_index`.`tax_class_id`, `price_index`.`final_price`, IF(price_index.tier_price IS NOT NULL, LEAST(price_index.min_price, price_index.tier_price), price_index.min_price) AS `minimal_price`, `price_index`.`min_price`, `price_index`.`max_price`, `price_index`.`tier_price`, IFNULL(review_summary.reviews_count, 0) AS `reviews_count`, IFNULL(review_summary.rating_summary, 0) AS `rating_summary`, `stock_status_index`.`stock_status` AS `is_salable`, IF(at_name.value_id > 0, at_name.value, at_name_default.value) AS `name` FROM `catalog_product_entity` AS `e`
INNER JOIN `catalog_category_product_index_store1` AS `cat_index` ON cat_index.product_id=e.entity_id AND cat_index.store_id=1 AND cat_index.visibility IN(2, 4) AND cat_index.category_id=886
INNER JOIN `catalog_product_index_price` AS `price_index` ON price_index.entity_id = e.entity_id AND price_index.website_id = '1' AND price_index.customer_group_id = 0
LEFT JOIN `review_entity_summary` AS `review_summary` ON e.entity_id = review_summary.entity_pk_value AND review_summary.store_id = 1 AND review_summary.entity_type = (SELECT `review_entity`.`entity_id` FROM `review_entity` WHERE (entity_code = 'product'))
LEFT JOIN `cataloginventory_stock_status` AS `stock_status_index` ON e.entity_id = stock_status_index.product_id AND stock_status_index.website_id = 0 AND stock_status_index.stock_id = 1
LEFT JOIN `catalog_product_entity_varchar` AS `at_name_default` ON (`at_name_default`.`entity_id` = `e`.`entity_id`) AND (`at_name_default`.`attribute_id` = '70') AND `at_name_default`.`store_id` = 0
LEFT JOIN `catalog_product_entity_varchar` AS `at_name` ON (`at_name`.`entity_id` = `e`.`entity_id`) AND (`at_name`.`attribute_id` = '70') AND (`at_name`.`store_id` = 1) ORDER BY `name` ASC, `e`.`entity_id` DESC
LIMIT 9
Shop By
Shopping Options
Finish
Manufacturer
Weight
Paper Color
Color
- Antique Gray 3 items
- Aqua 1 item
- Augusta Green 1 item
- Avalanche White 1 item
- Avon Brilliant White 3 items
- Azure 1 item
- Baronial Ivory 3 items
- Beet 1 item
- Birch 2 items
- Black 3 items
- Blazer Blue 2 items
- Brick Red 1 item
- Bright White 2 items
- Burgundy 2 items
- Butcher Extra Blue 1 item
- Butcher Extra White 1 item
- Butcher Off White 1 item
- Butcher Orange 1 item
- Butcher White 1 item
- Canyon Brown 1 item
- Cement Green 1 item
- Charcoal 1 item
- Charcoal Brown 1 item
- Classic Cream 1 item
- Classic Natural White 3 items
- Cream 2 items
- Cream White 3 items
- Deep Blue 1 item
- Desert Haze 1 item
- Desert Storm 1 item
- Eames Natural White 1 item
- Eames White 1 item
- Earthstone 1 item
- Ecru 1 item
- Eggplant 1 item
- Electric Red 1 item
- Emerald Green 1 item
- Epic Black 3 items
- Factory Green 1 item
- Fluorescent White 1 item
- Fog Gray 1 item
- Forest Green 1 item
- Fuse Green 1 item
- Glacier Mist 1 item
- Graphite 1 item
- Gray 1 item
- Graystone 1 item
- Grey 1 item
- Haviland Blue 1 item
- Ice Blue 1 item
- Ivory 1 item
- Kraft 2 items
- Madero Beach White 1 item
- Mahogany 1 item
- Midnight Black 2 items
- Midnight Blue 1 item
- Millstone 1 item
- Monterey Sand 1 item
- Moonrock 1 item
- Natural 3 items
- Natural White 3 items
- New Black 1 item
- Newsprint Aged 1 item
- Newsprint Extra White 1 item
- Newsprint White 1 item
- Nightshift Blue 1 item
- Oatmeal 1 item
- Old Green 1 item
- PC 100 White 1 item
- Packing Brown Wrap 1 item
- Patriot Blue 1 item
- Pewter 1 item
- Ponderosa Pine 1 item
- Potomac Blue 1 item
- Pure White 3 items
- Radiant White 1 item
- Recycled 100 Bright White 4 items
- Red 2 items
- Red Pepper 2 items
- Safety Orange 1 item
- Sand 1 item
- Sand Stone 1 item
- Sandstone 1 item
- Sea Spray 1 item
- Silver 1 item
- Silverstone 2 items
- Soft Gray 1 item
- Softwhite 2 items
- Solar White 4 items
- Starch White 1 item
- Steel Blue 1 item
- Taupe 1 item
- Timber Green 1 item
- Tortilla 1 item
- True White 1 item
- Ultimate White 3 items
- Ultrawhite 2 items
- Violet 1 item
- Warm White 1 item
- White 9 items
- Whitestone 2 items
- Yellow 1 item
Paper Size
- 11 X 17 18 items
- 11 x 8.5 3 items
- 12 X 12 10 items
- 12 X 18 13 items
- 17 X 11 8 items
- 18 X 12 6 items
- 19 X 13 3 items
- 20.75 X 29.4375 2 items
- 23 X 29 1 item
- 23 X 35 7 items
- 26 X 40 27 items
- 28 X 40 1 item
- 35 X 23 8 items
- 8.5 X 11 28 items
- A-1 CARD 3 items
- A-1 FOLDER 3 items
- A-2 CARD 5 items
- A-2 FOLDER 4 items
- A-6 CARD 3 items
- A-6 FOLDER 4 items
- A-7 CARD 4 items
- A-7 FOLDER 3 items
Brand
- Classic Columns 1 item
- Classic Crest 1 item
- Classic Laid 1 item
- Classic Linen 1 item
- Construction 1 item
- Crane's Crest 1 item
- Dur-O-Tone 1 item
- Eames Painting 1 item
- Environment 1 item
- Esse 1 item
- Everyday Digital Gloss 1 item
- Everyday Digital Silk 1 item
- Everyday Digital Uncoated 1 item
- Globe Linen 1 item
- Globe Smooth Fiber 1 item
- Mod-Tone 1 item
- Mohawk Carnival 2 items
- Mohawk Carnival Felt 1 item
- Mohawk Superfine Eggshell 1 item
- Mohawk Superfine Smooth 1 item
- Mohawk Via Felt 1 item
- Mohawk Via Linen 1 item
- Mohawk Via Smooth 1 item
- Mohawk Via Vellum 1 item
- Royal Sundance 2 items
- Royal Sundance Felt 1 item
- Speckletone 1 item
- Strathmore Premium Cambric 1 item
- Strathmore Premium Enhance 1 item
- Strathmore Premium Grandee 1 item
- Strathmore Premium Supersmooth 1 item
- Strathmore Premium Wove 1 item
- Summer Plate 1 item
Unit of Measure