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 '%Tires & Wheels%') OR (newcat = 'Tires & Wheels' AND custom_newcat = '') OR custom_newcat = 'Tires & Wheels') AND ((custom_subcat = '' AND subcat = 'Tracks') OR custom_subcat='Tracks')
Tires & Wheels
RC4WD DXR2 Dozer Tracks

$11.99
RC4WD Predator Tracks

$271.99
RC4WD RazorBack Replacement Predator Rubber Tracks

$43.99
Traxxas Deep-Terrain Traxx, TRX-4

$289.99
Traxxas Rubber track, All-Terrain, front

$14.99
Traxxas Rubber track, All-Terrain, rear

$14.99
Traxxas Traxx, TRX-4

$57.99
Traxxas Traxx, TRX-4

$57.99
Traxxas Traxx, TRX-4

$57.99
Traxxas Traxx, TRX-4

$52.99
Traxxas Treads, Deep-Terrain, TRX-4 Traxx

$57.99
Traxxas Treads, Deep-Terrain, TRX-4 Traxx

$14.99
Traxxas Treads, Deep-Terrain, TRX-4 Traxx

$14.99