0

Banner1
 
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_4` 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_1` LIKE 'Office Supplies') AND (`category_2` LIKE 'Calendars & Planners') AND (`category_3` LIKE 'Calendars & Refills') AND `pinfo`.`is_recycled` LIKE 'Y' 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_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 '%Calendars Refills' THEN 1 ELSE 0 END DESC, CASE WHEN MATCH(`desc_short`) AGAINST ('Calendars +Refills' IN BOOLEAN MODE) THEN 1 ELSE 0 END DESC, CASE WHEN `pinfo`.`vendor`=2 THEN IF(MATCH(`desc_long`, `manufacturer_name`, `color`) AGAINST ('+Calendars +Refills' IN BOOLEAN MODE),4,0) ELSE CASE WHEN MATCH (`keywords`) AGAINST ('"Calendars Refills"' IN BOOLEAN MODE) AND MATCH (`desc_title`) AGAINST ('"Calendars Refills"' IN BOOLEAN MODE) THEN 4 ELSE IF(MATCH (`desc_title`) AGAINST ('"Calendars Refills"' IN BOOLEAN MODE),3,IF(MATCH (`keywords`) AGAINST ('"Calendars Refills"' IN BOOLEAN MODE),2,IF(MATCH(`desc_title`, `manufacturer_name`, `color`) AGAINST ('+Calendars +Refills' IN BOOLEAN MODE),1,0))) END END DESC,CASE WHEN IF(`pinfo`.`vendor`=2,`category_3` ='Refills',`category_4` ='Refills') THEN 1 ELSE 0 END DESC, CASE WHEN `desc_short` LIKE 'Refills,%' THEN 1 ELSE 0 END DESC, SUBSTR(`pinfo`.`desc_title`, 1, LOCATE('Refills', `pinfo`.`desc_title`)) DESC

Currently Filtered by

Category

Calendars Refills

Refine Search

  GO
 
Brand

House of Doolittle(86)

At-A-Glance(21)

Blue Sky(19)

Brownline(16)

Blueline(4)

Rediform(3)

Dome(1)

Day-Timer(1)

 
Color

Black(23)

Blue(19)

White(19)

Assorted(10)

Multi(8)

Multicolor(8)

Gray(8)

Green(6)

Floral(2)

Gold(2)

Pink(2)

Black/White(2)

Red(2)

Navy(1)

Tan(1)

Orchid(1)

Sea Blue(1)

Cream(1)

Teal(1)

Blue/Gray(1)

 
Size

21 1/4 x 16(1)

 
Binder Capacity

1"(1)

 
Recycled

Yes(146)

No(4)

 
Packaged Quantity

1 Each(145)

1 / Each(5)

 
Weight (Approximate)

6 oz(1)

9.76 oz(1)

13.44 oz(1)

1.92 lb(1)

13.92 oz(1)

3.68 oz(1)

1 lb(1)

5.60 oz(1)

15.84 oz(1)

4.80 oz(1)

14.88 oz(1)

8 oz(1)

14.08 oz(1)

13.30 oz(1)

10.56 oz(1)

 
Special Features

Academic Year(1)

 
Recycled Content

50%(1)

 
Date Format

Monthly(117)

Weekly(42)

Daily(37)

Yearly(8)

 
Sheet Color

White(3)

Blue(1)

White/Blue(1)

 
Sheet Height

11"(33)

17"(22)

8"(10)

8 1/2"(9)

8 3/4"(7)

22"(6)

13"(6)

10 7/8"(4)

10"(4)

12"(3)

16 1/2"(3)

6"(2)

24"(2)

27"(2)

26"(2)

8 7/8"(1)

23 1/2"(1)

3 3/4"(1)

31 1/4"(1)

19"(1)

22 3/4"(1)

17 1/8"(1)

5"(1)

 
Start Month

January(106)

December(18)

July(17)

August(2)

June(1)

 
End Month

December(100)

January(24)

June(8)

August(7)

July(5)

 
Cover Color

Black(29)

Blue(6)

Assorted(1)

Green(1)

Black Suede(1)

 
Start Year

2020(103)

2019(18)

2021(1)

 
End Year

2020(80)

2021(41)

 
Double Page Layout

1 Month(30)

1 Week(22)

1 Day(5)

2 Month(1)

 
Single Page Layout

1 Month(53)

3 Month(8)

1 Day(7)

1 Week(3)

2 Month(1)

 
Planner/Diary Type

Academic(11)

Professional(1)

 
Enclosure

Elastic(1)

Chipboard(1)

 
Manufacturer Part Number

122200(1)

327(1)

289632(1)

294-02(1)

294632(1)

296-02(1)

29799(1)

303(1)

328(1)

28302(1)

331HD(1)

332(1)

334(1)

337(1)

3395(1)

342(1)

343(1)

28802(1)

28202(1)

3636(1)

26309(1)

26202(1)

26207(1)

262602(1)

26302(1)

26305(1)

26308(1)

26402(1)

27902(1)

264632(1)

265-02(1)

268-02(1)

272002(1)

27202(1)

