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') 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)

18"(4)

6 1/4"(4)

12"(4)

12 2/5"(3)

7.88"(2)

31"(2)

0.05"(2)

8 1/2"(2)

17 1/2"(1)

23"(1)

11"(1)

3.50"(1)

24"(1)

24 1/2"(1)

0.06"(1)

5"(1)

3 1/2"(1)

 
Color(s)

Assorted(9)

Black/Purple/White(4)

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

Black(3)

White(3)

Blue/Clear(2)

Orange(1)

Red(1)

Dark Pink(1)

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

Apple Green(1)

Yellow(1)

Cranberry(1)

Sky Blue(1)

Cream(1)

Brown(1)

Blue(1)

Dark Blue(1)

Dark Purple(1)

Black/White(1)

Grass Green(1)

 
Manufacturer Part Number

SC553079(1)

4040(1)

054541752X(1)

0545417449(1)

0545039924(1)

4114(1)

4757(1)

T25044(1)

T25046(1)

T10998(1)

T10996(1)

9027(1)

0439509963(1)

0439492815(1)

23809124520(1)

23809124599(1)

23809124510(1)

238091227099(1)

1U384804070(1)

238121827099(1)

23812184510(1)

0439152917(1)

0439492262(1)

0439152852(1)

23812184599(1)

23812184520(1)

T25047(1)

T38913(1)

T8330(1)

T8350(1)

T8306(1)

T8304(1)

T8302(1)

T8360(1)

T8363(1)

T8709(1)

T8709MP(1)

T8416(1)

T8415(1)

T8364(1)

T8299(1)

T8298(1)

T38970(1)

T8077(1)

T38964(1)

T38963(1)

T38934(1)

T8096(1)

T8176(1)

T8280(1)

T8201(1)

T8194(1)

T8182(1)

1U384804065(1)

1U384804064(1)

119002(1)

119003(1)

119001(1)

119000(1)

110232(1)

119004(1)

119005(1)

122006(1)

122012(1)

119017(1)

119013(1)

119010(1)

110208(1)

110205(1)

110114(1)

110115(1)

110079(1)

110076(1)

110014(1)

110119(1)

110132(1)

110199(1)

110202(1)

110143(1)

110142(1)

110134(1)

122013(1)

144131(1)

1U384804031(1)

1U384804040(1)

1U384804030(1)

1U384804020(1)

1U384804010(1)

1U384804041(1)

1U384804042(1)

1U384804060(1)

1U384804061(1)

1U384804056(1)

1U384804050(1)

1U384804043(1)

78930(1)

78920(1)

CD-5652(1)

0056255(1)

CD-5638(1)

144156(1)

144154(1)

56225(1)

56385(1)

78840(1)

56525(1)

56475(1)

56465(1)

22018(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)

10 ft(3)

18"(3)

72"(3)

9 1/2"(3)

18 1/4"(3)

6"(2)

3"(2)

17 1/2"(1)

12 3/4"(1)

11"(1)

16 3/4"(1)

11.50"(1)

30"(1)

41"(1)

30 ft(1)

6 1/4"(1)

11 1/2"(1)

 
Material(s)

Paper(2)

 
Theme

Assorted Colors(4)

White(3)

Sea Buddies(3)

Black(3)

Stars(2)

Alphabet(2)

Blue/Clear(2)

BoHo Birds(2)

Read All About Me(1)

Extra, Extra, Read All About Me(1)

Owl-Stars!(1)

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

A Day Without Laughter Is A Day Wasted(1)

Cranberry(1)

You Are Responsible For You(1)

Yellow(1)

Assorted(1)

Polka Dots(1)

Phonetic Pencils(1)

Funky Rings(1)

My Food Plate(1)

The Human Body(1)

Our Birthday Graph!(1)

Paw Prints(1)

Our Bully Free Classroom(1)

Love Our Planet(1)

Weather Extremes(1)

Owl-Stars Job Chart(1)

Happy Birthday Bake Shop(1)

Frog-tastic! Jump Starters(1)

Monthly Calendar(1)

Owl-Stars Calendar(1)

Owl Stars Alphabet Line(1)

Happy Birthday - Banner(1)

Birthday Festival(1)

Calendar(1)

Sock Monkeys Alphabet Line(1)

Owl Stars!(1)

Sock Monkeys 0-120(1)

Busy Bees(1)

Frog-tastic! Classroom Basics(1)

Furry Friends Classroom Basics(1)

Dark Pink(1)

"Year Around" Calendar(1)

Giraffe Growth.(1)

100th Day Happy Hound(1)

Monkey Mischief(1)

Place Values(1)

Life Cycles(1)

Grass Green(1)

Grade 1(1)

Kindergarten(1)

FUNky Frog Weather(1)

FUNky Frog Calendar(1)

Grade 2(1)

Grade 3(1)

Monkeys(1)

Colors and Shapes(1)

Numbers 0-30(1)

Measure Man(1)

Shooting Stars & Rainbow Bursts(1)

Morning Meeting Solution for Grades 1-2(1)

Weather Frog(1)

Frogs Calendar(1)

The Writing Process(1)

Morning Meetings -Kindergarten(1)

Photographic Welcome(1)

Rocket Ship(1)

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

The Very Hungry Caterpillar(1)

Early Learning(1)

Language Arts(1)

Dark Blue(1)

Blue(1)

Cream(1)

Brown(1)

Sky Blue(1)

Dark Purple(1)

Red(1)

Apple Green(1)

Black & White Stripes(1)

African Safari(1)

Insects(1)

Night Sky(1)

Tropical Foliage(1)

Math(1)

Winter Time(1)

Clouds(1)

Rain Forest(1)

Under the Sea(1)

Brick(1)

Orange(1)

 
Skill Learning

Vocabulary(1)

Word(1)

Alphabet(1)

Name(1)

Decoration(1)

Motivation(1)

Writing(1)

 
Number of Pieces

16(1)

 
Theme/Subject

Learning(1)

 
Choking Hazard

Warning 1(12)

 
Character Color

Black(1)

Red(1)

 
Mounting Type

Self Adhesive(2)

 
Product Type

Name Plate(1)

Bulletin Board Set(1)

 
Packaged Quantity

36 / Pack(1)

1 Each(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)

 
 
 

© 2018-2019 Onestop, Inc., All Rights Reserved