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

Currently Filtered by

Category

Classroom Decorations

Refine Search

  GO
Brand

TREND(21)

Carson-Dellosa Publishing(12)

Pacon(12)

Scholastic(7)

Smart-Fab(5)

Teacher Created Resources(1)

Height

48"(12)

22"(5)

31"(5)

7.88"(2)

0.05"(2)

27 1/4"(2)

12"(2)

40 ft.(2)

6 1/4"(2)

23"(1)

8 1/2"(1)

3"(1)

24"(1)

18"(1)

24 1/2"(1)

5"(1)

Color(s)

Assorted(12)

Black(2)

Blue/Clear(2)

Black/Purple/White(2)

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

Cream(1)

Cranberry(1)

White(1)

Manufacturer Part Number

38961(1)

38920(1)

8305(1)

8340(1)

T10996(1)

8341(1)

4757(1)

SC553562(1)

0545417449(1)

0439152917(1)

SC553072(1)

SC553079(1)

SC553125(1)

T10998(1)

T38913(1)

T8306(1)

T8304(1)

T8350(1)

T8360(1)

T8364(1)

T8363(1)

T8302(1)

T8299(1)

T8096(1)

T38963(1)

T8173(1)

T8194(1)

T8201(1)

0439152852(1)

23812184520(1)

144156(1)

144131(1)

CD-5638(1)

CD-5652(1)

0055855(1)

0055805(1)

122006(1)

119017(1)

110199(1)

110119(1)

110232(1)

119001(1)

119003(1)

0057405(1)

0057425(1)

1U384804031(1)

78930(1)

1U384804065(1)

23809124510(1)

23809124520(1)

78920(1)

56525(1)

56225(1)

0057705(1)

56385(1)

56465(1)

56475(1)

110079(1)

Country of Origin

US(43)

CN(10)

IL(5)

Width

50 ft(10)

17"(5)

18 1/4"(5)

18"(4)

6"(2)

9"(2)

48"(2)

72"(2)

3 1/2"(2)

17 1/2"(1)

12 3/4"(1)

9 1/2"(1)

6 1/4"(1)

41"(1)

12"(1)

30"(1)

Theme

Sea Buddies(3)

Jingle Jungle Animals(2)

Blue/Clear(2)

Black(2)

Monkey Mischief, Calendar(1)

Sea Buddies, Happy Birthday(1)

Monkey Mischief, Birthday(1)

Owl-Stars!(1)

Photographic Welcome(1)

Technology, Online Safety(1)

KINDERGARTEN Basic Skills, Shapes, Colors, Alphabet, Opposites, Numbers(1)

Measure Man(1)

Our Bully Free Classroom(1)

My Name(1)

Polka Dots(1)

The Human Body(1)

Weather Extremes(1)

Happy Birthday Bake Shop(1)

Owl-Stars Job Chart(1)

Owl-Stars Calendar(1)

Owl Stars Alphabet Line(1)

Monthly Calendar(1)

Owl Stars!(1)

"Year Around" Calendar(1)

USDA's MyPyramid(1)

Stars(1)

Monkey Mischief(1)

My Food Plate(1)

Extra, Extra, Read All About Me(1)

Classic Moroccan Black(1)

Chic Chevron Yellow(1)

Classic Dots Red(1)

Classic Dots Aqua(1)

Chic Chevron Pink(1)

BoHo Birds(1)

Math(1)

Grade 3(1)

Colors and Shapes(1)

Alphabet(1)

Early Learning(1)

Night Sky(1)

Winter Time(1)

Cranberry(1)

White(1)

Weather Frog(1)

Read All About Me(1)

Cream(1)

African Safari(1)

Clouds(1)

Brick(1)

Under the Sea(1)

Insects(1)

Grade 1(1)

Choking Hazard

Warning 1(3)

Price Range

$0-$9.99(7)

$10-$19.99(39)

$20-$29.99(10)

To  GO

 
 
1%
Searching for your Best Results.....
 

© 2017-2018 Office Solutions & Innovations, Inc., All Rights Reserved