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

Manufacturer

Currently Filtered by

Manufacturer

Learning Resources

Refine Search

  GO
Category

Creative Learning(149)

Pocket Charts(9)

Plastic Toys(8)

Learning Boards(5)

Teaching Flash Cards(4)

Charts(4)

Magnifiers(3)

Desk Clocks(3)

Puzzles(3)

Educational Record Books(2)

Desktop Organizers(2)

Hooks & Hangers(2)

Cash Registers(2)

Craft Supplies(2)

Dry-Erase Boards(2)

Stamp Pads(1)

Drafting Kits(1)

Tickets(1)

Compass(1)

Wall Files, Pockets & Accessories(1)

Maps(1)

Play/Rest Mats(1)

Digital Cameras(1)

Magnetic Clips(1)

Handheld Calculators(1)

Journals(1)

Teaching Aids(1)

Stethoscopes(1)

Magnetic Letters & Numbers(1)

Eye Protection(1)

Self-Inking Stamps(1)

Brand

Learning Resources(187)

New Sprouts(10)

Gears!Gears!Gears!(7)

Smart Snacks(5)

Pretend & Play(3)

Rainbow Fraction(3)

Three Bear Family(1)

Color

Multi(52)

Assorted(31)

Blue(6)

Red(6)

Green(6)

Yellow(5)

Purple(3)

Multicolor(3)

Clear(2)

Orange(2)

White(1)

Translucent(1)

Silver(1)

Wood Grain(1)

Assorted Bright(1)

Clear Bucket(1)

Size

4.25" Height x 3" Diameter - Can(2)

10" Diameter - Mercury(1)

8" Diameter - Pluto(1)

10" Diameter - Mars(1)

12" Diameter - Earth(1)

8" Diameter - Earth's Moon(1)

2.25" Height x 4.50" Width - Stand(1)

2" Height x 2" Width - Block(1)

9" Height(1)

1.75" Height - Uppercase Letters(1)

12" Diameter - Venus(1)

14" Diameter - Uranus(1)

4" Height - Student Clocks(1)

13.25" Height - Demonstration Clock(1)

6" Height x 16.50" Width x 6.50" Diameter(1)

1" Height - Bear(1)

11" Height x 13" Width(1)

36" Diameter - Sun(1)

14" Diameter - Neptune(1)

18" Diameter - Saturn(1)

22" Diameter - Jupiter(1)

9.06" Width - Plastic base(1)

Recycled

No(182)

Price Range

$0-$99.99(212)

$100-$199.99(3)

$300-$399.99(1)

To  GO

 
 
Searching for your Best Results.....
 
HP Qualified Supplies Partner Salt Lake City Green CNG CleanAir Granite Office

© 2019-2020 Granite Office, LLC, All Rights Reserved