SELECT `pinfo`.`sku`,`pinfo`.`vendor`, 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_12` 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 'sports drink' OR `desc_long` like 'sports drink' OR `desc_title` like 'sports drink' OR `keywords` like 'sports drink' OR `category_1` like 'sports drink' OR `category_2` like 'sports drink' OR `category_3` like 'sports drink' OR `category_4` like 'sports drink' OR `manufacturer_name` like 'sports drink' OR `color` like 'sports drink') OR (MATCH(`desc_short`, `desc_long`, `desc_title`, `keywords`, `category_1`, `category_2`, `category_3`, `category_4`, `manufacturer_name`, `color`) AGAINST('+(>sports>sports)+(>drink>drinks)' IN BOOLEAN MODE) or (`pinfo`.`sku` like '%sports drink%' OR `pinfo`.`sku` like '%sportsdrink%' OR (FIND_IN_SET('sports drink', REPLACE(`keywords`,' ;', ',')) OR FIND_IN_SET('sports drink', REPLACE(`keywords`,'; ', ',')) OR FIND_IN_SET('sports drink', REPLACE(`keywords`,';', ','))) ) OR (CASE WHEN `pinfo`.`vendor`=2 THEN `pinfo`.`desc_long` like 'sports drink' ELSE `pinfo`.`desc_title` like 'sports drink' END))) AND `pinfo`.`status` IN ('active','discontinued','out_of_stock') AND `pinfo`.`desc_title` != '' AND `online_status`=1 AND `custom_sku_enable`=1 AND CASE WHEN `pinfo`.`multi_level_cost`=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 MATCH(`desc_short`) AGAINST ('sports +drink' IN BOOLEAN MODE) THEN 1 ELSE 0 END DESC, CASE WHEN `pinfo`.`vendor`=2 THEN IF(MATCH(`desc_long`, `manufacturer_name`, `color`) AGAINST ('+sports +drink' IN BOOLEAN MODE),4,0) ELSE CASE WHEN MATCH (`keywords`) AGAINST ('"sports drink"' IN BOOLEAN MODE) AND MATCH (`desc_title`) AGAINST ('"sports drink"' IN BOOLEAN MODE) THEN 4 ELSE IF(MATCH (`desc_title`) AGAINST ('"sports drink"' IN BOOLEAN MODE),3,IF(MATCH (`keywords`) AGAINST ('"sports drink"' IN BOOLEAN MODE),2,IF(MATCH(`desc_title`, `manufacturer_name`, `color`) AGAINST ('+sports +drink' IN BOOLEAN MODE),1,0))) END END DESC,CASE WHEN IF(`pinfo`.`vendor`=2,`category_3` ='drink',`category_4` ='drink') THEN 1 ELSE 0 END DESC, CASE WHEN `desc_short` LIKE 'drink,%' THEN 1 ELSE 0 END DESC, SUBSTR(`pinfo`.`desc_title`, 1, LOCATE('drink', `pinfo`.`desc_title`)) DESC

Currently Filtered by

Keyword

Sports Drink

Refine Search

  GO
Category Filter

Sports Drinks(66)

Water Bottles(2)

Snacks(1)

Backpacks(1)

Brand

Gatorade(39)

Sqwincher(22)

Champion Sports(3)

Red Bull(2)

5-hour ENERGY(2)

Starbucks(1)

Packing Type

Packet(37)

Bottle(14)

Concentrate(5)

Stick(4)

Aluminum Can(3)

Can(2)

Flavor

Fruit Punch(14)

Lemon-Lime(11)

Orange(11)

Grape(4)

Berry(4)

Glacier Freeze(3)

Lemonade(3)

Riptide Rush(3)

Assorted(3)

Peach Tea(1)

Raspberry(1)

Lemon/Lime(1)

Cherry(1)

Variety(1)

Fierce Grape(1)

Cool Blue(1)

Sugar-Free(1)

Original(1)

Strawberry Lemonade(1)

Beverage Type

Flavored Sports Drink(54)

Energy Drink(4)

Flavored Drink Mix(2)

Sport Drink(2)

Sports Drink(2)

Refresher(1)

Footnote 3

Sweetened with aspartame and acesulfame K.(1)

Gluten Free

Yes(1)

Manufacturer Shelf Life

540 Days(1)

Special Features

Yields 2.5 Gallons per Package(6)

Makes 20 oz(3)

Makes 20 Ounces(2)

Assorted Flavors(1)

Variety Pack(1)

Extra Strength-Contains as much caffeine as 12 oz of premium coffee.(1)

 
 
Searching for your Best Results.....
Loading...
 
AbilityOne Distributor HP Qualified Supplies Partner

© 2020-2021 United Supply Corp, All Rights Reserved