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)

Trash Bags & Liners(64)

Cups & Mugs(60)

Floor & Carpet Cleaner Accessories(38)

Indoor Mats(26)

Plates & Bowls(24)

Cutlery(23)

Brooms & Sweepers(22)

Cleaning Wipes(22)

Liquid Soap / Sanitizer Dispensers(21)

Urinal Screens & Deodorizers(20)

Multipurpose Cleaners(20)

Hand Soaps/Cleaners(19)

Waste Containers & Accessories(19)

Anti-Fatigue Mats(17)

Paper Towels(16)

Poles & Handles(15)

Bathroom Tissues(14)

Table Covers/Skirts(14)

Hand Sanitizers(13)

Brushes & Dusters(12)

Cups & Mugs Accessories(12)

Air Fresheners/Sanitizers(11)

Dust Pans(11)

Sweeteners(10)

Glass Cleaners(10)

Food Storage Bags/Wraps(10)

Carafes & Airpots(10)

Spray Bottles(9)

Dishwashing Detergents & Liquids(9)

Cleaning Equipment Parts & Accessories(8)

Gloves(7)

Sprayer Parts & Accessories(7)

Paper Towel Dispensers(7)

Outdoor Mats(6)

Floor & Carpet Cleaners(6)

Dust Mop Frames(6)

Creamers(6)

Buckets(5)

Beverage Straws & Stir Sticks(5)

Smoking Receptacles(4)

Paper Napkins(4)

Duster Refills(4)

Breakroom Organizers(4)

Hairnets(4)

Cup Dispensers/Organizers(4)

Safety/Caution Signs(4)

Recycling Bins(3)

Bathroom Cleaners(3)

Dispenser Accessories(3)

Specialty Cleaners/Lubricants(3)

Janitorial Cloths & Wipes(2)

Board Cleaners & Wipes(2)

Safety Gear(2)

Toilet Seats(2)

Sponges & Scouring Pads(2)

Restroom Mats(2)

Skin Wipes(2)

Plungers(2)

Furniture Polish(2)

Toilet Seat Covers(2)

Ladders & Step Stools(2)

Facial Tissues(2)

Toilet Bowl Cleaners(2)

Aprons(2)

Tool Kits(2)

Reusable Towels(2)

Air Freshener/Sanitizers Dispensers(2)

Laundry Detergents(1)

Spot & Stain Removers(1)

Bathroom Tissue Dispensers(1)

Hand Trucks & Dollies(1)

Foil & Wraps(1)

Storage Boxes & Containers(1)

Janitorial Carts(1)

Pliers(1)

Tool Storage & Organization(1)

Beverage Dispensers/Coolers(1)

Towelettes(1)

Wall Racks(1)

Water Filters & Purifying Dispensers(1)

 
Brand

Genuine Joe(842)

Genuine Joe Solutions(11)

 
Color

White(229)

Black(124)

Natural(75)

Blue(73)

Clear(68)

Brown(39)

Green(37)

Gray(33)

Yellow(26)

Orange(24)

Red(23)

Stainless Steel(19)

Silver(18)

Translucent(14)

Dark Blue(6)

Charcoal(6)

Charcoal Gray(5)

Metallic(5)

Purple(4)

Amber(4)

Chocolate(4)

Dark Green(3)

Assorted(3)

Transparent(3)

Pink(3)

Gray Marble(2)

Maroon(2)

Black Marble(2)

Aqua Marine(2)

Green Tint(2)

Salt Pepper(2)

Light Blue(2)

Charcoal Black(2)

Turquoise(2)

Multi(2)

Steel Gray(1)

Gold(1)

Chrome(1)

Champagne(1)

Warm White(1)

Smoke(1)

Aluminum(1)

Blue Frost(1)

Bronze(1)

Kraft(1)

Nickel(1)

Oak(1)

Aqua(1)

 
Size

12" Wide(4)

48" Width x 5" Depth(4)

24" Width x 5" Depth(3)

36" Width x 5" Depth(3)

7.75" Length(3)

5.50" Length(2)

18" Width x 5" Depth(2)

18" Width x 25" Depth(2)

16" Wide(2)

23" Length x 5.75" Diameter(2)

24" Width x 25" Depth(1)

5" Width x 36" Length(1)

 
Recycled

No(658)

Yes(101)

 
 
 

© 2018-2019 LOP Office Supply, All Rights Reserved