SELECT `pinfo`.`sku`,`pinfo`.`vendor`, 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_12` 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 ('STEM4E','STEM4D','STEM3E','STEM3D','STEM2E','STEM2D','STEM1E','STEM1D','STRIPPED SKU','MTT42003','SPR01490','BSN32365','BSN32361','CKC707','LRNLER45761','LEO77120','ACM12975','LEO39100ST','SPR38277','TEPT53105','MTTBJV44','EII7881','MTTDKD47','LRNLER0056','LRNLER6366','TEPT6068','LRNLER6644','MTTW4729','LRNLER0176','LRNLER2831','TEP38913','LRNLER2629','LRNLER0360','LRNLER2202','LRNLER9164','MTTN1387','EII4112','LRNLER2102','LRNLER9209','LRNLER2841','CKC4468','TEPT53101','LRN2821','CDP0768223199','LRN2509','LRN0786','LRN2064','EII5210','MTT42050','LRNLER2774','MTTT5931','LRNLER5052','TEPT53106','LRNLER0930','EII8476','LRNLER2344','LRNLER4335','CDP0768218624','TEPT1670','LRNLER3372','TEPT53103','TCR6434','LRNLER0615','LRNLER9162','CDP0768223202','LRNLER2075','CDP140314','TEP23040','LRNLER0139','LRNLER2834','LRNLER0047','LRNLER2046','LRN2784','LRNLER2690','LRN1207','LRNLER2884','TEP53203','RYLR6085','LRNLER2434','LRN1772','TCR7817','SHS0545015987','LRNLER4963','LRNLER2415','MTT78857','LRNLER2442','TEP6136','RYLR5910','SHS0545015979','LRNLER2420','LRNLER1963','TEPT6071','TEPT6069','LRN0790','LRNLER0264','LRNLER6380','TCR6175','LRN2094','LRNLER1100','LRNLER0306','LRN4429','LRNLER2450','LRN5080','LRNLER0389','SHS0545578140','TEPT6135','LRNLER2427','LRN2830','RYLR5804','LRNLER2394','RYLR5815','TEP6072','CKC95172','TCR7819','RYLR5823','TCR7818','RYLR5911','LRN2822','LRN2783','LRNLER1764','LRNLER2779','LRNLER2430','LRN2833','ASH10066','RYLR5843','RYLR5837','LRN2827','RYLR5842','LRNLER1900','RYLR5914','TCR3025','LRNLER2145','LRNLER1901','CKC4398','TCR7858','TCR7859','TCR3027','RYLR5803','TCR2221','CDP104909','TCR3024','TEP38929','TCR3897','TCR7857','TCR3869','LRNLER2725','TCR3664','CDP104907','TCR7856','CDP104908','CDP104906','CDP104904','CDP104905','LRNLER7734','','','LER0047','LER0056','LER0139','LER0176','LER0264','LER0306','LER0360','LER0389','LER0615','LER0786','LER0790','LER0930','LER1100','LER1207','LER1764','LER1772','LER1900','LER1901','LER1963','LER2046','LER2064','LER2075','LER2094','LER2102','LER2145','LER2202','LER2344','LER2394','LER2415','LER2420','LER2427','LER2430','LER2434','LER2442','LER2450','LER2509','LER2629','LER2690','LER2725','LER2774','LER2779','LER2783','LER2784','LER2821','LER2822','LER2827','LER2830','LER2831','LER2833','LER2834','LER2841','LER2884','LER3372','LER4335','LER4429','LER45761','LER4963','LER5052','LER5080','LER6366','LER6380','LER6644','LER7734','LER9162','LER9164','LER9209','MAT42003','MAT42050','MAT78857','MATBJV44','MATDKD47','MATN1387','MATT5931','MATW4729','ACM12975','ASH10066','BSN32361','BSN32365','CDP0768218624','CDP0768223199','CDP0768223202','CDP104904','CDP104905','CDP104906','CDP104907','CDP104908','CDP104909','CDP140314','CKC4398','CKC4468','CKC707','CKC95172','EII4112','EII5210','EII7881','EII8476','LEO39100ST','LEO77120','RYLR5803','RYLR5804','RYLR5815','RYLR5823','RYLR5837','RYLR5842','RYLR5843','RYLR5910','RYLR5911','RYLR5914','RYLR6085','SHS0545015979','SHS0545015987','SHS0545578140','SPR01490','SPR38277','TCR2221','TCR3024','TCR3025','TCR3027','TCR3664','TCR3869','TCR3897','TCR6175','TCR6434','TCR7817','TCR7818','TCR7819','TCR7856','TCR7857','TCR7858','TCR7859','TEP23040','TEP38913','TEP38929','TEP53203','TEP6072','TEP6136','TEPT1670','TEPT53101','TEPT53103','TEPT53105','TEPT53106','TEPT6068','TEPT6069','TEPT6071','TEPT6135','')) 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_cost`=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 ('STEM' IN BOOLEAN MODE) THEN 1 ELSE 0 END DESC, CASE WHEN `pinfo`.`vendor`=2 THEN IF(MATCH(`desc_long`, `manufacturer_name`, `color`) AGAINST ('+STEM' IN BOOLEAN MODE),4,0) ELSE CASE WHEN MATCH (`keywords`) AGAINST ('"STEM"' IN BOOLEAN MODE) AND MATCH (`desc_title`) AGAINST ('"STEM"' IN BOOLEAN MODE) THEN 4 ELSE IF(MATCH (`desc_title`) AGAINST ('"STEM"' IN BOOLEAN MODE),3,IF(MATCH (`keywords`) AGAINST ('"STEM"' IN BOOLEAN MODE),2,IF(MATCH(`desc_title`, `manufacturer_name`, `color`) AGAINST ('+STEM' IN BOOLEAN MODE),1,0))) END END DESC,CASE WHEN IF(`pinfo`.`vendor`=2,`category_3` ='STEM',`category_4` ='STEM') THEN 1 ELSE 0 END DESC, CASE WHEN `desc_short` LIKE 'STEM,%' THEN 1 ELSE 0 END DESC, SUBSTR(`pinfo`.`desc_title`, 1, LOCATE('STEM', `pinfo`.`desc_title`)) DESC

