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

Currently Filtered by

Manufacturer

HOUSE OF DOOLITTLE

Refine Search

  GO
Category Filter

Calendars(89)

Appointment Books(38)

Teacher's Lesson Planners(3)

Calendar Refills(2)

Desk Pads(2)

Boards(2)

Desk Pad Refills(1)

Brand

House of Doolittle(137)

Height

18"(1)

Width

22"(3)

Depth

17"(2)

18"(1)

Size

11 x 8 1/2(25)

22 x 17(24)

18 1/2 x 13(14)

24 x 37(9)

12 x 16 1/2(7)

10 x 7(5)

8 3/4 x 6 7/8(4)

12 x 12(4)

8 x 5(4)

12 x 17(3)

8 x 17(3)

15 1/2 x 22(3)

8 1/2 x 4 1/2(3)

12 1/4 x 26(2)

18 x 24(2)

32 x 48(2)

9 x 7(2)

3 1/2 x 6(2)

9 1/4 x 6 1/4(1)

22 x 18(1)

60 x 26(1)

66 x 33(1)

20 x 26(1)

17 x 8(1)

22 x 31 1/4(1)

14 7/8 x 12(1)

8 1/2 x 11(1)

15 x 12(1)

24 x 19(1)

23 1/2 x 12(1)

6 x 7(1)

7 x 4 1/4(1)

Refillable

Nonrefillable(125)

Refillable(3)

Yes(1)

Closure

Open Style(6)

None(1)

Base Color

Black(1)

Brown(1)

Paper Color(s)

White(3)

Color Family

Black(29)

Blue(6)

Multicolor(2)

Gray(1)

Brown(1)

Pink(1)

Special Features

Wirebound Soft Cover-Black, embossed leatherette finished soft cover.(4)

Regular Year-Regular calendar-year format features numbered weeks.(4)

Vertical Format(3)

Horizontal Format-Perfect for open plan systems.(2)

Perforated Sheets-Stitched at the top with a leatherette binding that matches the pad's reinforced corners.(2)

Refillable holder.(1)

Executive Series Hardcover-Durable wire bound hardcover can be archived for years.(1)

Academic Year(1)

One-Year Planner(1)

Refillable(1)

Deluxe Desk Pad-Padded header for an executive look.(1)

Two-Year Planner(1)

Nonrefillable-Compact size is great for workstations.(1)

Wirebound Soft Cover(1)

 
 
Searching for your Best Results.....
Loading...
 
AbilityOne Distributor

© 2019-2020 United Supply Corp, All Rights Reserved