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_id` IN ('468')) 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 '%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

Carson-Dellosa Publishing(32)

TREND(31)

Smart-Fab(23)

Pacon(9)

Scholastic(9)

Teacher Created Resources(4)

Baumgartens(1)

 
Recycled

No(1)

 
Height

40 ft.(15)

48"(9)

22"(7)

3"(5)

6 1/4"(4)

12"(4)

18"(4)

12 2/5"(3)

7.88"(2)

8 1/2"(2)

31"(2)

0.05"(2)

5"(1)

3 1/2"(1)

3.50"(1)

0.06"(1)

17 1/2"(1)

24 1/2"(1)

23"(1)

24"(1)

11"(1)

 
Color(s)

Assorted(9)

Black/Purple/White(4)

White(3)

Black(3)

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

Blue/Clear(2)

Black/White(1)

Red(1)

Yellow(1)

Cranberry(1)

Dark Pink(1)

Orange(1)

Sky Blue(1)

Apple Green(1)

Grass Green(1)

Dark Purple(1)

Dark Blue(1)

Blue(1)

Cream(1)

Brown(1)

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

 
Manufacturer Part Number

22018(1)

0439509963(1)

T10998(1)

T10996(1)

9027(1)

4757(1)

4114(1)

4040(1)

SC553079(1)

054541752X(1)

0545417449(1)

0545039924(1)

0439492815(1)

T25046(1)

0439492262(1)

0439152917(1)

0439152852(1)

23812184599(1)

23812184520(1)

23812184510(1)

238121827099(1)

23809124599(1)

23809124520(1)

23809124510(1)

238091227099(1)

T25044(1)

T25047(1)

1U384804065(1)

T8299(1)

T8709(1)

T8416(1)

T8415(1)

T8364(1)

T8363(1)

T8360(1)

T8350(1)

T8330(1)

T8306(1)

T8304(1)

T8302(1)

T8298(1)

T38913(1)

T8280(1)

T8201(1)

T8194(1)

T8182(1)

T8176(1)

T8096(1)

T8077(1)

T38970(1)

T38964(1)

T38963(1)

T38934(1)

1U384804070(1)

1U384804064(1)

110014(1)

110208(1)

119017(1)

119013(1)

119010(1)

119005(1)

119004(1)

119003(1)

119002(1)

119001(1)

119000(1)

110232(1)

110205(1)

122012(1)

110202(1)

110199(1)

110143(1)

110142(1)

110134(1)

110132(1)

110119(1)

110115(1)

110114(1)

110079(1)

110076(1)

122006(1)

122013(1)

1U384804061(1)

78930(1)

1U384804060(1)

1U384804056(1)

1U384804050(1)

1U384804043(1)

1U384804042(1)

1U384804041(1)

1U384804040(1)

1U384804031(1)

1U384804030(1)

1U384804020(1)

1U384804010(1)

78920(1)

144131(1)

78840(1)

56525(1)

56475(1)

56465(1)

56385(1)

56225(1)

0056255(1)

CD-5652(1)

CD-5638(1)

144156(1)

144154(1)

T8709MP(1)

 
Country of Origin

US(73)

IL(23)

CN(10)

China(2)

TW(1)

 
Width

48"(15)

17"(7)

50 ft(6)

12"(5)

3 1/2"(4)

9"(4)

9 1/2"(3)

72"(3)

18"(3)

18 1/4"(3)

10 ft(3)

6"(2)

3"(2)

16 3/4"(1)

12 3/4"(1)

17 1/2"(1)

30 ft(1)

11 1/2"(1)

6 1/4"(1)

11.50"(1)

41"(1)

30"(1)

11"(1)

 
Material(s)

Paper(2)

 
Theme

Assorted Colors(4)

Black(3)

Sea Buddies(3)

White(3)

Blue/Clear(2)

Stars(2)

Alphabet(2)

BoHo Birds(2)

My Food Plate(1)

Owl-Stars!(1)

Read All About Me(1)

You Are Responsible For You(1)

A Day Without Laughter Is A Day Wasted(1)

Attitude Is A Little Thing That Makes A Big Difference(1)

Extra, Extra, Read All About Me(1)

Our Birthday Graph!(1)

Assorted(1)

Funky Rings(1)

Polka Dots(1)

Paw Prints(1)

Our Bully Free Classroom(1)

The Human Body(1)

Phonetic Pencils(1)

Love Our Planet(1)

Black & White Stripes(1)

Weather Extremes(1)

Life Cycles(1)

Monthly Calendar(1)

Birthday Festival(1)

Calendar(1)

Sock Monkeys Alphabet Line(1)

Owl Stars Alphabet Line(1)

Owl-Stars Calendar(1)

Owl-Stars Job Chart(1)

Happy Birthday Bake Shop(1)

Frog-tastic! Jump Starters(1)

Owl Stars!(1)

Cranberry(1)

Sock Monkeys 0-120(1)

100th Day Happy Hound(1)

Monkey Mischief(1)

Place Values(1)

Giraffe Growth.(1)

"Year Around" Calendar(1)

Busy Bees(1)

Frog-tastic! Classroom Basics(1)

Furry Friends Classroom Basics(1)

Yellow(1)

Apple Green(1)

Dark Pink(1)

Measure Man(1)

Colors and Shapes(1)

Numbers 0-30(1)

Grade 3(1)

Grade 2(1)

Grade 1(1)

Kindergarten(1)

FUNky Frog Weather(1)

FUNky Frog Calendar(1)

Shooting Stars & Rainbow Bursts(1)

Early Learning(1)

Rocket Ship(1)

Brown Bear, Brown Bear, What Do You See?(1)

The Very Hungry Caterpillar(1)

Photographic Welcome(1)

Morning Meetings -Kindergarten(1)

Morning Meeting Solution for Grades 1-2(1)

Weather Frog(1)

Frogs Calendar(1)

Monkeys(1)

Language Arts(1)

Orange(1)

Brown(1)

Red(1)

The Writing Process(1)

Grass Green(1)

Dark Purple(1)

Sky Blue(1)

Dark Blue(1)

Blue(1)

Cream(1)

African Safari(1)

Math(1)

Insects(1)

Rain Forest(1)

Under the Sea(1)

Brick(1)

Clouds(1)

Winter Time(1)

Night Sky(1)

Tropical Foliage(1)

Happy Birthday - Banner(1)

 
Skill Learning

Writing(1)

Decoration(1)

Motivation(1)

Name(1)

Alphabet(1)

Vocabulary(1)

Word(1)

 
Number of Pieces

16(1)

 
Theme/Subject

Learning(1)

 
Choking Hazard

Warning 1(12)

 
Character Color

Red(1)

Black(1)

 
Mounting Type

Self Adhesive(2)

 
Product Type

Bulletin Board Set(1)

Name Plate(1)

 
Packaged Quantity

1 Each(1)

36 / Pack(1)

 
Assembly Required

No(1)

 
Package Contents

  • Pencil Character
  • Writing Traits Charts
  • Writing Traits Signs And Banner
(1)

 
Character Types

Letters(2)

 
Character Style

Uppercase(2)

 
 
 

© 2020-2021 Onestop, Inc., All Rights Reserved