added brandID designation to part table query