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_1` 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)

Cups & Mugs(66)

Trash Bags & Liners(64)

Floor & Carpet Cleaner Accessories(36)

Waste Containers & Accessories(29)

Brooms & Sweepers(28)

Indoor Mats(28)

Plates(26)

Cutlery(23)

Urinal Screens & Deodorizers(23)

Liquid Soap / Sanitizer Dispensers(22)

Hand Soaps/Cleaners(19)

Anti-Fatigue Mats(17)

Paper Towels(16)

Cleaning Wipes(15)

Brushes & Dusters(15)

Poles & Handles(15)

Multipurpose Cleaners(14)

Table Covers/Skirts(14)

Bathroom Tissues(13)

Cleaning Equipment Parts & Accessories(13)

Hand Sanitizers(13)

Cups & Mugs Accessories(12)

Air Fresheners/Sanitizers(11)

Dust Pans(11)

Glass Cleaners(10)

Sweeteners(10)

Food Storage Bags/Wraps(10)

Carafes & Airpots(9)

Spray Bottles(9)

Dishwashing Detergents & Liquids(9)

Dust Mop Frames(8)

Paper Towel Dispensers(7)

Sprayer Parts & Accessories(7)

Gloves(6)

Creamers(6)

Beverage Straws & Stir Sticks(6)

Bowls(6)

Deodorizers(5)

Safety/Caution Signs(5)

Breakroom Organizers(4)

Outdoor Mats(4)

Hairnets(4)

Specialty Cleaners/Lubricants(4)

Paper Napkins(4)

Smoking Receptacles(4)

Duster Refills(4)

Buckets(4)

Recycling Bins(3)

Floor & Carpet Cleaners(3)

Dispenser Accessories(3)

Bathroom Tissue Dispensers(3)

Board Cleaners & Wipes(2)

Fall Protection Equipments(2)

Safety Gear(2)

Bathroom Cleaners(2)

Air Freshener/Sanitizers Dispensers(2)

Sponges & Scouring Pads(2)

Aprons(2)

Toilet Bowl Cleaners(2)

Plungers(2)

Toilet Seats(2)

Tool Kits(2)

Toilet Seat Covers(2)

Furniture Polish(2)

Facial Tissues(2)

Reusable Towels(2)

Cup Dispensers/Organizers(2)

Janitorial Cloths & Wipes(2)

Ladders & Step Stools(1)

Janitorial Carts(1)

Foil & Wraps(1)

Spot & Stain Removers(1)

Laundry Detergents(1)

Tool Storage & Organization(1)

Towelettes(1)

Water Filters & Purifying Dispensers(1)

Skin Wipes(1)

Wall Racks(1)

Tape Measures(1)

Restroom Mats(1)

Pliers(1)

 
Brand

Genuine Joe(868)

Genuine Joe Solutions(11)

 
Color

White(222)

Black(127)

Blue(78)

Natural(74)

Clear(70)

Brown(42)

Gray(37)

Green(35)

Yellow(29)

Orange(22)

Red(21)

Stainless Steel(19)

Silver(19)

Assorted(16)

Translucent(14)

Purple(8)

Dark Blue(7)

Charcoal(6)

Metallic(5)

Charcoal Gray(5)

Amber(4)

Maroon(4)

Chocolate(4)

Charcoal Black(3)

Transparent(3)

Gray Marble(2)

Black Marble(2)

Salt Pepper(2)

Aqua Marine(2)

Green Tint(2)

Chrome(2)

Turquoise(2)

Multi(2)

Pink(2)

Light Brown(2)

Aqua(1)

Woodgrain(1)

Champagne(1)

Steel Gray(1)

Kraft(1)

Granite(1)

Warm White(1)

Blue Frost(1)

Nickel(1)

Bronze(1)

Aluminum(1)

Oak(1)

 
Size

12" Wide(6)

7.75" Length(4)

48" Width x 5" Depth(4)

36" Width x 5" Depth(3)

24" Width x 5" Depth(3)

16" Wide(2)

5.50" Length(2)

18" Width x 5" Depth(2)

18" Width x 25" Depth(2)

5" Width x 36" Length(1)

24" Width x 25" Depth(1)

 
Recycled

No(688)

Yes(87)

 
 
 

© 2019-2020 LOP Office Supply, All Rights Reserved