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

Currently Filtered by

Category

Science

Refine Search

  GO
Manufacturer Part Number

T38058(1)

T38057(1)

T38056(1)

T38085(1)

T38086(1)

T38088(1)

T38087(1)

T38055(1)

T38054(1)

T38049(1)

T38048(1)

T38050(1)

T38051(1)

T38053(1)

T38052(1)

T38089(1)

T38090(1)

T38181(1)

T38179(1)

T38153(1)

T38183(1)

T38184(1)

T38192(1)

T38186(1)

T38152(1)

T38151(1)

T38093(1)

T38092(1)

T38094(1)

T38095(1)

T38120(1)

T38119(1)

T38046(1)

SV34231(1)

NP346009(1)

NP346008(1)

NP346007(1)

NP346011(1)

NST3033(1)

NST3036(1)

NST3034(1)

NP346001(1)

NP345001(1)

NP248001(1)

NP247001(1)

NP341001(1)

NP342001(1)

NP344001(1)

NP343001(1)

NST3053(1)

NST3065(1)

SLM151(1)

SG520(1)

SLM152(1)

SLM153(1)

SV34215(1)

SLM158(1)

SC529048(1)

SC529047(1)

NWISPBB(1)

NWISPBA(1)

NWISPBC(1)

SB0590407600(1)

SC514073(1)

SB0590414291(1)

T38193(1)

T38201(1)

TCR4867(1)

TCR4057(1)

TCR1801(1)

TCR5246(1)

TCR7632(1)

TCR7648(1)

TCR7633(1)

TCR1800(1)

TA67374(1)

T8150(1)

T8084(1)

T8181(1)

T8262(1)

T8605(1)

T8604(1)

TCR7649(1)

TCR7704(1)

TF8021(1)

TF8017(1)

TF8071(1)

TF8077(1)

UG01940(1)

TF8410(1)

TF8016(1)

TF8010(1)

TCR7736(1)

TCR7714(1)

TCR7740(1)

TCR7743(1)

TF2217(1)

TF2131(1)

T8063(1)

T8026(1)

T38301(1)

T38300(1)

T38299(1)

T38318(1)

T38321(1)

T38323(1)

T38322(1)

T38298(1)

T38297(1)

T38247(1)

T38233(1)

T38248(1)

T38292(1)

T38296(1)

T38294(1)

T38329(1)

T38913(1)

T49902(1)

T47145(1)

T63039(1)

T6407(1)

T8014(1)

T71003(1)

T47112(1)

T47107(1)

T38929(1)

T38928(1)

T38931(1)

T38934(1)

T38963(1)

T38944(1)

NP246001(1)

NP245001(1)

CD410080(1)

CD410078(1)

CD410077(1)

CD414002(1)

CD414005(1)

CD414019(1)

CD414017(1)

CD410076(1)

CD410065(1)

CD410037(1)

CD410029(1)

CD410048(1)

CD410049(1)

CD410056(1)

CD410054(1)

CD414066(1)

CD414070(1)

CD5938(1)

CD5925(1)

CD5921(1)

CD6358(1)

COR9781412959254(1)

CPB9781429671576(1)

CPB9781429670890(1)

CD5912(1)

CD5911(1)

CD5856(1)

CD414083(1)

CD5858(1)

CD5862(1)

CD5910(1)

CD5865(1)

CD410027(1)

CD410002(1)

CCP7750(1)

CCP7749(1)

CCP7748(1)

CD110007(1)

CD110078(1)

CD110094(1)

CD110079(1)

CCP7747(1)

CCP7556(1)

CCP7551(1)

CCP7550(1)

CCP7552(1)

CCP7553(1)

CCP7555(1)

CCP7554(1)

CD110178(1)

CD110208(1)

CD3257(1)

CD3215(1)

CD3258(1)

CD3275(1)

CD410000(1)

CD3425(1)

CD1938(1)

CD1916(1)

CD114057(1)

CD114021(1)

CD140044(1)

CD140045(1)

CD1776(1)

CD1701(1)

CPB9781429671712(1)

CPB9781429672313(1)

MCP198(1)

MCP197(1)

MCP196(1)

MCP206(1)

MCP208(1)

MCP212(1)

MCP211(1)

MCP179(1)

MCP153(1)

MCP097(1)

MCP077(1)

MCP111(1)

MCP128(1)

MCP152(1)

MCP149(1)

MCP214(1)

MCP215(1)

NL0522(1)

MCV1669(1)

NP241001(1)

NP242001(1)

NP244001(1)

NP243001(1)

MCV1661(1)

MCV1653(1)

MCV1619(1)

MCV1605(1)

MCV1636(1)

MCV1646(1)

MCV1652(1)

MCV1648(1)

LFV22312(1)

LER2395(1)

EP2287(1)

DJ610046(1)

DJ610032(1)

EP2298(1)

EP3641(1)

EPLRN265(1)

EPLRN263(1)

CTP5715(1)

CTP5700(1)

CTP1007(1)

CPB9781429683548(1)

CTP2182(1)

CTP2183(1)

CTP4332(1)

CTP2987(1)

GR12891(1)

GRG4000211(1)

HVA671(1)

HVA571(1)

HVA672(1)

JAX9020(1)

LCI4371(1)

KE846047(1)

HOSET11(1)

HO9780547418544(1)

HE9781432941468(1)

HC9780064452212(1)

HE9781432941475(1)

HE9781432941482(1)

HE9781432941536(1)

HE9781432941499(1)

CCP7549(1)

Price Range

$0-$49.99(248)

$50-$99.99(17)

To  GO

 
 
1%
Searching for your Best Results.....
 

© 2017-2018 Office Solutions & Innovations, Inc., All Rights Reserved