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 (`pinfo`.`sku` IN ('SAN30001','PAP8430152','SAN30002','PAP8410152','PAP8420152','PAC001318','SPR23810','PAP1928605','BSN82977','SAN25005','DEF421103','STX70105U06C','PAC001309','TEPT6480','AVT34004','AVT34104','PAC001327','CLI32004','CLI32005','PAC001308','HUB910L','AVT34007','DEF329003BB','HUBSA98','PAC1733','PAC001310','AVT40309','CEP2006950110','SPR23811','PAC001316','AKM10126','CLI32006','PAC5166','HUB18','AVT37530','PAC001312','BSN82979','PAC74170','MEA59010','STX00941U06C','HUB91018','HUB67L','STX62012U03C','LRNLER0477','TEPT73901','HUB16','MEA20038','PAC20010','TEPT83901','TEPT73902','MPD7940B','TEPT83905','DEF350201','CDPCD5615','DEF350501','MEA59016','MEA20040','LRNLER3776','LRNLER2418','TEPT2951','LRNLER6900','TEPT1945','MPD8207','BSN82980','MEA59012','STX62406U06C','USS4630','LRNLER2206','MEA59014','BAU77042','MPD8210','LRNLER4275','AVE18701','CDP158161','TEPT46917','CEP2006760110','PAC20360','MPD7917B','TCR6644','MPD7904B','STX70109U06C','MPD7928B','TCR9028','DEF3901CR','TEPT1942','LRNLER3806','CDP158158','AVT5703','CDPCD5644','ASH10400','CTC6686','TCR20736','TEPT2965','MPD7500B','PAC20410','TEPT68070','HYX15730','HYX15630','LRNLER2255','DEF3900CR','ASH10403','PAC20800','CTC7425','TEPT81019','CDP158567','LRNLER6447','LRNLER0678','CTC7424','TEP69401','TEPT8107','CDP122029','TEPTA67909','TEPT68022','MPD2117B','TEP25212','TCR20738','TEPT81401','HYX43510','TCR9029','MPD7662B','CDP158563','TEP25202','CDP158565','CDP9413','MPD52060B','MPD52039B','TEP69402','TEPT25044','CTC5649','TEPT25053','TCR2152','')) 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 '%UltimateLearningEnvironment' THEN 1 ELSE 0 END DESC, CASE WHEN MATCH(`desc_short`) AGAINST ('UltimateLearningEnvironment' IN BOOLEAN MODE) THEN 1 ELSE 0 END DESC, CASE WHEN `pinfo`.`vendor`=2 THEN IF(MATCH(`desc_long`, `manufacturer_name`, `color`) AGAINST ('+UltimateLearningEnvironment' IN BOOLEAN MODE),4,0) ELSE CASE WHEN MATCH (`keywords`) AGAINST ('"UltimateLearningEnvironment"' IN BOOLEAN MODE) AND MATCH (`desc_title`) AGAINST ('"UltimateLearningEnvironment"' IN BOOLEAN MODE) THEN 4 ELSE IF(MATCH (`desc_title`) AGAINST ('"UltimateLearningEnvironment"' IN BOOLEAN MODE),3,IF(MATCH (`keywords`) AGAINST ('"UltimateLearningEnvironment"' IN BOOLEAN MODE),2,IF(MATCH(`desc_title`, `manufacturer_name`, `color`) AGAINST ('+UltimateLearningEnvironment' IN BOOLEAN MODE),1,0))) END END DESC,CASE WHEN IF(`pinfo`.`vendor`=2,`category_3` ='UltimateLearningEnvironment',`category_4` ='UltimateLearningEnvironment') THEN 1 ELSE 0 END DESC, CASE WHEN `desc_short` LIKE 'UltimateLearningEnvironment,%' THEN 1 ELSE 0 END DESC, SUBSTR(`pinfo`.`desc_title`, 1, LOCATE('UltimateLearningEnvironment', `pinfo`.`desc_title`)) DESC

Currently Filtered by

UltimateLearningEnvironment

UltimateLearningEnvironment

Refine Search

  GO
 
Category

Charts(12)

Desktop Organizers(8)

Stickers(8)

Wood Pencils(8)

Storage Boxes & Containers(7)

Certificates(5)

Posters(5)

Memo / Subject Notebooks(4)

Felt-tip/Porous Point Pens(4)

Learning Boards(4)

Decorative Banners(4)

Creative Learning(3)

Art Pencils(3)

Educational Record Books(3)

Mailroom Sorters & Tables(3)

Name Badges/Systems(3)

Teaching Calendars & Planners(3)

Report Covers(3)

Craft Supplies(3)

Hanging Pockets(2)

Permanent Markers(2)

Portable Storage Files & Bins(2)

Pocket Charts(2)

Teacher/Classroom Management(2)

Wall Organizer Systems(2)

Wall Organizers/Sorters(2)

Self-Inking Stamps(2)

Vinyl/Plastic Pockets & Sleeves(2)

Mobile File Carts & Cabinets(2)

Tank-Style Highlighters(1)

Portable File Caddies(1)

Literature Organizers/Sorters(1)

Storage Systems(1)

Appointment Books & Planners(1)

Nameplates(1)

Teaching Flash Cards(1)

Tool Storage & Organization(1)

Copier/Laser/Inkjet Index Dividers(1)

Index Dividers(1)

Wall Files, Pockets & Accessories(1)

Dry-Erase Boards(1)

Note Cards(1)

Binder Pockets(1)

Magazine Files(1)

Desktop File Sorters(1)

Stamp Pads(1)

 
Brand

Trend(22)

Moon Products(11)

Learning Resources(10)

Carson-Dellosa(9)

Pacon(7)

Classroom Keepers(7)

Deflecto(6)

Teacher Created Resources(6)

Ward(6)

Advantus(5)

Storex(5)

Paper Mate(4)

Creative Teaching Press(4)

Cambridge(4)

Sharpie(3)

Hygloss(3)

C-Line(3)

Business Source(3)

Ashley(2)

Five Star(2)

Sparco(2)

CEP(2)

Stamp-Ever(1)

Gem Office Products(1)

Baumgartens(1)

Akro-Mils(1)

 
Color

Assorted(15)

Clear(12)

Multicolor(11)

Blue(10)

White(9)

Red(6)

Green(4)

Purple(4)

Yellow(3)

Clear Pocket(3)

Black(3)

Assorted Bright(2)

Clear Label Holder(2)

Off White(2)

Multi(2)

Dark Green(2)

Neon Green(1)

Neon Yellow(1)

Neon Orange(1)

Neon Pink(1)

Neon Blue(1)

Silver(1)

Gold(1)

Transparent(1)

Smoke(1)

Teal(1)

Lime(1)

Aqua(1)

 
Size

8.50" Width x 5.50" Length(3)

8.50" Width x 11" Length(2)

9" Height(1)

 
Size

Letter(3)

 
Recycled

No(105)

Yes(10)

 
Sheet Size

8 1/2" Width x 11" Length(7)

11" x 8 7/8"(1)

3" x 5"(1)

 
 
 

© 2019-2020 Dawkins Office Supply, All Rights Reserved