Banner1 Banner1
 
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 (`category_id` IN ('124')) 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_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 '%Cables' THEN 1 ELSE 0 END DESC, CASE WHEN MATCH(`desc_short`) AGAINST ('Cables' IN BOOLEAN MODE) THEN 1 ELSE 0 END DESC, CASE WHEN `pinfo`.`vendor`=2 THEN IF(MATCH(`desc_long`, `manufacturer_name`, `color`) AGAINST ('+Cables' IN BOOLEAN MODE),4,0) ELSE CASE WHEN MATCH (`keywords`) AGAINST ('"Cables"' IN BOOLEAN MODE) AND MATCH (`desc_title`) AGAINST ('"Cables"' IN BOOLEAN MODE) THEN 4 ELSE IF(MATCH (`desc_title`) AGAINST ('"Cables"' IN BOOLEAN MODE),3,IF(MATCH (`keywords`) AGAINST ('"Cables"' IN BOOLEAN MODE),2,IF(MATCH(`desc_title`, `manufacturer_name`, `color`) AGAINST ('+Cables' IN BOOLEAN MODE),1,0))) END END DESC,CASE WHEN IF(`pinfo`.`vendor`=2,`category_3` ='Cables',`category_4` ='Cables') THEN 1 ELSE 0 END DESC, CASE WHEN `desc_short` LIKE 'Cables,%' THEN 1 ELSE 0 END DESC, SUBSTR(`pinfo`.`desc_title`, 1, LOCATE('Cables', `pinfo`.`desc_title`)) DESC

Currently Filtered by

Category

Cables

Refine Search
  GO
 
Brand

Tripp Lite(43)

Softalk(8)

ByTech(1)

Case Logic(1)

Scosche(1)

 
Manufacturer Part Number

BYMPCA107BK(1)

P568-010(1)

N201014BK(1)

N201014BL(1)

N201-014-GY(1)

N201025BK(1)

N201-025-BL(1)

N201-050-GY(1)

P502006(1)

P502050(1)

P566-006(1)

P568-006(1)

P569006(1)

N201007BL(1)

P569010(1)

P580006(1)

P582006(1)

P586006DVI(1)

P586006HDMI(1)

P586006VGA(1)

U022-010(1)

U024-006(1)

U024-010(1)

U244001R(1)

U324006(1)

N201-007-GY(1)

N201007BK(1)

CLLPCA002WT(1)

N002007BK(1)

04020(1)

04130(1)

42215(1)

42260(1)

42261(1)

42265(1)

48100(1)

48102(1)

12RA(1)

N002002BK(1)

N002-002-BL(1)

N002-007-BL(1)

N201-001-BL(1)

N002-007-GY(1)

N002-010-BK(1)

N002-010-BL(1)

N002-010-GY(1)

N002010WH(1)

N002-014-BK(1)

N002-014-BL(1)

N002-014-GY(1)

N002014WH(1)

N002-025-BL(1)

N002100GY(1)

U324010(1)

 
Country of Origin

CN(54)

 
Connector/Port/Interface

Two RJ 45 Male(25)

Two 6P4C Plug(7)

A Male to A Female(4)

HDMI 1.4 Male; HDMI 1.4 Male(2)

HD15 Male; HD15 Male(2)

Two HDMI Male(2)

Apple Lightning; USB(2)

Mini DisplayPort to HDMI HD Cable Adapter(1)

A Male to B Male(1)

Mini DisplayPort to VGA(1)

Micro USB; USB(1)

Mini DisplayPort to DVI(1)

DisplayPort HDMI Male to Male(1)

DisplayPort Male(1)

DVI Male; HDMI Male(1)

6P4C Plug;Dual Jack(1)

USB A (Male); DVI-I (Female)(1)

 
For Device Type

Telephone(6)

Mac;Network;PC(5)

Home Theater System(3)

USB 2.0 Peripherals(3)

HDMI(2)

Monitor(2)

PC(2)

Monitors; Computers(2)

Mac; Network; PC(2)

USB 2.0, 3.0 Peripherals(2)

Answering Machine;Fax Machine;Modem;Telephone(1)

Computers, Digital Cameras, Cell Phone(1)

DVI Monitor(1)

Monitor; HDMI(1)

VGA(1)

Telephone;Telephone Accessory(1)

VGA/DVI Monitors; Projectors(1)

 
Connects Devices (From/To)

CAT6/CAT5e(10)

Phone to Handset(6)

Cat 5/Cat 5e(5)

Cat 6/Cat 5e(5)

Computers in Local Area Network(4)

USB Peripherals to Hub/PC/Mac(3)

Computer to Monitor(3)

HDTV Display Devices to Digital Video Sources(2)

Some Smartphones; Tablets; Computers; Monitors; TVs(2)

Peripherals to Computer(2)

Monitor to Computer(2)

Digital Display Devices to Digital Source Devices(1)

Answering Machine;Fax Machine;Modem to Modular Phone Wall Outlet;Telephone(1)

100 MBps TPDDI;155 MBps ATM;Hardware in 10/100/1000 Base-T Ethernet;ISDN;Voice/Token Ring Type Applications(1)

USB to Lightning or micro USB Device(1)

Computers with DisplayPort Video Out Port to an HDMI-enabled Monitor or TV(1)

Computer with Mini DisplayPort Output to an HDMI-enabled Monitor or TV(1)

Telephone;Telephone Accessory to Modular Phone Wall Outlet(1)

Monitor to PC(1)

 
Cable Length

6 ft(11)

10 ft(11)

25 ft(9)

14 ft(7)

7 ft(6)

12 ft(2)

2 ft(2)

50 ft(2)

3 ft(1)

100 ft(1)

1 ft(1)

4"(1)

 
Cable Type

Cat5e Patch Molded(14)

CAT6 Snagless Molded(10)

Coiled Phone Cord(6)

USB 2.0(5)

DisplayPort Cable(4)

Video(3)

VGA Monitor(2)

HDMI Cables(2)

USB 3.0 Extension(2)

Line/Extension Cord(1)

Duplex Outlet Line Extension Cord(1)

USB(1)

Cat5e(1)

DisplayPort(1)

Display Adapter(1)

 
Jacket Color

Black(27)

Blue(11)

Gray(7)

Ivory(4)

White(3)

Ash(1)

Beige(1)

 
 
 

© 2020-2021 gemlaser, Inc., All Rights Reserved

Powered by SITS Erp