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(7)

Construction Paper(7)

Pressboard Classification Folders(5)

Art Paper Rolls and Sheets(3)

Hanging Pockets(3)

Kraft Paper(3)

Colored Pencils(3)

Craft Kits(2)

Memo / Subject Notebooks(2)

Glass Cleaners(2)

Desktop Staplers(2)

Mechanical Pencils(1)

Color Hanging Folders(1)

Letter, Legal & Jr. Pads(1)

Interior Folders(1)

Felt-tip/Porous Point Pens(1)

Bulletin Board Borders(1)

Air Respiratory Pumps(1)

Wood Pencils(1)

DLT Data Cartridges(1)

Air Purifier/Humidifier Filters(1)

Tissue Paper(1)

Rollerball Pens(1)

 
Brand

Blue Sky(77)

Febreze(6)

Smead(5)

Acco(4)

Crayola(4)

Smart-Fab(3)

Tru-Ray(3)

Pacon(2)

SunWorks(2)

Zebra Pen(2)

Swingline(2)

Nature Saver(2)

Method(2)

Sakura of America(1)

Renuzit(1)

Sparmax(1)

Pendaflex(1)

TOPS(1)

Rainbow(1)

Decorol(1)

Spectra Art Tissue(1)

Dial(1)

Fadeless(1)

HPE(1)

Spectra ArtKraft(1)

 
Color

Multi(35)

Sky Blue(28)

Black(13)

Multicolor(13)

Gold(10)

Blue(8)

Floral(7)

White(6)

Red(4)

Teal(4)

Light Blue(4)

Navy(4)

Orange(3)

Yellow(3)

Dark Blue(2)

Cream(2)

Clear Blue(2)

Assorted(2)

Cranberry(2)

Dark Purple(2)

Dark Pink(2)

Apple Green(2)

Brown(2)

Grass Green(2)

Mahogany(2)

Pink(1)

Gray(1)

Navy Blue(1)

Black/Sky Blue(1)

Green(1)

Orchid(1)

Purple(1)

Night Sky(1)

 
Size

Letter(7)

Legal(3)

Jr.Legal(1)

 
Recycled

Yes(78)

No(45)

 
Sheet Size

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

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

5" x 8"(1)

8" x 10"(1)

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

 
 
 

© 2019-2020 CPS Office Products, All Rights Reserved