LOINC Part Code LP444472-7 : Brucella sp | Tissue and Smears | Microbiology

No Database Connections Available for "PublishCode" (used: InUse 10 of 10: PublishCode 1sec (Select StatusCodes.Description from Codes, StatusCodes where CodeKey = 67554 and Codes.StatusKey != 0 and Codes.StatusKey = StatusCodes.StatusKey) PublishCode 1sec (Select StatusCodes.Description from Codes, StatusCodes where CodeKey = 7549 and Codes.StatusKey != 0 and Codes.StatusKey = StatusCodes.StatusKey) PublishCode 1sec (Select StatusCodes.Description from Codes, StatusCodes where CodeKey = 46387 and Codes.StatusKey != 0 and Codes.StatusKey = StatusCodes.StatusKey) PublishCode 1sec (Select StatusCodes.Description from Codes, StatusCodes where CodeKey = 68216 and Codes.StatusKey != 0 and Codes.StatusKey = StatusCodes.StatusKey) PublishCode 1sec (Select StatusCodes.Description from Codes, StatusCodes where CodeKey = 47474 and Codes.StatusKey != 0 and Codes.StatusKey = StatusCodes.StatusKey) PublishCode 955ms (Select StatusCodes.Description from Codes, StatusCodes where CodeKey = 67575 and Codes.StatusKey != 0 and Codes.StatusKey = StatusCodes.StatusKey) PublishCode 701ms (Select StatusCodes.Description from Codes, StatusCodes where CodeKey = 44425 and Codes.StatusKey != 0 and Codes.StatusKey = StatusCodes.StatusKey) PublishCode 568ms (Select StatusCodes.Description from Codes, StatusCodes where CodeKey = 115685 and Codes.StatusKey != 0 and Codes.StatusKey = StatusCodes.StatusKey) PublishCode 292ms (Select StatusCodes.Description from Codes, StatusCodes where CodeKey = 60067 and Codes.StatusKey != 0 and Codes.StatusKey = StatusCodes.StatusKey) PublishCode 81ms (Select RelationshipTypes.Description as Relationship, Codes.Code, Codes.Description as Value from Relationships, RelationshipTypes, Codes where Relationships.SourceKey = 101747 and Relationships.RelationshipTypeKey = RelationshipTypes.RelationshipTypeKey and Relationships.TargetKey = Codes.CodeKey))