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

Currently Filtered by

Category

Language Arts

Refine Search

  GO
 
Manufacturer Part Number

SV9780547898513(1)

SV99106(1)

SV9780547898506(1)

SV9780547898490(1)

SV9780547898483(1)

SV99113(1)

SV99687(1)

T23022(1)

T38026(1)

T23021(1)

T1095(1)

T1094(1)

SV9780547898476(1)

SV9780547898469(1)

SC9780545201100(1)

SC9780545239691(1)

SC9780545201032(1)

SC9780545144711(1)

SC9780545104357(1)

SEP10332(1)

SEP10333(1)

SV9780547898452(1)

SV34404(1)

SEP10335(1)

SEP10334(1)

T38027(1)

T38032(1)

T38131(1)

T38132(1)

T38130(1)

T38129(1)

T38128(1)

T38133(1)

T38134(1)

T38157(1)

T38158(1)

T38137(1)

T38136(1)

T38135(1)

T38127(1)

T38126(1)

T38037(1)

T38038(1)

T38035(1)

T38034(1)

T38033(1)

T38040(1)

T38042(1)

T38083(1)

T38082(1)

T38045(1)

T38044(1)

SC554447(1)

SC545951(1)

NL1996(1)

NL1997(1)

NL1994(1)

NL1990(1)

NL1981(1)

NST2506(1)

NST3021(1)

OTM2528(1)

OTM2529(1)

OTM2527(1)

NST3068(1)

NST3045(1)

NL1979(1)

MCV1672(1)

MCV1623(1)

MCV1639(1)

MCV1618(1)

MCV1616(1)

MCV1613(1)

MCV1640(1)

MCV1658(1)

MCV1671(1)

MCV1670(1)

MCV1666(1)

MCV1665(1)

OTM2530(1)

OTM2531(1)

SC043979420X(1)

SC530144(1)

SC0439784395(1)

SC0439517613(1)

SC0439323231(1)

SC537485(1)

SC537486(1)

SC543302(1)

SC540223(1)

SC540222(1)

SC537488(1)

SC0439303575(1)

SC0439153913(1)

PUB7640600(1)

PUB7661800(1)

PUB7639000(1)

PUB7267700(1)

PAT7251(1)

QS9781423217633(1)

R4960(1)

SC0439152917(1)

SC0439152852(1)

RL200(1)

REM6005A(1)

T38159(1)

T38160(1)

TCR7641(1)

TCR7642(1)

TCR7639(1)

TCR7635(1)

TCR7629(1)

TCR7688(1)

TCR7696(1)

TCR7715(1)

TCR7716(1)

TCR7705(1)

TCR7701(1)

TCR7700(1)

TCR5371(1)

TCR5333(1)

TCR3891(1)

TCR4058(1)

TCR3887(1)

TCR3886(1)

TCR3885(1)

TCR4404(1)

TCR4421(1)

TCR5298(1)

TCR4865(1)

TCR4785(1)

TCR4566(1)

TCR7719(1)

TCR7731(1)

TF8063(1)

TF8075(1)

TF7114(1)

TF3065(1)

TF2518(1)

TF8085(1)

TL10090(1)

WCA6298(1)

WCA6252(1)

TL10459(1)

TL10432(1)

TF2517(1)

TF2506(1)

TCR7806(1)

TCR7809(1)

TCR7805(1)

TCR7769(1)

TCR7737(1)

TCR7812(1)

TCR7828(1)

TF1614(1)

TF0439824168(1)

TCR7843(1)

TCR7842(1)

TCR3884(1)

TCR3883(1)

T38918(1)

T38932(1)

T38286(1)

T38285(1)

T38284(1)

T47084(1)

T47101(1)

T811(1)

T8139(1)

T8010(1)

T707(1)

T53020(1)

T38282(1)

T38281(1)

T38164(1)

T38165(1)

T38163(1)

T38162(1)

T38161(1)

T38167(1)

T38210(1)

T38280(1)

T38240(1)

T38238(1)

T38237(1)

T8149(1)

T8155(1)

T94304(1)

T94408(1)

T94219(1)

T94215(1)

T94160(1)

T94503(1)

TA63260(1)

TCR1935(1)

TAL803(1)

TA67366(1)

TA67365(1)

T94151(1)

T94145(1)

T8265(1)

T8364(1)

T8255(1)

T8218(1)

T8180(1)

T94117(1)

T94118(1)

T94139(1)

T94138(1)

T94127(1)

T94120(1)

MCV1602(1)

