facebook
 
 
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','out_of_stock') 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(20)

Trend(15)

DAX(2)

Flipside(2)

Avery®(1)

Astrobrights(1)

 
Color

Multicolor(8)

Gold(6)

Assorted(4)

Blue(3)

White(2)

Black(1)

Walnut(1)

Golden(1)

Red(1)

Green(1)

Silver(1)

Metallic Gray(1)

Metallic Blue(1)

Bright Gold(1)

Fireball Fuchsia(1)

 
Media Weight

24 lb(10)

28 lb(2)

60 lb(1)

176 g/m²(1)

 
Recycled

No(22)

Yes(19)

 
Height

9 1/4"(2)

8.5"(1)

 
Size

8.50" Width x 11" Length(21)

8.50" Width x 5.50" Length(5)

11" Width x 8.50" Length(4)

5.50" Width x 8.50" Length(1)

 
Manufacturer Part Number

05868(1)

81090(1)

48669(1)

48673(1)

91103(1)

17008(1)

81017(1)

81018(1)

81044(1)

81091(1)

47839(1)

T-17006(1)

T2951(1)

T2954(1)

T2959(1)

T2960(1)

T2965(1)

T-81019(1)

T8107(1)

47849(1)

47833(1)

N15819BT(1)

39087(1)

N15819WT(1)

VA525(1)

VA612(1)

20008(1)

20014(1)

21015(1)

39086(1)

39451(1)

47832(1)

39452(1)

40725OD(1)

44407(1)

45492(1)

45639(1)

47400(1)

47401(1)

47829(1)

T-81401(1)

 
Country of Origin

China(25)

United States(15)

Mexico(1)

 
Width

12 1/2"(2)

5.5"(1)

 
Material

Parchment Paper(9)

Foil(4)

Card Stock(2)

 
Weight (Approximate)

0.16 oz(1)

 
Shape

Round(1)

 
Sheet Size

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

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

8" Width x 10" Length(2)

 
Print Technology

Laser(16)

Inkjet(16)

 
Orientation

Horizontal(9)

Vertical(2)

 
Certifications & Standards

ANSI/BIFMA

(2)

 
Print/Message

Happy Birthday(4)

Citizenship Certificate(1)

Kindergarten Certificate(1)

Preschool Certificate(1)

Certificate of Award(1)

Congratulations(1)

Honor Roll Award(1)

Student of the Week(1)

Certificate of Recognition(1)

Star of the Week(1)

 
Printed Design/Pattern/Texture

Texture(1)

Dots Border(1)

Smile(1)

Owl-Stars(1)

Frogs(1)

 
Product Type

Certificate(32)

Certificate Seal(3)

Certificate Paper(3)

Certificate Holder(2)

Award(1)

 
Packaged Quantity

30 / Pack(14)

25 / Pack(6)

100 / Pack(3)

12 / Pack(3)

15 / Pack(3)

1 Each(2)

50 / Pack(2)

6 / Pack(2)

1 Pack(2)

42 / Pack(1)

200 / Pack(1)

40 / Pack(1)

1 / Pack(1)

 
Assembly Required

No(39)