Currently Filtered by

STEM

STEM

Refine Search

  GO
Category Filter

Creative Learning(25)

Office Supplies(19)

Robot(6)

Flash Cards(5)

Pocket Charts(4)

Time(2)

Rulers(2)

Lab Equipment(2)

Counting(2)

Classics(2)

Activity Books & Kits(2)

Math(2)

Shopping(2)

Instruments(2)

Blocks & Construction Play(1)

Energy(1)

Astronomy(1)

Magnetism(1)

Addition & Subtraction(1)

Card Games(1)

Microscopes(1)

Mats(1)

Fractions & Decimals(1)

Teaching Flash Cards(1)

Lacing(1)

Place Value(1)

Animal Studies(1)

Measurement(1)

Thermometers/Probe Covers(1)

Magnifiers(1)

Plant Studies(1)

Experiments(1)

Brand

Teacher Created Resources(15)

TREND(5)

Creativity Street(3)

Ashley(1)

Westcott(1)

Charles Leonard(1)

Color

Multi(15)

Assorted(1)

Multicolor(1)

Recycled

No(2)

Height

6"(4)

5 1/2"(1)

1.3"(1)

Color(s)

Black and White(4)

White(1)

Natural(1)

Width

3"(4)

5 1/2"(1)

1.5"(1)

11"(1)

1.8"(1)

Depth

8.5"(1)

 
 
Searching for your Best Results.....
Loading...
 
AbilityOne Distributor Wildcard SSL Certificates

© 2018-2019 United Supply Corp, All Rights Reserved