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 ('60187')) AND `pinfo`.`status` IN ('active','discontinued','out_of_stock','spl_call_for_price') 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 '%ReferenceBooks' THEN 1 ELSE 0 END DESC, CASE WHEN MATCH(`desc_short`) AGAINST ('ReferenceBooks' IN BOOLEAN MODE) THEN 1 ELSE 0 END DESC, CASE WHEN `pinfo`.`vendor`=2 THEN IF(MATCH(`desc_long`, `manufacturer_name`, `color`) AGAINST ('+ReferenceBooks' IN BOOLEAN MODE),4,0) ELSE CASE WHEN MATCH (`keywords`) AGAINST ('"ReferenceBooks"' IN BOOLEAN MODE) AND MATCH (`desc_title`) AGAINST ('"ReferenceBooks"' IN BOOLEAN MODE) THEN 4 ELSE IF(MATCH (`desc_title`) AGAINST ('"ReferenceBooks"' IN BOOLEAN MODE),3,IF(MATCH (`keywords`) AGAINST ('"ReferenceBooks"' IN BOOLEAN MODE),2,IF(MATCH(`desc_title`, `manufacturer_name`, `color`) AGAINST ('+ReferenceBooks' IN BOOLEAN MODE),1,0))) END END DESC,CASE WHEN IF(`pinfo`.`vendor`=2,`category_3` ='ReferenceBooks',`category_4` ='ReferenceBooks') THEN 1 ELSE 0 END DESC, CASE WHEN `desc_short` LIKE 'ReferenceBooks,%' THEN 1 ELSE 0 END DESC, SUBSTR(`pinfo`.`desc_title`, 1, LOCATE('ReferenceBooks', `pinfo`.`desc_title`)) DESC
<
GO
Currently Filtered by
Category
Reference Books
Refine Search
GO
Brand
Merriam Webster(9)
Carson-Dellosa Education(4)
Dome(1)
Country of Origin
US(10)
CN(4)
Height
7"(2)
6.75"(2)
7.88"(1)
1"(1)
9.5"(1)
9.88"(1)
6.88"(1)
9.25"(1)
Width
7.25"(3)
4.25"(2)
0.13"(1)
4.13"(1)
6.13"(1)
4.19"(1)
4.14"(1)
Depth
1.25"(2)
1"(1)
1.75"(1)
6.75"(1)
4.25"(1)
Number of Pages
191 Pages(1)
225 Pages(1)
229 Pages(1)
236 Pages(1)
750 Pages(1)
832(1)
1,152 Pages(1)
960 Pages(1)
928(1)
1,024 Pages(1)
1,664 Pages(1)
800 Pages(1)
768 Pages(1)
Binding
Paperback(6)
Hardcover(2)
Glue Top(1)
Age Recommendation
Ages 5-8(2)
Ages 6-8(1)
Ages 7-9(1)
Ages 11 and Up(1)
Ages 12 and Up(1)
10 and Up(1)
Ages 6 and Up(1)
Subjects
Language Arts(4)
Science(2)
Math(2)
Zip Codes(1)
Reference Book Type
Dictionary(5)
e-Books(4)
Thesaurus(2)
Zip Code Directory(1)
Everyday Language Reference Set(1)
Dictionary/Thesaurus(1)
Edition
Revised Edition(1)
Revised(1)
Filtered By Sort by
Current Page 1 of 1
Result Per Page