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

Currently Filtered by

Category

Math

Refine Search

  GO
Manufacturer Part Number

SV99847(1)

SV99830(1)

SV99823(1)

SV99816(1)

SZP08403(1)

T1090(1)

T38010(1)

T24014(1)

T24013(1)

SV99724(1)

SV99717(1)

SV9780547898254(1)

SV9780547898247(1)

SV9780547898230(1)

SV9780547898278(1)

SV9780547898285(1)

SV99700(1)

SV99694(1)

SV9780547898308(1)

T38012(1)

T38013(1)

T38081(1)

T38080(1)

T38079(1)

T38024(1)

T38084(1)

T38123(1)

T38169(1)

T38125(1)

T38124(1)

T38023(1)

T38022(1)

T38016(1)

T38015(1)

T38014(1)

T38017(1)

T38018(1)

T38021(1)

T38020(1)

T38019(1)

SV9780547898223(1)

SV9780547873909(1)

NP337001(1)

NP336001(1)

NP335001(1)

NP334001(1)

NP338001(1)

NST3026(1)

NWIMPBB(1)

NWIMPBA(1)

NST3067(1)

NP333001(1)

NP332001(1)

NP330024(1)

NP330023(1)

NP238001(1)

NP330025(1)

NP330026(1)

NP331001(1)

NP330035(1)

NP330027(1)

NWIMPBC(1)

QS9781423217671(1)

SV9780547872391(1)

SV9780547872360(1)

SV9780547872353(1)

SV9780547872407(1)

SV9780547872414(1)

SV9780547873893(1)

SV9780547873886(1)

SV9780547872421(1)

SC9780439720892(1)

SC553078(1)

SC0590378724(1)

QS9781423217701(1)

QS9781423217688(1)

SC529041(1)

SC529042(1)

SC553076(1)

SC540224(1)

SC529045(1)

T38170(1)

T38171(1)

TCR7781(1)

TCR7773(1)

TCR7758(1)

TCR7739(1)

TCR7803(1)

TCR7804(1)

TCR7834(1)

TCR7833(1)

TCR7807(1)

TCR7732(1)

TCR7730(1)

TCR4772(1)

TCR3873(1)

TCR3858(1)

TCR7606(1)

TCR7643(1)

TCR7717(1)

TCR7697(1)

TCR7645(1)

TCR8106(1)

TF2127(1)

WCA4608(1)

WCA4223(1)

WCA4040(1)

TF8422(1)

WCA4612(1)

WCA4638(1)

WCA4730(1)

WCA4725(1)

WCA4712(1)

TF8409(1)

TF7158(1)

TF2505(1)

TF2292(1)

TF2189(1)

TF7005(1)

TF7006(1)

TF7157(1)

TF7116(1)

TF7115(1)

TCR3855(1)

TCR3854(1)

T38336(1)

T38275(1)

T38274(1)

T38244(1)

T38474(1)

T38912(1)

T58102(1)

T47086(1)

T38919(1)

T38243(1)

T38212(1)

T38174(1)

T38173(1)

T38172(1)

T38175(1)

T38176(1)

T38209(1)

T38206(1)

T38177(1)

T76002(1)

T76007(1)

TA67368(1)

TA67238(1)

TA67237(1)

TA67369(1)

TA67371(1)

TCR3850(1)

TCR1926(1)

TA67916(1)

TA67124(1)

TA63087(1)

T8156(1)

T8142(1)

T81025(1)

T8157(1)

T8182(1)

T94224(1)

T94223(1)

T8256(1)

NP237001(1)

NP236001(1)

CMM01020(1)

CMM01001(1)

CD6381(1)

CD6304(1)

COR9781412959261(1)

CPB9781429663342(1)

CRE4377(1)

CRE4373(1)

CRE4002(1)

CD6048(1)

CD5941(1)

CD5917(1)

CD5908(1)

CD414075(1)

CD5918(1)

CD5920(1)

CD5930(1)

CD5926(1)

CD5923(1)

CRE4530(1)

CRE4790(1)

DD211332(1)

DD211291(1)

DAYDMA2R(1)

DAYDDPPMAK2(1)

DD211333(1)

DD211334(1)

DD550013(1)

DD2867(1)

DD211335(1)

CTU7890(1)

CTP5370(1)

CTP2569(1)

CTP2219(1)

CTP1304(1)

CTP4128(1)

CTP4187(1)

CTP4699(1)

CTP4696(1)

CTP4330(1)

CD414074(1)

CD414073(1)

CD114109(1)

CD114070(1)

CD114069(1)

CD114060(1)

CD114201(1)

CD140050(1)

CD140305(1)

CD140052(1)

CD140051(1)

CD114059(1)

CD114047(1)

CD110105(1)

CD104463(1)

CD104458(1)

CD110106(1)

CD110185(1)

CD114040(1)

CD114014(1)

CD110199(1)

CD140306(1)

CD140307(1)

CD414062(1)

CD414060(1)

CD410086(1)

CD414063(1)

CD414068(1)

CD414072(1)

CD414071(1)

CD414069(1)

CD410066(1)

CD410041(1)

CD1949(1)

CD1915(1)

CD140308(1)

CD404152(1)

CD404153(1)

CD410020(1)

CD410018(1)

CD410010(1)

EI2929(1)

EI3220(1)

MCP173(1)

MCP169(1)

MCP141(1)

MCP140(1)

MCP174(1)

MCP202(1)

MCV1617(1)

MCP205(1)

MCP204(1)

MCP137(1)

MCP136(1)

LRN2350(1)

LER8898(1)

LER8441(1)

LRN2351(1)

MCB062(1)

MCP130(1)

MCP122(1)

MCP117(1)

MCV1627(1)

MCV1629(1)

NL1992(1)

NL1980(1)

NL0523(1)

NP231001(1)

NP232001(1)

NP235001(1)

NP234001(1)

NP233001(1)

MCV1677(1)

MCV1675(1)

MCV1645(1)

MCV1642(1)

MCV1638(1)

MCV1650(1)

MCV1662(1)

MCV1674(1)

MCV1673(1)

MCV1664(1)

LER7478(1)

LER7410(1)

EP3440(1)

EP3397(1)

EP3396(1)

ELP550245(1)

EP3443(1)

EPLRN2348(1)

EU847061(1)

ESPSG01(1)

EPLRN2349(1)

ELP550217(1)

EI8899(1)

EI3415(1)

EI3408(1)

EI3222(1)

EI8446(1)

EI8476(1)

EI8493(1)

EI8490(1)

EI8477(1)

EU847423(1)

EU847641(1)

LER3039(1)

LER3038(1)

LER0935(1)

LER5057(1)

LER5060(1)

LER7346(1)

LER6965(1)

LER5061(1)

LER0383(1)

LER0047(1)

HE9781432949365(1)

HE9781432949136(1)

HC0064431231(1)

HOSET12(1)

HVA581(1)

KE840006(1)

JAX8012(1)

HVA681(1)

BCPLL1049SCH(1)

Price Range

$0-$99.99(331)

$200-$299.99(1)

$400-$499.99(1)

To  GO

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

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