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_38` 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 ('468')) 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 '%ClassroomDecorations' THEN 1 ELSE 0 END DESC, CASE WHEN MATCH(`desc_short`) AGAINST ('ClassroomDecorations' IN BOOLEAN MODE) THEN 1 ELSE 0 END DESC, CASE WHEN `pinfo`.`vendor`=2 THEN IF(MATCH(`desc_long`, `manufacturer_name`, `color`) AGAINST ('+ClassroomDecorations' IN BOOLEAN MODE),4,0) ELSE CASE WHEN MATCH (`keywords`) AGAINST ('"ClassroomDecorations"' IN BOOLEAN MODE) AND MATCH (`desc_title`) AGAINST ('"ClassroomDecorations"' IN BOOLEAN MODE) THEN 4 ELSE IF(MATCH (`desc_title`) AGAINST ('"ClassroomDecorations"' IN BOOLEAN MODE),3,IF(MATCH (`keywords`) AGAINST ('"ClassroomDecorations"' IN BOOLEAN MODE),2,IF(MATCH(`desc_title`, `manufacturer_name`, `color`) AGAINST ('+ClassroomDecorations' IN BOOLEAN MODE),1,0))) END END DESC,CASE WHEN IF(`pinfo`.`vendor`=2,`category_3` ='ClassroomDecorations',`category_4` ='ClassroomDecorations') THEN 1 ELSE 0 END DESC, CASE WHEN `desc_short` LIKE 'ClassroomDecorations,%' THEN 1 ELSE 0 END DESC, SUBSTR(`pinfo`.`desc_title`, 1, LOCATE('ClassroomDecorations', `pinfo`.`desc_title`)) DESC

Currently Filtered by

Category

Classroom Decorations

Refine Search

  GO
 
Brand

TREND(34)

Carson-Dellosa Publishing(25)

Smart-Fab(22)

Pacon(14)

Chartpak(10)

Schoolgirl Style(9)

Scholastic(9)

Identity Group(4)

COSCO(2)

Trend(2)

Teacher Created Resources(2)

Baumgartens(1)

 
Color

Assorted(1)

 
Recycled

No(2)

 
Height

40 ft.(15)

48"(14)

22"(9)

3"(8)

6"(5)

31"(5)

7.88"(4)

18"(4)

1"(4)

2"(4)

12"(3)

6 1/4"(3)

17"(2)

24"(2)

4"(2)

0.05"(2)

2 7/8"(1)

17 1/2"(1)

38"(1)

0.06"(1)

8 1/2"(1)

23"(1)

9"(1)

5 1/4"(1)

1/2"(1)

1/4"(1)

24 1/2"(1)

5"(1)

 
Color(s)

Assorted(14)

White(3)

Black(3)

Brown/White/Black(3)

Black/Purple/White(3)

Blue/Clear(2)

Black/White(2)

Blue;Green;Orange;Red;Violet;Yellow(2)

Grass Green(1)

Orange(1)

Red(1)

Apple Green(1)

Cranberry(1)

Green; Yellow; Red; Blue; Purple(1)

Yellow(1)

Dark Purple(1)

Dark Pink(1)

Cream(1)

White/Brown(1)

Brown/White(1)

White/Gray/Black(1)

White/Gray(1)

Brown(1)

Dark Blue(1)

Blue(1)

Multi(1)

Sky Blue(1)

 
Manufacturer Part Number

SC553079(1)

SC553125(1)

SC553562(1)

SC553078(1)

SC553072(1)

0439492815(1)

0545417449(1)

4114(1)

4757(1)

T10608(1)

T10662(1)

8341(1)

8305(1)

38920(1)

38961(1)

0439152917(1)

0439152852(1)

1U384804061(1)

1U384804064(1)

1U384804065(1)

1U384804060(1)

1U384804056(1)

1U384804043(1)

1U384804050(1)

1U384804070(1)

238091227099(1)

23812184520(1)

23812184599(1)

23812184510(1)

238121827099(1)

23809124510(1)

23809124520(1)

T10664(1)

T10996(1)

T8306(1)

T8350(1)

T8360(1)

T8304(1)

T8302(1)

T8219(1)

T8299(1)

T8363(1)

T8364(1)

6148(1)

6149(1)

6147(1)

6146(1)

T8393(1)

T8761(1)

T8201(1)

T8194(1)

T38960(1)

T38963(1)

T38964(1)

T38959(1)

T38934(1)

T10998(1)

T38913(1)

T69912(1)

T8077(1)

T8176(1)

T8182(1)

T8173(1)

T8160(1)

T8096(1)

T8156(1)

1U384804042(1)

1U384804041(1)

119017(1)

120542(1)

120543(1)

119005(1)

119004(1)

119001(1)

119003(1)

120544(1)

121122(1)

144154(1)

144156(1)

144131(1)

122013(1)

122006(1)

122012(1)

119000(1)

110402(1)

110119(1)

110142(1)

110143(1)

110115(1)

110114(1)

110014(1)

110079(1)

110199(1)

110202(1)

110400(1)

110401(1)

110399(1)

110398(1)

110205(1)

110232(1)

CD-5638(1)

CD-5652(1)

56465(1)

56475(1)

56525(1)

56385(1)

56225(1)

0057425(1)

0057705(1)

78840(1)

78920(1)

1U384804031(1)

1U384804040(1)

1U384804030(1)

1U384804020(1)

78930(1)

1U384804010(1)

0057405(1)

0056255(1)

01130(1)

01170(1)

01050(1)

01030(1)

01000(1)

01010(1)

01175(1)

01184(1)

0055805(1)

0055855(1)

098132(1)

098131(1)

01193(1)

01198(1)

22018(1)

 
Country of Origin

US(93)

IL(22)

CN(16)

United States(2)

TW(1)

 
Width

48"(15)

50 ft(11)

17"(9)

18 1/4"(6)

6"(5)

12"(5)

9 1/2"(4)

72"(3)

3 1/2"(3)

18"(3)

9"(3)

3"(3)

12 3/4"(1)

46"(1)

6 1/4"(1)

17 1/2"(1)

41"(1)

40"(1)

21"(1)

23"(1)

11 1/2"(1)

168"(1)

30"(1)

3 1/4"(1)

30 ft(1)

 
Material(s)

Vinyl(12)

Polypropylene(4)

 
Theme

Industrial Chic(6)

White(3)

Black(3)

Assorted Colors(3)

Sea Buddies(3)

Blue/Clear(2)

Sock Monkeys(2)

Alphabet(2)

Stars(2)

Monkey Mischief(2)

Jingle Jungle Animals(2)

BoHo Birds(2)

Monkey Mischief, Birthday(1)

Read All About Me(1)

Yellow(1)

Pencils(1)

Dark Pink(1)

Pennants(1)

Cranberry(1)

Sea Buddies, Happy Birthday(1)

Paw Prints(1)

Owl-Stars!(1)

Our Birthday Graph!(1)

My Food Plate(1)

Number Line(1)

Our Bully Free Classroom(1)

My Name(1)

Extra, Extra, Read All About Me(1)

Polka Dots(1)

Life Cycles(1)

Happy Birthday Bake Shop(1)

Monthly Calendar(1)

Owl Stars!(1)

Place Values(1)

Owl-Stars Job Chart(1)

Owl-Stars Calendar(1)

Celebration Gift Boxes(1)

Celebration Signs(1)

Owl Stars Alphabet Line(1)

Giraffe Growth.(1)

USDA's MyPyramid(1)

Weather Extremes(1)

Sock Monkeys Classroom Basics(1)

Owl-Star Classroom Basics(1)

Orange(1)

Furry Friends Classroom Basics(1)

Busy Bees(1)

United States Map(1)

Fractions(1)

"Year Around" Calendar(1)

The Human Body(1)

Sky Blue(1)

Numbers 0-30(1)

Grade 3(1)

Grade 1(1)

Kindergarten(1)

Colors and Shapes(1)

Mason Jars(1)

Math(1)

Language Arts(1)

Early Learning(1)

Monkeys(1)

Mini Job Assignments(1)

Calendar(1)

Morning Meetings -Kindergarten(1)

Morning Meeting Solution for Grades 1-2(1)

Weather Frog(1)

The Writing Process(1)

Photographic Welcome(1)

Rocket Ship(1)

FUNky Frog Calendar(1)

Measure Man(1)

Shooting Stars & Rainbow Bursts(1)

Chic Chevron Yellow(1)

Classic Moroccan Black(1)

Blue(1)

Cream(1)

Brown(1)

African Safari(1)

Dark Blue(1)

Black & White Stripes(1)

Apple Green(1)

Grass Green(1)

Dark Purple(1)

Insects(1)

Rain Forest(1)

Chic Chevron Pink(1)

Classic Dots Aqua(1)

Classic Dots Red(1)

Tropical Foliage(1)

Night Sky(1)

Winter Time(1)

Under the Sea(1)

Brick(1)

Clouds(1)

Red(1)

 
Skill Learning

Opposite(1)

Alphabet(1)

Color(1)

Number(1)

Shape(1)

 
Number of Pieces

5(1)

 
Recommended Age

3-6 Year(1)

 
Theme/Subject

Learning(2)

 
Choking Hazard

Warning 1(8)

No(6)

 
Character Color

Black(14)

White(2)

 
Mounting Type

Self Adhesive(14)

Adhesive(2)

 
Product Type

Educational Chart(1)

Chart(1)

 
Packaged Quantity

5 / Pack(1)

5 / Set(1)

 
Assembly Required

No(1)

 
Product Model

38920(1)

 
Character Types

Letters;Numbers(5)

Numbers(4)

Letters;Numbers;Symbols(3)

Uppercase Letters(2)

Numbers; Uppercase Letters; Symbols(2)

 
Character Style

Helvetica(10)

Hobo(4)

 
 
 

© 2019-2020 NBJ Form & Function Inc. , All Rights Reserved