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

Trash Bags & Liners(64)

Cups & Mugs(53)

Floor & Carpet Cleaner Accessories(36)

Indoor Mats(26)

Plates & Bowls(24)

Cutlery(23)

Brooms & Sweepers(22)

Cleaning Wipes(22)

Multipurpose Cleaners(22)

Urinal Screens & Deodorizers(20)

Liquid Soap / Sanitizer Dispensers(19)

Waste Containers & Accessories(19)

Anti-Fatigue Mats(17)

Hand Soaps/Cleaners(16)

Paper Towels(16)

Air Fresheners/Sanitizers(15)

Glass Cleaners(14)

Table Covers/Skirts(14)

Poles & Handles(14)

Bathroom Tissues(13)

Brushes & Dusters(12)

Cups & Mugs Accessories(12)

Cleaning Equipment Parts & Accessories(11)

Dust Pans(11)

Carafes & Airpots(11)

Hand Sanitizers(10)

Food Storage Bags/Wraps(10)

Spray Bottles(9)

Sweeteners(8)

Dishwashing Detergents & Liquids(7)

Paper Towel Dispensers(7)

Outdoor Mats(6)

Sprayer Parts & Accessories(6)

Dust Mop Frames(6)

Beverage Straws & Stir Sticks(5)

Specialty Cleaners/Lubricants(5)

Breakroom Organizers(4)

Duster Refills(4)

Gloves(4)

Floor & Carpet Cleaners(4)

Cup Dispensers/Organizers(4)

Smoking Receptacles(4)

Hairnets(4)

Paper Napkins(4)

Buckets(4)

Safety/Caution Signs(3)

Recycling Bins(3)

Bathroom Cleaners(3)

Creamers(3)

Toilet Seats(2)

Sponges & Scouring Pads(2)

Board Cleaners & Wipes(2)

Furniture Polish(2)

Safety Gear(2)

Plungers(2)

Ladders & Step Stools(2)

Aprons(2)

Air Freshener/Sanitizers Dispensers(2)

Bathroom Tissue Dispensers(2)

Toilet Seat Covers(2)

Tool Kits(2)

Skin Wipes(2)

Reusable Towels(2)

Janitorial Cloths & Wipes(2)

Facial Tissues(2)

Restroom Mats(2)

Janitorial Carts(1)

Toilet Bowl Cleaners(1)

Spot & Stain Removers(1)

Laundry Detergents(1)

Wall Racks(1)

Beverage Dispensers/Coolers(1)

Dispenser Accessories(1)

Foil & Wraps(1)

Towelettes(1)

Tool Storage & Organization(1)

Storage Boxes & Containers(1)

Hand Trucks & Dollies(1)

 
Brand

Genuine Joe(817)

Genuine Joe Solutions(11)

 
Color

White(235)

Black(119)

Natural(73)

Blue(71)

Clear(66)

Gray(36)

Green(34)

Brown(34)

Yellow(23)

Red(23)

Orange(21)

Stainless Steel(19)

Silver(16)

Translucent(14)

Charcoal(6)

Charcoal Gray(5)

Chocolate(4)

Metallic(4)

Transparent(3)

Dark Green(3)

Pink(3)

Assorted(3)

Gray Marble(2)

Salt Pepper(2)

Maroon(2)

Amber(2)

Dark Blue(2)

Green Tint(2)

Black Marble(2)

Light Blue(2)

Charcoal Black(2)

Gold(2)

Multi(2)

Turquoise(2)

Purple(1)

Champagne(1)

Aqua Marine(1)

Chrome(1)

Aqua(1)

Warm White(1)

Smoke(1)

Steel Gray(1)

Kraft(1)

Nickel(1)

Aluminum(1)

Bronze(1)

Oak(1)

Stainless Steel Finish(1)

Blue Frost(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(548)

Yes(60)

 
 
 

© 2017-2018 LOP Office Supply, All Rights Reserved