SELECT `pinfo`.`sku`,`pinfo`.`vendor`, 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_12` 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 ('381')) AND `pinfo`.`status` IN ('active','discontinued','out_of_stock') AND `pinfo`.`desc_title` != '' AND `online_status`=1 AND `custom_sku_enable`=1 AND CASE WHEN `pinfo`.`multi_level_cost`=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 ('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

Currently Filtered by

Category

Reference Books

Refine Search
  GO
Brand

Merriam Webster(12)

Scholastic(8)

Rand McNally(3)

Teacher Created Resources(2)

Dome(1)

Height

15 3/8"(3)

7"(2)

10 7/8"(1)

9 1/4"(1)

5.1"(1)

5.6"(1)

13 1/2"(1)

5"(1)

6 7/8"(1)

5.55"(1)

9 7/8"(1)

8.5"(1)

7 7/8"(1)

5 3/8"(1)

9 1/2"(1)

9.25"(1)

8 1/2"(1)

6"(1)

Width

7 1/4"(6)

10 7/8"(4)

11.1"(4)

4 1/4"(4)

4.19"(4)

11"(4)

9 1/2"(2)

11 1/2"(2)

8 1/2"(2)

3 1/2"(2)

4 1/8"(2)

6 1/8"(2)

5 3/4"(2)

6.5"(2)

Depth

1.5"(3)

1"(2)

12.4"(1)

13.7"(1)

8 1/2"(1)

13.4"(1)

3/4"(1)

0.88"(1)

4 1/4"(1)

0.38"(1)

13.6"(1)

Country of Origin

US(19)

CN(7)

Binding

Paperback(10)

Sewn(4)

Hardcover(3)

Perfect(1)

Softcover(1)

Spiral(1)

Stapled(1)

Age Recommendation

Grades Pre K-1(4)

Grades Pre K-2(3)

Ages 12 and Up(3)

Grades 1-2(1)

Grades 3-4(1)

Grade 5(1)

Grades 6-8(1)

Number of Pages

8 pages(5)

144 pages(3)

800(2)

768 pages(1)

928(1)

80 pages(1)

16 pages(1)

26 pages(1)

144(1)

1,664(1)

992(1)

960(1)

1,152(1)

416(1)

1,024 pages(1)

264(1)

750 pages(1)

Choking Hazard

No(7)

Reference Book Type

Dictionary(7)

Box Set(4)

Atlas(3)

Teacher's Guide(2)

Thesaurus(2)

Dictionary/Thesaurus(2)

Sing-Along Flip Chart(1)

Zip Code Directory(1)

Nursery Rhyme Readers(1)

Everyday Language Reference Set(1)

Social Studies(1)

Teacher's Lesson Guide(1)

Language(s)

English(22)

English; Spanish(2)

Edition

First Edition(4)

Revised and Updated Edition.(2)

2019(2)

First Edition.(1)

Eleventh Edition.(1)

2017 Edition.(1)

Subjects

Language Arts(7)

Reading(5)

Guided Reading(1)

Sing-Along(1)

Phonics; Reading(1)

Writing Traits(1)

Biographies(1)

Zip Codes(1)

Special Features

Animals(1)

Picture Books(1)

Easy-Read Biographies(1)

 
 
Searching for your Best Results.....
Loading...
 
AbilityOne Distributor HP Qualified Supplies Partner

© 2020-2021 United Supply Corp, All Rights Reserved

Powered by SITS Erp