WHERE (active = 1 AND custom_active = -1 OR custom_active = 1) AND last_square_price != 0 AND name NOT LIKE '%damage%' AND category NOT LIKE '%clearance%' AND subcat NOT LIKE '%clearance%' AND raw_table != 'CSV_hrp' AND ((custom_newcat = '' AND newcat = '' AND category LIKE '%Connectors, Adapters & Wire%') OR (newcat = 'Connectors, Adapters & Wire' AND custom_newcat = '') OR custom_newcat = 'Connectors, Adapters & Wire') AND ((custom_subcat = '' AND subcat = 'Wire') OR custom_subcat='Wire')
Connectors, Adapters & Wire
Castle Creations Wire 36" 8 AWG black

$26.99
Castle Creations Wire 36" 8 AWG red

$26.99
Castle Creations Wire 36" 8 AWG white

$26.99
Castle Creations Wire, 24" 6 AWG, Black

$49.99
Castle Creations Wire, 24" 6 AWG, Red

$49.99
Castle Creations Wire, 36", 10 AWG, Black

$22.99
Castle Creations Wire, 36", 10 AWG, Red

$22.99
Castle Creations Wire, 36", 10 AWG, White

$22.99
Castle Creations Wire, 60", 13 AWG, Black

$18.99
Castle Creations Wire, 60", 13 AWG, Red

$18.99
Castle Creations Wire, 60", 13 AWG, White

$18.99
Castle Creations Wire, 60", 16 AWG, Black

$15.99
Castle Creations Wire, 60", 16 AWG, Red

$15.99
Castle Creations Wire, 60", 16 AWG, White

$15.99
Castle Creations Wire, 60", 20 AWG, Black

$15.99
Castle Creations Wire, 60", 20 AWG, Red

$15.99
Castle Creations Wire, 60", 20 AWG, White

$15.99
Castle Creations Wire, 60", 24 AWG, Black

$15.99
Castle Creations Wire, 60", 24 AWG, Red

$15.99
Castle Creations Wire, 60", 24 AWG, White

$15.99