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 '%Parts%') OR (newcat = 'Parts' AND custom_newcat = '') OR custom_newcat = 'Parts') AND ((custom_subcat = '' AND subcat = 'Chassis Protectors') OR custom_subcat='Chassis Protectors')
Parts
JConcepts Rustler 2wd, mesh, breathable chassis cover

$35.99
JConcepts Rustler 4x4, mesh, breathable chassis cover

$42.99
JConcepts Slash 4x4, mesh, breathable chassis cover

$34.99
JConcepts Stampede, mesh, breathable chassis cover

$33.99
JConcepts X-Maxx, mesh, breathable chassis cover

$60.99
JConcepts - B6 | B6D precut chassis protective sheet - striker grap...

$30.99
JConcepts - XRAY XB4 precut chassis protective sheet - striker grap...

$34.99
JConcepts 14x5.5" Chassis Protective Film Sheet

$17.99
JConcepts B44.2 - precut chassis protective sheet - black

$24.99
JConcepts B6.1 | B6.1D precut chassis protective sheet - striker gr...

$34.99
JConcepts B64 | B64D precut chassis protective sheet - striker grap...

$30.99
JConcepts B74 precut chassis protective sheet - striker graphics, 2pc

$34.99
JConcepts Illuzion - Rustler 2wd - overtray - protects chassis from...

$43.99
JConcepts Illuzion - SC10 4x4 overtray - protects chassis from exce...

$34.99
JConcepts Illuzion - SC10 overtray - protects chassis from excessiv...

$43.99
JConcepts Illuzion - Slash 4x4 overtray - protects chassis from exc...

$43.99
JConcepts Illuzion - Slash overtray - protects chassis from excessi...

$34.99
JConcepts Illuzion - Stampede 4x4 - over-tray - protects chassis fr...

$43.99
JConcepts Illuzion - Traxxas Rally - over-tray - protects chassis f...

$43.99
JConcepts RC10B5M precut chassis protective sheet - black

$25.99