272-07(1)

278-02(1)

362(1)

3638(1)

260602(1)

CB1200VBLK(1)

C2917001(1)

C2917311(1)

CA177227(1)

CA181721(1)

CA181731(1)

CA201BLK(1)

CB1262C.BLK(1)

C181700(1)

CB1262V.BLK(1)

CB435W.BLK(1)

CB634C-RED(1)

CB634VBLK(1)

CB800BLK(1)

CB950.BLK(1)

CB950C.BLK(1)

C181721(1)

C171102(1)

3640(1)

393(1)

3645(1)

3646(1)

3648(1)

3731(1)

3732(1)

378(1)

3974(1)

C171101(1)

417(1)

4717(1)

50907(1)

78097(1)

33995(1)

A30C.81(1)

B4481(1)

262002(1)

26002(1)

122905(1)

101613(1)

100001(1)

100004(1)

100009(1)

100079(1)

100087(1)

101555(1)

101633(1)

SK32G-00(1)

101707(1)

101711(1)

101714(1)

101716(1)

101718(1)

101971(1)

102132(1)

W6099707(1)

PMG77-28(1)

102411(1)

70120X05(1)

182905(1)

551200(1)

551905(1)

70-100G-05(1)

70100X05(1)

70-120G-05(1)

7021279(1)

PM3G28(1)

70-260G-05(1)

70-260G-60(1)

70950E05(1)

70-950G-05(1)

70-950G-60(1)

D6099704(1)

PM11X28(1)

102142(1)

107924(1)

239508(1)

176(1)

1596(1)

164(1)

1646(1)

172(1)

174(1)

175(1)

178(1)

150HD(1)

180-HD(1)

187(1)

1876(1)

1886(1)

193(1)

199(1)

2171-02(1)

155(1)

1506(1)

107925(1)

12440(1)

40977(1)

41745(1)

0124(1)

012540(1)

122(1)

124(1)

124-43(1)

148(1)

12473(1)

12502(1)

136(1)

1395(1)

140HD(1)

1466(1)

1467(1)

CB950VBLK(1)

 
Country of Origin

United States(103)

China(24)

Canada(11)

Mexico(10)

Taiwan(1)

Brazil(1)

CN(1)

 
Material

Paper(53)

Simulated Leather(26)

Leatherette(24)

Chipboard(9)

Poly(7)

Vinyl(6)

Leather(5)

Wood(1)

 
Height

17"(5)

11"(3)

12"(3)

13"(2)

8.5"(1)

11.4"(1)

8.4"(1)

9.1"(1)

11.3"(1)

27.1"(1)

16.5"(1)

26"(1)

8"(1)

7"(1)

10.9"(1)

 
Width

22"(4)

12"(3)

8.5"(3)

18.5"(2)

5.4"(1)

9.3"(1)

5.8"(1)

7.5"(1)

9.8"(1)

16.5"(1)

8"(1)

12.3"(1)

17"(1)

23.5"(1)

9"(1)

17.8"(1)

 
Depth

0.5"(1)

0.3"(1)

0.8"(1)

 
Sheet Size

5 1/2" Width x 8 1/2" Length(1)

 
Refillable

Nonrefillable(1)

 
Placement

Desk Pad(40)

Wall Mountable(38)

Desktop(11)

 
Fastener Type

Ring(1)

 
Number of Fasteners

7(1)

 
Binding Type

Wire Bound(57)

Twin Wire(19)

Spiral Bound(2)

Headband(2)

3-ring(2)

Gummed(1)

Sewn(1)

Glued(1)

 
Sheet Width

8 1/2"(28)

22"(19)

11"(12)

12"(8)

5"(6)

18 1/2"(6)

8"(5)

6 7/8"(4)

17"(4)

7"(3)

4 7/8"(3)

15 1/2"(3)

12 1/4"(2)

8 3/4"(2)

15"(2)

3 1/2"(2)

8 1/4"(2)

9"(2)

17 3/4"(1)

60"(1)

37"(1)

10"(1)

20"(1)

24"(1)

36"(1)

22 1/5"(1)

5 1/2"(1)

7 1/8"(1)

 
Time Period

1 Year(87)

1.2 Year(23)

1.1 Year(7)

2 Year(2)

9 Month(1)

 
Number of Holes Punched

2(1)

3(1)

 
Dated/Undated

Dated(1)

 
Page Format

One Month per Page(1)

 
Calendar Term

13-Month (July-July)(1)

 
Calendar Format

Monthly(1)

 
Academic Year

Yes(1)

 
Page Color/Theme

White/Blue/Green(1)

 
Edition Year

2016-2017(1)

 
Seasonal Availability

No(1)

 
Julian Dates

Yes(128)

 
Calendar Reference Blocks

Full Year(1)

 
Sheet Quantity

12(6)

120(1)

14(1)

30(1)

6(1)

56(1)

192(1)

80(1)

 
Binding Color(s)

Black(1)

 
Corner Color(s)

Black(1)

 
 
 

© 2020-2021 CPS Office Products, All Rights Reserved