Banner1 Banner1
 
SELECT `pinfo`.`sku`,`pinfo`.`vendor`, IF(`pinfo`.`multi_level_pricing_check`=1,(`mlrp`.`cost`/`mlrp`.`min_qty`),IF(CURDATE() >= `ds`.`expiration_date`, `ds`.`price`, `crp`.`contract_price`)) AS `price`, 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_1` 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_name` IN ('Certificates','Seals')) AND `pinfo`.`status` IN ('active','discontinued') AND `pinfo`.`desc_title` != '' AND `online_status`=1 AND `custom_sku_enable`=1 AND CASE WHEN `pinfo`.`multi_level_pricing_check`=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 `pinfo`.`sku` LIKE '%AwardandFrames' THEN 1 ELSE 0 END DESC, CASE WHEN MATCH(`desc_short`) AGAINST ('AwardandFrames' IN BOOLEAN MODE) THEN 1 ELSE 0 END DESC, CASE WHEN `pinfo`.`vendor`=2 THEN IF(MATCH(`desc_long`, `manufacturer_name`, `color`) AGAINST ('+AwardandFrames' IN BOOLEAN MODE),4,0) ELSE CASE WHEN MATCH (`keywords`) AGAINST ('"AwardandFrames"' IN BOOLEAN MODE) AND MATCH (`desc_title`) AGAINST ('"AwardandFrames"' IN BOOLEAN MODE) THEN 4 ELSE IF(MATCH (`desc_title`) AGAINST ('"AwardandFrames"' IN BOOLEAN MODE),3,IF(MATCH (`keywords`) AGAINST ('"AwardandFrames"' IN BOOLEAN MODE),2,IF(MATCH(`desc_title`, `manufacturer_name`, `color`) AGAINST ('+AwardandFrames' IN BOOLEAN MODE),1,0))) END END DESC,CASE WHEN IF(`pinfo`.`vendor`=2,`category_3` ='AwardandFrames',`category_4` ='AwardandFrames') THEN 1 ELSE 0 END DESC, CASE WHEN `desc_short` LIKE 'AwardandFrames,%' THEN 1 ELSE 0 END DESC, SUBSTR(`pinfo`.`desc_title`, 1, LOCATE('AwardandFrames', `pinfo`.`desc_title`)) DESC

Currently Filtered by

Category

Award And Frames

Refine Search

  GO
 
Brand

Geographics(22)

Trend(17)

Southworth(2)

Flipside(2)

DAX(2)

Dax(1)

Astrobrights(1)

Avery®(1)

 
Color

Multicolor(9)

White(5)

Gold(5)

Assorted(4)

Blue(3)

Silver(3)

Bright Gold(1)

Fireball Fuchsia(1)

Metallic Blue(1)

Green(1)

Mahogany(1)

Golden(1)

Red(1)

Metallic Gray(1)

 
Paper Weight

24 lb(12)

28 lb(2)

66 lb(2)

60 lb(1)

176 g/m²(1)

 
Size

8.50" Width x 11" Length(25)

8.50" Width x 5.50" Length(9)

11" Width x 8.50" Length(4)

5.50" Width x 8.50" Length(1)

 
Size

Letter(2)

A4(2)

 
Recycled

No(26)

Yes(22)

 
Packaged Quantity

30 / Pack(14)

25 / Pack(7)

15 / Pack(6)

1 Pack(4)

12 / Pack(3)

1 Each(3)

100 / Pack(3)

50 / Pack(2)

6 / Pack(2)

1 / Pack(1)

42 / Pack(1)

40 / Pack(1)

200 / Pack(1)

 
Assembly Required

No(46)

 
Weight (Approximate)

0.16 oz(1)

 
Print Technology

Inkjet(20)

Laser(19)

 
Recycled Content

50%(18)

30%(3)

100%(1)

 
Print/Message

Happy Birthday(4)

Congratulations(2)

Honor Roll Award(1)

Student of the Week(1)

Certificate of Recognition(1)

You did it!(1)

Certificate of Award(1)

Preschool Certificate(1)

All-Star(1)

Citizenship Certificate(1)

Kindergarten Certificate(1)

Certificate of Excellence(1)

 
Printed Design/Pattern/Texture

Frogs(2)

Owl-Stars(1)

Sea Buddies(1)

Smile(1)

Spiro Design(1)

Swirl(1)

Dots Border(1)

Fleur Design(1)

Texture(1)

 
Manufacturer Part Number

81017(1)

17008(1)

81018(1)

81044(1)

81055(1)

CTP2W(1)

CTP1W(1)

48671(1)

48673(1)

49990(1)

91103(1)

T-17006(1)

T2951(1)

T-81034(1)

T-8104(1)

T8107(1)

T-81401(1)

T-81019(1)

T8100(1)

T2954(1)

T2959(1)

T2960(1)

T2965(1)

48669(1)

47849(1)

20014(1)

39086(1)

39087(1)

39451(1)

20008(1)

VA612(1)

N100MT(1)

N15819BT(1)

N15819WT(1)

VA525(1)

39452(1)

40725OD(1)

47829(1)

47832(1)

47833(1)

47839(1)

47401(1)

47400(1)

44407(1)

45327(1)

45492(1)

45639(1)

05868(1)

 
Country of Origin

China(28)

United States(19)

Mexico(1)

 
Material

Parchment Paper(9)

Foil(4)

Card Stock(2)

Paper(1)

 
Height

9 1/4"(2)

 
Width

12 1/2"(2)

 
Sheet Size

8" Width x 10" Length(2)

8 1/2" Width x 11" Length(2)

8 19/64" Width x 11 45/64" Length(2)

 
Shape

Round(1)

 
Orientation

Horizontal(11)

Vertical(2)

 
 
 

© 2019-2020 Penn Office Products, Inc., All Rights Reserved