0

 

Total:$0.00

QUICK VIEW 0
 

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

Currently Filtered by

Keyword

Calendar

Refine Search

  GO
 
Category

Appointment Books & Planners(303)

Wall Calendars(111)

Calendar Desk Pads(96)

Calendars(90)

Wall Planners & Organizers(63)

Organizer Refills(43)

Appointment Books(35)

Time Management Organizers(30)

Appointment Book Refills(22)

Desk Calendar Refills(19)

Bulletin Board Sets(15)

Business Diaries(11)

Laminating Supplies(11)

Printing Calculators(10)

Boards(8)

Desk Calendars(8)

Desk Calendar Bases(7)

Microphones(6)

Magnetic Shapes(5)

Teaching Calendars & Planners(4)

Pocket Charts(4)

Classroom Decorations(4)

Charts(3)

Wall Calendar Refills(3)

Magnetic Letters & Numbers(3)

Calendar Desk Pad Refills(3)

Dry-Erase Boards(3)

Telephone / Address Books(3)

Ledgers/Journals(2)

Time Management Organizer Accessories(2)

Calendar Refills(2)

Calendar Bases(2)

Hooks & Hangers(2)

Creative Learning(1)

Magnetic Clips(1)

Memo / Subject Notebooks(1)

Loose Leaf Address Book Refills(1)

File Jackets/Sleeves/Wallets(1)

Clamps(1)

Letters, Numbers & Symbols(1)

Desktop Organizers(1)

Desk Clocks(1)

Craft Kits(1)

Storage Boxes & Containers(1)

 
Brand

At-A-Glance(364)

House of Doolittle(150)

Blue Sky(88)

AT-A-GLANCE(61)

Day-Timer(49)

Blueline(19)

Quartet(18)

Brownline(18)

SKILCRAFT(15)

Franklin Covey(14)

MasterVision(12)

Scotch(11)

Ashley(11)

Teacher Created Resources(10)

Carson-Dellosa(9)

Creative Teaching Press(8)

Day Runner(8)

TF Publishing(8)

Canon(7)

FranklinCovey(7)

Rediform(5)

Scholastic(5)

TOPS(5)

Unicor(4)

TREND(4)

AbilityOne(3)

AmpliVox(3)

Ward(3)

Wilson Jones(2)

Philips(2)

Pacon(2)

Trend(2)

Sharp Calculators(2)

Learning Resources(2)

Lorell(2)

OIC(2)

AT-A-GLANCE Day Runner(2)

Adams(1)

Ampad(1)

Avery(1)

DayMinder(1)

Universal(1)

AT-A-GLANCE DayMinder(1)

Victor(1)

Advantus(1)

Baumgartens(1)

Kenwood(1)

Filofax(1)

Classroom Keepers(1)

Roaring Spring(1)

Flipside(1)

Dome(1)

Pendaflex(1)

Mead(1)

 
Color

White(145)

Black(126)

Assorted(75)

Blue(64)

Multicolor(48)

Multi(48)

Gray(32)

Red(15)

Green(15)

Clear(14)

Graphite(11)

Pink(11)

Silver(8)

Burgundy(5)

Cream(4)

Aluminum(4)

Brown(4)

Navy(4)

Yellow(3)

Black/White(3)

Navy Blue(3)

Rose(3)

Teal(3)

Floral(2)

Light Blue(2)

Dark Green(2)

Tan(2)

Charcoal Gray(2)

Olive Green(2)

Heather(2)

Lime(1)

Purple(1)

Black Base(1)

Blue/Gray(1)

Orchid(1)

Buff(1)

Copper(1)

Wine(1)

Charcoal(1)

Rust(1)

Beige(1)

Eggplant(1)

Sliver(1)

Dark Tan(1)

 
Size

22 x 17(18)

8 1/2 x 11(10)

12 x 17(9)

36 x 24(7)

12 x 12(7)

5 1/2 x 8 1/2(6)

18 1/2 x 13(5)

5 1/2 x 5 1/2(5)

9 x 11(4)

11 x 8 1/2(4)

3 1/4 x 6 1/4(3)

3 3/4 x 6 3/4(3)

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

3 1/2 x 6 1/2(2)

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

21 3/4 x 17(2)

17 3/4 x 10 7/8(2)

6 1/8 x 5 1/4(2)

15 x 12(2)

12 x 11(2)

7 x 7(2)

12 x 16 1/2(2)

8 1/4 x 10 7/8(2)

6 x 9(2)

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

15 1/2 x 22(1)

7 x 4 1/4(1)

20 x 26(1)

21 1/4 x 16(1)

17 x 12(1)

9 1/2 x 7 1/2(1)

8 x 11(1)

Letter(1)

8 x 10(1)

8 1/2 x 10 7/8(1)

6 5/8 x 8 3/4(1)

6 7/8 x 8(1)

4 3/4 x 8(1)

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

8 x 4 7/8(1)

4 7/8 x 8(1)

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

5 5/8 x 9(1)

8 x 9 7/8(1)

8 3/8 x 11(1)

3 1/2 x 6(1)

24 x 36(1)

14 7/8 x 11 7/8(1)

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

17 x 10 7/8(1)

9 x 24(1)

15 1/2 x 22 3/4(1)

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

 
Binder Capacity

1"(3)

 
Size

Letter(2)

Statement(1)

 
Recycled

Yes(541)

No(193)

 
Sheet Size

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

7 1/4" x 9 1/2"(1)

9" x 11"(1)

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

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

3 3/4" Width x 6 3/4" Length(1)

3 3/4" x 6 3/4"(1)

8 1/2" x 11"(1)

 
 
 

© 2018-2019 Regal Office Supplies, All Rights Reserved