Corrected some queries. Added ear tag color and location for registrations.