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

MasterVision(13)

Chartpak(12)

Quartet(8)

TREND(7)

Pacon(4)

Officemate(3)

Trend(2)

Carson-Dellosa Publishing(1)

Carson-Dellosa Education(1)

Scholastic(1)

 
Color

Assorted(1)

 
Recycled

No(2)

 
Packaged Quantity

5 / Set(1)

5 / Pack(1)

 
Assembly Required

No(1)

 
Warranty

Manufacturer's one-year limited warranty.(2)

 
Special Features

Uppercase Letters and Numbers(5)

Numbers Only(4)

Uppercase Letters Only(3)

Magnetic Color-Coding Circles(2)

Color-Coding Magnets(2)

Plastic-Covered High-Intensity Magnets(2)

Molded Magnetic, 128 Characters(2)

For Plastic Surface, 144 Characters(2)

For Felt Surface, 300 Characters(2)

Days of the Week Magnetic Tape-Set of seven.(1)

Heavy-Duty-Three times as strong as standard magnets.(1)

Magnetic Letter Sets-Set of 120 uppercase letters and punctuation marks.(1)

Includes seven chartlets(1)

Months of the Year Magnetic Tape-Set of 12.(1)

Magnetic Numbers Sets-Set of 10 each: numbers 1-10, dollar signs ($), cent signs (), percentage signs (%) and decimal points (.).(1)

Professional Kit(1)

Magnetic Push Pins(1)

Super Strong Magnets(1)

Extra, Extra, Read All About Me(1)

 
For Use With

Felt Surface, 300 Characters-4400 Series(2)

Plastic Surface, 144 Characters-F Series(2)

M Series for boards with steel surface(1)

 
Diameter

3/4"(5)

0.75"(4)

0.75"; 1.38"; 1.5"(2)

0.45"(1)

 
Skill Learning

Shape(1)

Number(1)

Color(1)

Alphabet(1)

Opposite(1)

 
Recommended Age

3-6 Year(1)

 
Theme/Subject

Learning(2)

 
Manufacturer Part Number

FM1007(1)

M-1(1)

92515(1)

56225(1)

56465(1)

56475(1)

56525(1)

4421(1)

4423(1)

85391(1)

F-1(1)

F-1/2(1)

M-3/4(1)

92500(1)

MPPC(1)

0439152917(1)

38920(1)

38961(1)

T1613(1)

T1617(1)

T79743(1)

T79901(1)

T79902(1)

T79903(1)

92501(1)

01198(1)

FM1108(1)

KT2220(1)

FM1601(1)

FM1602(1)

FM1604(1)

FM1605(1)

FM1618(1)

IM130809(1)

IM140909(1)

IM356601(1)

KT1317(1)

KT2020(1)

144131(1)

01193(1)

CD-5638(1)

01010(1)

01020(1)

01030(1)

01040(1)

01050(1)

01070(1)

01130(1)

01170(1)

01175(1)

01184(1)

T8194(1)

 
Country of Origin

US(26)

PT(13)

CN(11)

United States(2)

 
Height

3/4"(9)

4"(8)

1"(7)

0.75"(5)

48"(4)

1/2"(3)

3"(2)

6"(2)

24"(1)

1 1/2"(1)

2"(1)

22"(1)

 
Width

50 ft(4)

2"(2)

0.5"(2)

30"(1)

3/8"(1)

0.45"(1)

17"(1)

 
Color(s)

Blue/Clear(1)

 
Material(s)

Vinyl(20)

Plastic(9)

Paper(6)

Plastic/Magnet(2)

Plastic/Steel(1)

Neodymium(1)

 
Theme

Early Learning(1)

Blue/Clear(1)

Night Sky(1)

Clouds(1)

Brick(1)

Under the Sea(1)

Extra, Extra, Read All About Me(1)

Stars(1)

 
Number of Pieces

5(1)

 
Choking Hazard

Y(4)

 
Character Style

Helvetica(18)

Casual(5)

Circles(2)

Uppercase(1)

Playful(1)

 
Character Types

Letters;Numbers;Symbols(9)

Circles(8)

Numbers(5)

Letters;Numbers(5)

Uppercase Letters(3)

Letters;Numbers;Punctuation(2)

Days of the Week(1)

Months of the Year(1)

Arrows; Circles; Squares; Triangles(1)

Letters(1)

Push Pin(1)

Magnets(1)

Push Pins(1)

Letters;Numbers;Spanish;Punctuation(1)

 
Character Color

Black(16)

White(7)

Assorted(4)

Black; White(2)

Blue(2)

Red(2)

Green(1)

Silver(1)

Blue; Red(1)

Assorted Translucent(1)

Clear(1)

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

Silver Sparkle(1)

Blue Sparkle(1)

Yellow(1)

 
 
 

© 2020-2021 Midtown Office Supplies, All Rights Reserved