MCP210(1)

CD410082(1)

CD410085(1)

CD410081(1)

CD410070(1)

CD410064(1)

CD4340(1)

CD5940(1)

CD6257(1)

CD8718(1)

CD6121(1)

CD6116(1)

CD6068(1)

CD410060(1)

CD410057(1)

CD140312(1)

CD1787(1)

CD140311(1)

CD140310(1)

CD140309(1)

CD1947(1)

CD2030(1)

CD3473(1)

CD3429(1)

CD3283(1)

CD3259(1)

COR9781412959278(1)

CRE6002(1)

CTP5079(1)

CTP5676(1)

CTP4334(1)

CTP4333(1)

CTP4331(1)

CTP5677(1)

CTP5679(1)

DAYDEN2R(1)

DAYTDUSI154(1)

CTP6968(1)

CTP6966(1)

CTP6963(1)

CTP4180(1)

CTP4175(1)

CTP1158(1)

CTP2206(1)

CTP1009(1)

CRE6007(1)

CRE6006(1)

CTP2207(1)

CTP2220(1)

CTP4174(1)

CTP4171(1)

CTP3795(1)

CTP3794(1)

CD140090(1)

CD140089(1)

CD104456(1)

CD104457(1)

CD104449(1)

CD104050(1)

CD104049(1)

CD104459(1)

CD104464(1)

CD110037(1)

CD110103(1)

CD110014(1)

CD104466(1)

CD104465(1)

CCP7111(1)

CCP7109(1)

CCP7100(1)

CCP7101(1)

BOG00460(1)

BCPLL1022SCH(1)

BCP1899(1)

CCP7102(1)

CCP7104(1)

CCP7108(1)

CCP7107(1)

CCP7106(1)

CCP7105(1)

CD110121(1)

CD110124(1)

CD114090(1)

CD114094(1)

CD114089(1)

CD114067(1)

CD114065(1)

CD140053(1)

CD140054(1)

CD140088(1)

CD140087(1)

CD140086(1)

CD140055(1)

CD114064(1)

CD114063(1)

CD110183(1)

CD110184(1)

CD110160(1)

CD110139(1)

CD110126(1)

CD114037(1)

CD114043(1)

CD114058(1)

CD114049(1)

CD114048(1)

CD114044(1)

DD19501(1)

DD195115(1)

LER6305(1)

LER6964(1)

LER3773(1)

LER3772(1)

LER1183(1)

LER7063(1)

LER7180(1)

LER8470(1)

LER8471(1)

LER8431(1)

LER8430(1)

LER7345(1)

LER0394(1)

LER0344(1)

KE846032(1)

KE846033(1)

KE846005(1)

KE846004(1)

KE842001(1)

KE846037(1)

KE846048(1)

KOP17636(1)

KOP12985(1)

KID10364(1)

KID10363(1)

LRN1012(1)

LRN1021(1)

MCK1154(1)

MCP081(1)

MCK1151(1)

LRN902(1)

LRN602(1)

MCP118(1)

MCP162(1)

MCP193(1)

MCP192(1)

MCP191(1)

MCP177(1)

LRN402(1)

LRN351(1)

LRN1051(1)

LRN1052(1)

LRN1042(1)

LRN1041(1)

LRN1022(1)

LRN1062(1)

LRN1081(1)

LRN302(1)

LRN301(1)

LRN2022(1)

LRN2012(1)

KE840016(1)

KE840009(1)

EP2425(1)

EP2426(1)

EP2282(1)

EI2937(1)

EI2922(1)

EP2594(1)

EP2597(1)

EP3465(1)

EP3467(1)

EP3464(1)

EP3463(1)

EP3462(1)

EI2865(1)

EI2845(1)

DD212005(1)

DD212006(1)

DD211426(1)

DD211425(1)

DD195181(1)

DD212007(1)

DD212008(1)

EI1733(1)

DD504067(1)

DD2613(1)

DD2607(1)

EP3469(1)

EP3617(1)

HVA676(1)

HVA677(1)

HVA585(1)

HVA577(1)

HVA576(1)

HVA685(1)

HVA807(1)

KE840008(1)

JAX8011(1)

IP1505(1)

ID99067(1)

HHS702R(1)

HHS701R(1)

EPLRN1010(1)

EPLRN1040(1)

EP3758(1)

EP3757(1)

EP3618(1)

EPLRN1050(1)

EU837464(1)

EU847744(1)

EU847675(1)

EU847648(1)

EU847642(1)

ALE1474(1)

 
 
 

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