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_27` 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 Filter

Mops & Mop Refills(132)

Cups & Mugs(66)

Trash Bags & Liners(64)

Floor & Carpet Cleaner Accessories(28)

Brooms & Sweepers(28)

Waste Containers & Accessories(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)

Brushes & Dusters(15)

Cleaning Wipes(15)

Table Covers/Skirts(14)

Multipurpose Cleaners(14)

Poles & Handles(13)

Hand Sanitizers(13)

Bathroom Tissues(13)

Cups & Mugs Accessories(12)

Air Fresheners/Sanitizers(11)

Dust Pans(11)

Cleaning Equipment Parts & Accessories(10)

Food Storage Bags/Wraps(10)

Sweeteners(10)

Glass Cleaners(10)

Dishwashing Detergents & Liquids(9)

Spray Bottles(9)

Dust Mop Frames(8)

Paper Towel Dispensers(7)

Carafes & Airpots(7)

Sprayer Parts & Accessories(7)

Beverage Straws & Stir Sticks(6)

Bowls(6)

Creamers(6)

Deodorizers(5)

Gloves(5)

Safety/Caution Signs(5)

Smoking Receptacles(4)

Specialty Cleaners/Lubricants(4)

Outdoor Mats(4)

Duster Refills(4)

Hairnets(4)

Buckets(4)

Paper Napkins(4)

Dispenser Accessories(3)

Recycling Bins(3)

Floor & Carpet Cleaners(3)

Bathroom Tissue Dispensers(3)

Plungers(2)

Toilet Bowl Cleaners(2)

Toilet Seat Covers(2)

Board Cleaners & Wipes(2)

Safety Gear(2)

Toilet Seats(2)

Furniture Polish(2)

Fall Protection Equipments(2)

Janitorial Cloths & Wipes(2)

Bathroom Cleaners(2)

Reusable Towels(2)

Air Freshener/Sanitizers Dispensers(2)

Aprons(2)

Sponges & Scouring Pads(2)

Breakroom Organizers(2)

Facial Tissues(2)

Laundry Detergents(1)

Spot & Stain Removers(1)

Tool Kits(1)

Tape Measures(1)

Foil & Wraps(1)

Ladders & Step Stools(1)

Janitorial Carts(1)

Tool Storage & Organization(1)

Wall Racks(1)

Cup Dispensers/Organizers(1)

Water Filters & Purifying Dispensers(1)

Towelettes(1)

Skin Wipes(1)

Restroom Mats(1)

 
Brand

Genuine Joe(846)

Genuine Joe Solutions(11)

 
Color

White(220)

Black(121)

Blue(77)

Natural(70)

Clear(70)

Brown(41)

Green(35)

Gray(33)

Yellow(29)

Orange(22)

Red(19)

Stainless Steel(18)

Silver(18)

Assorted(16)

Translucent(14)

Purple(8)

Dark Blue(6)

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)

 
Recycled

No(672)

Yes(87)

 
Height

0.4"(8)

24"(4)

30"(4)

12"(3)

29.2"(3)

13.5"(3)

4.3"(2)

6.5"(2)

3.8"(2)

48"(2)

4.5"(2)

15"(2)

34"(2)

37.4"(2)

29"(2)

32"(2)

14"(2)

8.8"(2)

38"(2)

8.2"(2)

2.5"(2)

10.5"(2)

4.6"(2)

6.8"(2)

3.4"(1)

3.3"(1)

5.5"(1)

36"(1)

35"(1)

10.9"(1)

15.5"(1)

40"(1)

50"(1)

31.5"(1)

10.4"(1)

11.5"(1)

8.5"(1)

13"(1)

6"(1)

33"(1)

14.5"(1)

21"(1)

5.9"(1)

 
Depth

2.8"(6)

11"(4)

4.3"(3)

4.1"(2)

24"(2)

10.5"(2)

11.5"(2)

4.5"(2)

10"(1)

13"(1)

3"(1)

5.5"(1)

1.6"(1)

10.3"(1)

20.5"(1)

4"(1)

14"(1)

14.3"(1)

12.3"(1)

15.4"(1)

12.6"(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)

 
Flavor

Hazelnut(1)

French Vanilla(1)

Original(1)

 
Diameter

7"(4)

14.8"(3)

18"(2)

17.5"(2)

13"(1)

16.5"(1)

20"(1)

1"(1)

 
 
 

© 2019-2020 Hi Tech Office Products, All Rights Reserved