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)

Carson-Dellosa Publishing(2)

Trend(2)

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)

Magnetic Color-Coding Circles(4)

Uppercase Letters Only(3)

Plastic-Covered High-Intensity Magnetic Circles(3)

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)

Includes seven chartlets(1)

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

Magnetic Letter Sets-Set of 120 uppercase letters and punctuation marks.(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)

Extra, Extra, Read All About Me(1)

 
Diameter

3/4"(8)

3/4"; 1 3/8"; 1 1/2"(2)

1 1/4"(1)

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"(13)

4"(8)

1"(7)

48"(4)

1/2"(3)

3"(2)

6"(2)

1/4"(1)

24"(1)

1 1/2"(1)

2"(1)

22"(1)

 
Width

50 ft(4)

2"(2)

1/2"(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