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 '%Gears & Pinions%') OR (newcat = 'Gears & Pinions' AND custom_newcat = '') OR custom_newcat = 'Gears & Pinions') AND ((custom_subcat = '' AND subcat = 'Transmision Gears') OR custom_subcat='Transmision Gears')

Gears & Pinions