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

Currently Filtered by

Category

Classroom Theme

Refine Search

  GO
 
Manufacturer Part Number

T8220(1)

T8219(1)

T8247(1)

T8277(1)

T8284(1)

T8281(1)

T8212(1)

T8211(1)

T8086(1)

T8076(1)

T8176(1)

T8189(1)

T8202(1)

T8201(1)

T8298(1)

T8311(1)

T8707(1)

T8361(1)

T8710(1)

T8715(1)

T8720(1)

T8716(1)

T8360(1)

T8350(1)

T8313(1)

T8312(1)

T8314(1)

T8315(1)

T8330(1)

T38970(1)

T38964(1)

T38426(1)

T38425(1)

T38427(1)

T38428(1)

T38431(1)

T38430(1)

T38412(1)

T38411(1)

T38264(1)

T38263(1)

T38334(1)

T38400(1)

T38410(1)

T38440(1)

T38441(1)

T38471(1)

T38470(1)

T38472(1)

T38473(1)

T38960(1)

T38959(1)

T38454(1)

T38453(1)

T38448(1)

T38447(1)

T38449(1)

T38450(1)

T38451(1)

T8735(1)

T8736(1)

TF2514(1)

TF2512(1)

TF3097(1)

TF3109(1)

TF3140(1)

TF3115(1)

TF2502(1)

TF2391(1)

TCR9683(1)

TCR7746(1)

TF0439824222(1)

TF2102(1)

TF2165(1)

TF8001(1)

TF8023(1)

TF8406(1)

TF8405(1)

TF8414(1)

TF8415(1)

TF8425(1)

TF8416(1)

TF8403(1)

TF8400(1)

TF8086(1)

TF8042(1)

TF8087(1)

TF8090(1)

TF8094(1)

TCR7725(1)

TCR7711(1)

TCR4399(1)

TCR4398(1)

TCR4546(1)

TCR4776(1)

TCR4826(1)

TCR4784(1)

TCR4299(1)

TCR1856(1)

T8746(1)

T8738(1)

T8765(1)

T90808(1)

TCR1793(1)

TCR4866(1)

TCR5144(1)

TCR7687(1)

TCR7683(1)

TCR7699(1)

TCR7708(1)

TCR7710(1)

TCR7709(1)

TCR7677(1)

TCR7676(1)

TCR5220(1)

TCR5145(1)

TCR5221(1)

TCR5330(1)

TCR5335(1)

T38228(1)

SC553079(1)

CD110236(1)

CD110235(1)

CD114184(1)

CD114186(1)

CD114189(1)

CD114187(1)

CD110233(1)

CD110232(1)

CD110222(1)

CD110217(1)

CD110224(1)

CD110225(1)

CD110227(1)

CD114190(1)

CD114192(1)

CTP0962(1)

CD3200(1)

CTP0975(1)

CTP0976(1)

CTP1418(1)

CTP0979(1)

CD144200(1)

CD144196(1)

CD114196(1)

CD114194(1)

CD114198(1)

CD114199(1)

CD114200(1)

CD110207(1)

CD110202(1)

CD110138(1)

CD110137(1)

CD110142(1)

CD110143(1)

CD110146(1)

CD110145(1)

CD110134(1)

CD110133(1)

BCPLL849CH(1)

BCPLL848CH(1)

CD110046(1)

CD110099(1)

CD110127(1)

CD110148(1)

CD110149(1)

CD110169(1)

CD110167(1)

CD110173(1)

CD110175(1)

CD110193(1)

CD110192(1)

CD110163(1)

CD110161(1)

CD110153(1)

CD110152(1)

CD110154(1)

CD110158(1)

CD110159(1)

CTP2128(1)

CTP4341(1)

EU847678(1)

EU847677(1)

EU847681(1)

EU847683(1)

EU847697(1)

EU847691(1)

EU847676(1)

EU847662(1)

EU847629(1)

EU847628(1)

EU847637(1)

EU847638(1)

EU847639(1)

EU847698(1)

EU847699(1)

SC541741(1)

SC541738(1)

SC541747(1)

SC542525(1)

SC553072(1)

SC553068(1)

SC541736(1)

SC0439513820(1)

LFV22707(1)

LAS1028SCH(1)

NST3004(1)

NST3027(1)

NST3035(1)

EU847611(1)

EU847601(1)

DJ610029(1)

DJ610028(1)

DJ610033(1)

DJ610039(1)

DJ610049(1)

DJ610040(1)

DJ610025(1)

DJ610023(1)

CTP6425(1)

CTP4711(1)

CTP6995(1)

CTP6998(1)

DJ610010(1)

DJ610050(1)

EP2194(1)

EU837530(1)

EU837520(1)

EU847005(1)

EU847041(1)

EU847131(1)

EU847081(1)

EU837465(1)

EP3648(1)

EP2294(1)

EP2290(1)

EP2295(1)

EP3599(1)

EP3647(1)

BCPLL830CH(1)

 
 
 

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