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

Currently Filtered by

Keyword

Blue Sky

Refine Search

  GO
 
Category

Appointment Books & Planners(34)

Wall Calendars(23)

Calendar Desk Pads(18)

Air Fresheners/Sanitizers(8)

Construction Paper(6)

Pressboard Classification Folders(5)

Reception, Side & Guest Chairs(4)

Colored Pencils(3)

Stools & Drafting Chairs(3)

Hanging Pockets(3)

Kraft Paper(3)

Craft Kits(2)

Memo / Subject Notebooks(2)

Glass Cleaners(2)

Desktop Staplers(2)

Art Paper Rolls and Sheets(2)

Felt-tip/Porous Point Pens(1)

Letter, Legal & Jr. Pads(1)

Color Hanging Folders(1)

Bulletin Board Borders(1)

Interior Folders(1)

Rollerball Pens(1)

Wood Pencils(1)

Tissue Paper(1)

Air Respiratory Pumps(1)

Task Chairs(1)

Mechanical Pencils(1)

 
Brand

Blue Sky(77)

KFI(8)

Febreze(6)

Smead(5)

Acco(4)

Crayola(4)

Tru-Ray(3)

Smart-Fab(3)

Swingline(2)

SunWorks(2)

Pacon(2)

Zebra Pen(2)

Method(2)

Decorol(1)

Sparmax(1)

Rainbow(1)

Spectra ArtKraft(1)

Spectra Art Tissue(1)

Pendaflex(1)

Nature Saver(1)

Sakura of America(1)

Dial(1)

Renuzit(1)

TOPS(1)

 
Color

Multi(35)

Sky Blue(28)

Black(13)

Multicolor(13)

Gold(10)

Blue(9)

Floral(7)

White(6)

Red(4)

Teal(4)

Light Blue(4)

Navy(4)

Yellow(3)

Orange(3)

Cranberry(2)

Brown(2)

Dark Pink(2)

Apple Green(2)

Grass Green(2)

Dark Purple(2)

Dark Blue(2)

Cream(2)

Clear Blue(2)

Mahogany(2)

Assorted(2)

Navy Blue(1)

Pink(1)

Purple(1)

Green(1)

Gray(1)

Orchid(1)

 
Size

Letter(7)

Legal(3)

Jr.Legal(1)

 
Recycled

Yes(77)

No(53)

 
Sheet Size

8 1/2" Width x 11" Length(7)

8 1/2" Width x 14" Length(3)

8" x 10"(1)

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

5" x 8"(1)

 
 
 

© 2020-2021 CPS Office Products, All Rights Reserved