SELECT `pinfo`.`sku`,`pinfo`.`vendor`, CONCAT(IF(`pinfo`.`vendor`=2,`desc_long`,`desc_short`),' ',`pinfo`.`sku`,' ',`category_1`,' ',`category_2`,' ',`category_3`,' ',`category_4`,' ',IF(`pinfo`.`vendor`=2,`sales_copy`,`desc_long`),' ',IF(`dealer_sku`!='',`dealer_sku`,''),' ',`manufacturer_name`,' ',`color`) AS `search_string` FROM `product_info` `pinfo` INNER JOIN `vendor_base_costs` `vbcc` ON `pinfo`.`sku`=`vbcc`.`sku` LEFT JOIN `contract_price_12` AS `crp` ON `crp`.`sku`=`pinfo`.`sku` LEFT JOIN `bestseller_priority_detail` AS `bpd` ON `pinfo`.`sku`=`bpd`.`sku` LEFT JOIN `bestseller_priority_master` AS `bpm` ON `bpm`.`list_id`=`bpd`.`list_id` LEFT JOIN `dealer_special` AS `ds` ON `ds`.`sku`=`pinfo`.`sku` AND CURDATE() BETWEEN `ds`.`start_date` AND `ds`.`expiration_date` LEFT JOIN `multi_level_retail_price` AS `mlrp` ON `mlrp`.`sku`=`pinfo`.`sku` AND `mlrp`.`preferred_vendor`=`pinfo`.`preferred_vendor` AND (`mlrp`.`cost`/`mlrp`.`min_qty`)>0 WHERE (`category_id` IN ('2586')) AND `pinfo`.`status` IN ('active','discontinued','out_of_stock') AND `pinfo`.`desc_title` != '' AND `online_status`=1 AND `custom_sku_enable`=1 AND CASE WHEN `pinfo`.`multi_level_cost`=1 THEN TRUE ELSE `crp`.`contract_price`>0 END AND `pinfo`.`sku` NOT IN (SELECT `alias_sku` FROM `internal_alias_detail`) GROUP BY `pinfo`.`sku` ORDER BY ISNULL(`bpm`.`list_priority`) ASC, `bpm`.`list_priority` ASC, ISNULL(`bpd`.`priority`) ASC, `bpd`.`priority` ASC, CASE WHEN MATCH(`desc_short`) AGAINST ('NewsPrint' IN BOOLEAN MODE) THEN 1 ELSE 0 END DESC, CASE WHEN `pinfo`.`vendor`=2 THEN IF(MATCH(`desc_long`, `manufacturer_name`, `color`) AGAINST ('+NewsPrint' IN BOOLEAN MODE),4,0) ELSE CASE WHEN MATCH (`keywords`) AGAINST ('"NewsPrint"' IN BOOLEAN MODE) AND MATCH (`desc_title`) AGAINST ('"NewsPrint"' IN BOOLEAN MODE) THEN 4 ELSE IF(MATCH (`desc_title`) AGAINST ('"NewsPrint"' IN BOOLEAN MODE),3,IF(MATCH (`keywords`) AGAINST ('"NewsPrint"' IN BOOLEAN MODE),2,IF(MATCH(`desc_title`, `manufacturer_name`, `color`) AGAINST ('+NewsPrint' IN BOOLEAN MODE),1,0))) END END DESC,CASE WHEN IF(`pinfo`.`vendor`=2,`category_3` ='NewsPrint',`category_4` ='NewsPrint') THEN 1 ELSE 0 END DESC, CASE WHEN `desc_short` LIKE 'NewsPrint,%' THEN 1 ELSE 0 END DESC, SUBSTR(`pinfo`.`desc_title`, 1, LOCATE('NewsPrint', `pinfo`.`desc_title`)) DESC

Currently Filtered by

Category

News Print

Refine Search

  GO
Brand

RITECO INC.(21)

Recycled

No(6)

Size

8 1/2 x 11(2)

18 x 24(1)

9 x 12(1)

8 1/2" x 11"(1)

Country of Origin

United States(6)

US(4)

Sheet Size

10 1/2" x 8"(2)

8" x 10 1/2"(2)

8 1/2" x 11"(2)

Sheets Per Unit

500(4)

Number of Sheets

500(3)

Grade

2(3)

1(1)

Ruling

1/2" Light Blue Horizontal, Long Way, Both Sides(1)

1" Light Blue Horizontal, Long Way, Both Sides(1)

Sheet Type

Printed(1)

Plain(1)

Basis Weight

30 lb(1)

Front Lines Space

0.50" Ruled(2)

0.63" Ruled(1)

0.75" Ruled(1)

Front Ruling Type

Unruled(1)

Binder Color

White|FFFFFF(1)

Back Ruling Type

Ruled(1)

Product Type

Handwriting Sheet(4)

Handwriting Pad(1)

Drawing Sheet(1)

Packaged Quantity

500 / Pack(3)

500 / Ream(3)

Assembly Required

No(5)

Paper Color(s)

White|FFFFFF(4)

Paper Weight

30 lb(4)

Paper Finish

Smooth(2)

Sheet Color

White|FFFFFF(5)

Environmental Certification

SFI(3)

Environmentally Friendly

Yes(3)

Features

Grade(2)

Recyclable(1)

Margin Rule Type

Unruled(2)

Post-consumer-waste%

0%(4)

Product Name

Dotted Midline Newsprint Paper(2)

D'Nealian Ruled News Storybook Writing Pads - Letter(1)

Dotted Midline Newsprint Paper - Letter(1)

Newsprint Paper - Letter(1)

Broken Midline Ruled Paper(1)

Ruling Line Color

Blue/Red|0000FF(1)

Sheet Standard

Letter(3)

Special Features

1/2" (Long) Ruling(1)

1" (Long) Ruling(1)

 
 
Searching for your Best Results.....
Loading...
 
AbilityOne Distributor HP Qualified Supplies Partner

© 2020-2021 United Supply Corp, All Rights Reserved