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

Currently Filtered by

Keyword

Genuine Joe

Refine Search

  GO
 
Category

Mops & Mop Refills(128)

Trash Bags & Liners(64)

Cups & Mugs(53)

Floor & Carpet Cleaner Accessories(26)

Indoor Mats(26)

Cutlery(23)

Plates & Bowls(22)

Brooms & Sweepers(22)

Cleaning Wipes(21)

Urinal Screens & Deodorizers(20)

Waste Containers & Accessories(19)

Liquid Soap / Sanitizer Dispensers(19)

Anti-Fatigue Mats(17)

Multipurpose Cleaners(17)

Hand Soaps/Cleaners(16)

Paper Towels(15)

Air Fresheners/Sanitizers(15)

Table Covers/Skirts(14)

Poles & Handles(14)

Bathroom Tissues(12)

Cups & Mugs Accessories(12)

Carafes & Airpots(11)

Cleaning Equipment Parts & Accessories(11)

Food Storage Bags/Wraps(10)

Hand Sanitizers(10)

Spray Bottles(9)

Dust Pans(9)

Brushes & Dusters(9)

Sweeteners(8)

Sprayer Parts & Accessories(6)

Outdoor Mats(6)

Dust Mop Frames(6)

Paper Towel Dispensers(6)

Glass Cleaners(6)

Beverage Straws & Stir Sticks(5)

Breakroom Organizers(4)

Hairnets(4)

Paper Napkins(4)

Buckets(4)

Cup Dispensers/Organizers(4)

Specialty Cleaners/Lubricants(4)

Dishwashing Detergents & Liquids(4)

Duster Refills(4)

Smoking Receptacles(4)

Recycling Bins(3)

Creamers(3)

Floor & Carpet Cleaners(3)

Safety/Caution Signs(3)

Safety Gear(2)

Janitorial Cloths & Wipes(2)

Sponges & Scouring Pads(2)

Board Cleaners & Wipes(2)

Restroom Mats(2)

Toilet Seats(2)

Aprons(2)

Ladders & Step Stools(2)

Air Freshener/Sanitizers Dispensers(2)

Skin Wipes(2)

Plungers(2)

Facial Tissues(2)

Tool Kits(2)

Furniture Polish(2)

Reusable Towels(2)

Toilet Seat Covers(2)

Bathroom Cleaners(2)

Laundry Detergents(1)

Dispenser Accessories(1)

Foil & Wraps(1)

Hand Trucks & Dollies(1)

Storage Boxes & Containers(1)

Janitorial Carts(1)

Tool Storage & Organization(1)

Wall Racks(1)

Gloves(1)

Towelettes(1)

Beverage Dispensers/Coolers(1)

 
Brand

Genuine Joe(773)

Genuine Joe Solutions(7)

 
Color

White(224)

Black(113)

Natural(70)

Clear(65)

Blue(61)

Gray(36)

Brown(34)

Green(33)

Yellow(21)

Orange(21)

Stainless Steel(19)

Red(18)

Silver(16)

Translucent(14)

Charcoal(6)

Charcoal Gray(5)

Metallic(4)

Chocolate(4)

Transparent(3)

Assorted(3)

Dark Green(3)

Maroon(2)

Salt Pepper(2)

Green Tint(2)

Black Marble(2)

Gray Marble(2)

Gold(2)

Charcoal Black(2)

Turquoise(2)

Multi(2)

Pink(2)

Oak(1)

Smoke(1)

Champagne(1)

Chrome(1)

Aqua(1)

Bronze(1)

Kraft(1)

Blue Frost(1)

Steel Gray(1)

Nickel(1)

Warm White(1)

Stainless Steel Finish(1)

Aluminum(1)

 
Size

48" Width x 5" Depth(4)

36" Width x 5" Depth(3)

7.75" Length(3)

24" Width x 5" Depth(3)

23" Length x 5.75" Diameter(2)

16" Wide(2)

5.50" Length(2)

12" Wide(2)

18" Width x 25" Depth(2)

18" Width x 5" Depth(2)

5" Width x 36" Length(1)

24" Width x 25" Depth(1)

 
Recycled

No(511)

Yes(57)

 
 
 

© 2017-2018 Innovative Copy Products, All Rights Reserved