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

Currently Filtered by

Category

Personal Organizer Binders

Refine Search

  GO
 
Brand

FranklinCovey(2)

 
Size

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

8 x 10(1)

 
Refillable

Refillable(2)

 
Closure

Secure Magnetic Snap Closure(1)

Zipper(1)

 
Manufacturer Part Number

PC1017(1)

PC1022(1)

PC1412(1)

PC2603(1)

MEA48112(1)

764345(1)

CD704971(1)

CD704972(1)

CD704973(1)

33963(1)

CD704970(1)

 
Country of Origin

CN(2)

 
Cover Material(s)

Leather Like Vinyl(1)

Nappa Leather(1)

 
Binding Type

7-Ring(2)

 
Cover Color(s)

Black(2)

 
Dated/Undated

Undated(2)

 
Page Format

Single(1)

One Week per Two-Page Spread;One Month per Two Page Spread;Three Months of Weekly Planning(1)

 
Page Color/Theme

White/Blue(1)

 
Calendar Term

12-Month (Jan.-Dec.)(1)

 
Edition Year

2016(1)

 
Seasonal Availability

No(1)

 
Julian Dates

No(1)

 
Calendar Reference Blocks

12-Month Calendar Period(1)

 
Appointment Ruling

Hourly, 8 AM to 8 PM (Sun.-Sat.)(1)

Open Scheduling(1)

 
Separate Sections

Notes;Tabbed Personal Management;Tabbed Telephone/Address(1)

 
Calendar Format

Monthly(1)

Weekly/Month(1)

 
Academic Year

No(1)

 
Pocket(s)

Business Card; Credit Card; Notepad; Zipper Pouch;Photo Holder(1)

 
Refill Type

Calendar Planning Pages, Lined Notes, Things To Do, Address/Telephone, Weekly Planning Pages(1)

 
 
 

© 2018-2019 Office Solutions & Innovations, Inc., All Rights Reserved