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

Trash Bags & Liners(64)

Cups & Mugs(60)

Floor & Carpet Cleaner Accessories(30)

Indoor Mats(26)

Plates & Bowls(24)

Cutlery(23)

Cleaning Wipes(22)

Liquid Soap / Sanitizer Dispensers(21)

Urinal Screens & Deodorizers(21)

Waste Containers & Accessories(19)

Hand Soaps/Cleaners(19)

Brooms & Sweepers(19)

Multipurpose Cleaners(19)

Paper Towels(17)

Anti-Fatigue Mats(17)

Bathroom Tissues(15)

Hand Sanitizers(14)

Poles & Handles(14)

Table Covers/Skirts(14)

Cups & Mugs Accessories(12)

Brushes & Dusters(12)

Food Storage Bags/Wraps(10)

Sweeteners(10)

Glass Cleaners(10)

Spray Bottles(9)

Carafes & Airpots(9)

Dishwashing Detergents & Liquids(9)

Air Fresheners/Sanitizers(9)

Dust Pans(9)

Cleaning Equipment Parts & Accessories(8)

Paper Towel Dispensers(7)

Sprayer Parts & Accessories(7)

Floor & Carpet Cleaners(6)

Outdoor Mats(6)

Dust Mop Frames(6)

Creamers(6)

Gloves(5)

Beverage Straws & Stir Sticks(5)

Safety/Caution Signs(5)

Breakroom Organizers(4)

Buckets(4)

Cup Dispensers/Organizers(4)

Hairnets(4)

Smoking Receptacles(4)

Paper Napkins(4)

Duster Refills(4)

Dispenser Accessories(3)

Specialty Cleaners/Lubricants(3)

Janitorial Cloths & Wipes(2)

Plungers(2)

Toilet Seats(2)

Sponges & Scouring Pads(2)

Board Cleaners & Wipes(2)

Furniture Polish(2)

Recycling Bins(2)

Aprons(2)

Toilet Bowl Cleaners(2)

Air Freshener/Sanitizers Dispensers(2)

Bathroom Cleaners(2)

Facial Tissues(2)

Safety Gear(2)

Reusable Towels(2)

Skin Wipes(2)

Toilet Seat Covers(2)

Laundry Detergents(1)

Bathroom Tissue Dispensers(1)

Spot & Stain Removers(1)

Tool Kits(1)

Hand Trucks & Dollies(1)

Foil & Wraps(1)

Ladders & Step Stools(1)

Janitorial Carts(1)

Pliers(1)

Janitorial Organizers(1)

Water Filters & Purifying Dispensers(1)

Beverage Dispensers/Coolers(1)

Towelettes(1)

Wall Racks(1)

Restroom Mats(1)

 
Brand

Genuine Joe(819)

Genuine Joe Solutions(12)

 
Color

White(226)

Black(119)

Natural(73)

Blue(71)

Clear(69)

Brown(39)

Green(35)

Gray(28)

Yellow(26)

Orange(23)

Red(20)

Stainless Steel(18)

Silver(17)

Translucent(14)

Dark Blue(6)

Charcoal(6)

Charcoal Gray(5)

Metallic(5)

Purple(4)

Amber(4)

Chocolate(4)

Transparent(3)

Assorted(3)

Dark Green(3)

Maroon(2)

Black Marble(2)

Salt Pepper(2)

Gray Marble(2)

Turquoise(2)

Charcoal Black(2)

Green Tint(2)

Multi(2)

Aqua Marine(2)

Pink(2)

Aqua(1)

Champagne(1)

Smoke(1)

Nickel(1)

Kraft(1)

Steel Gray(1)

Chrome(1)

Blue Frost(1)

Warm White(1)

Bronze(1)

Aluminum(1)

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

Yes(101)

 
 
 

© 2018-2019 Innovative Copy Products, All Rights Reserved