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

Currently Filtered by

Category

Calendars

Refine Search

  GO
 
Brand

Rediform(4)

Unicor(2)

House of Doolittle(2)

Blue Sky(2)

 
Color

Multi(2)

Floral(2)

Wedgewood Blue(1)

Blue(1)

 
Size

18 x 22(1)

9 x 11(1)

 
Recycled

Yes(7)

No(1)

 
Packaged Quantity

1 Each(8)

 
Date Format

Monthly(8)

Yearly(1)

 
Sheet Height

17"(2)

12"(1)

24"(1)

6"(1)

 
Start Month

January(7)

July(2)

 
End Month

December(7)

June(2)

 
Start Year

2020(6)

2019(1)

 
End Year

2020(6)

2021(1)

 
Single Page Layout

1 Month(4)

 
Planner/Diary Type

Academic(1)

 
Manufacturer Part Number

C194115(1)

C194116(1)

6649501(1)

6649510(1)

C194113(1)

C173122(1)

105496(1)

330(1)

3964(1)

102487(1)

 
Country of Origin

Mexico(4)

US(2)

United States(2)

China(1)

 
Material

Paper(3)

Fiber(1)

Metal(1)

 
Height

0.1"(1)

 
Width

22"(1)

36"(1)

 
Placement

Wall Mountable(5)

Desk Pad(4)

Desktop(1)

 
Binding Type

Top-Bound(1)

Twin Wire(1)

Wire Bound(1)

 
Sheet Width

22"(2)

17"(1)

37"(1)

7"(1)

 
Time Period

1 Year(6)

2 Year(1)

 
Dated/Undated

Dated(2)

 
Page Format

One Month(2)

 
Calendar Term

13-Month (Jan.-Jan.)(1)

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

 
Calendar Format

Monthly(2)

 
Page Color/Theme

White(2)

 
Edition Year

2020(2)

 
Julian Dates

Yes(9)

 
Hanger Style

None(2)

 
 
 

© 2019-2020 CPS Office Products, All Rights Reserved