SELECT `pinfo`.`sku`,`pinfo`.`vendor`, 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_12` 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 (`category_id` IN ('4729')) AND `pinfo`.`status` IN ('active','discontinued','out_of_stock') AND `pinfo`.`desc_title` != '' AND `online_status`=1 AND `custom_sku_enable`=1 AND CASE WHEN `pinfo`.`multi_level_cost`=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 MATCH(`desc_short`) AGAINST ('Positioning' IN BOOLEAN MODE) THEN 1 ELSE 0 END DESC, CASE WHEN `pinfo`.`vendor`=2 THEN IF(MATCH(`desc_long`, `manufacturer_name`, `color`) AGAINST ('+Positioning' IN BOOLEAN MODE),4,0) ELSE CASE WHEN MATCH (`keywords`) AGAINST ('"Positioning"' IN BOOLEAN MODE) AND MATCH (`desc_title`) AGAINST ('"Positioning"' IN BOOLEAN MODE) THEN 4 ELSE IF(MATCH (`desc_title`) AGAINST ('"Positioning"' IN BOOLEAN MODE),3,IF(MATCH (`keywords`) AGAINST ('"Positioning"' IN BOOLEAN MODE),2,IF(MATCH(`desc_title`, `manufacturer_name`, `color`) AGAINST ('+Positioning' IN BOOLEAN MODE),1,0))) END END DESC,CASE WHEN IF(`pinfo`.`vendor`=2,`category_3` ='Positioning',`category_4` ='Positioning') THEN 1 ELSE 0 END DESC, CASE WHEN `desc_short` LIKE 'Positioning,%' THEN 1 ELSE 0 END DESC, SUBSTR(`pinfo`.`desc_title`, 1, LOCATE('Positioning', `pinfo`.`desc_title`)) DESC

Currently Filtered by

Category

Positioning

Refine Search

  GO
Height

6.00(24)

8.00(7)

22.00(6)

2.00(6)

12.00(5)

28.00(5)

20.00(4)

5.00(4)

10.00(4)

26.00(4)

4.00(4)

14.00(3)

7.00(3)

16.00(3)

39.00(2)

3.50(2)

27.00(2)

13.00(1)

3.00(1)

1.00(1)

41.00(1)

32.00(1)

21.00(1)

34.00(1)

23.00(1)

Width

24.00(22)

20.00(22)

16.00(16)

26.00(16)

22.00(16)

8.00(14)

9.00(10)

19.00(10)

7.00(8)

12.00(6)

36.00(6)

48.00(6)

40.00(6)

34.00(6)

17.00(6)

23.00(4)

4.00(4)

10.00(4)

13.00(2)

30.00(2)

15.00(2)

6.00(2)

14.00(2)

Size

x-large(8)

small(7)

medium(6)

large(6)

6x20x22 inch(4)

4x24 inch(3)

16x20 inch(3)

8x24 inch(3)

24" x 16"(3)

4x20x22 inch(3)

32x40 inch(3)

22x34 inch(3)

22x26 inch(3)

19" L x 3.5" W(2)

8x20x22 inch(2)

16x48 inch(2)

10x20x22 inch(2)

19" L x 5" W(2)

7" x 17"(2)

8x24x26 inch(2)

10x24x26 inch(2)

12x24x26 inch(2)

14x48 inch(2)

8x36 inch(2)

12x22 inch(2)

12x48 inch(2)

10x36 inch(2)

6x24 inch(2)

12x36 inch(2)

12x24x28 inch(1)

23" W x 23" D x 20-30" H(1)

22" x 15"(1)

10x24x28 inch(1)

19" x 12"(1)

22x22 inch(1)

66"(1)

6x24x26 inch(1)

small-large(1)

6x24x28 inch(1)

8x24x28 inch(1)

Length

24.00(13)

6.00(8)

22.00(8)

12.00(7)

20.00(7)

8.00(6)

16.00(5)

32.00(4)

10.00(4)

18.00(4)

7.00(3)

48.00(3)

4.00(3)

36.00(3)

17.00(2)

5.00(2)

9.00(2)

14.00(2)

3.50(2)

34.00(1)

44.00(1)

56.00(1)

19.00(1)

10.50(1)

21.00(1)

13.00(1)

11.00(1)

Weight

6.00(13)

7.00(11)

16.00(7)

2.00(6)

1.00(5)

12.00(5)

5.00(5)

28.00(4)

4.00(4)

10.00(4)

8.00(4)

9.00(4)

48.00(3)

14.00(3)

18.00(3)

3.00(3)

32.00(3)

25.00(3)

0.50(2)

31.00(2)

40.00(2)

11.00(2)

35.00(2)

34.00(2)

39.00(2)

80.00(1)

76.00(1)

50.00(1)

95.00(1)

77.00(1)

22.00(1)

116.00(1)

75.00(1)

72.00(1)

13.00(1)

17.00(1)

15.00(1)

30.00(1)

19.00(1)

24.00(1)

38.00(1)

26.00(1)

27.00(1)

56.00(1)

64.00(1)

 
 
Searching for your Best Results.....
Loading...
 
AbilityOne Distributor HP Qualified Supplies Partner

© 2020-2021 United Supply Corp, All Rights Reserved