No Database Connections Available for "PublishCode" (used: InUse 10 of 10: PublishCode 360ms (Select RelationshipTypes.Description as Relationship, Codes.Code, Codes.Description as Value from Relationships, RelationshipTypes, Codes where Relationships.SourceKey = 146103 and Relationships.RelationshipTypeKey = RelationshipTypes.RelationshipTypeKey and Relationships.TargetKey = Codes.CodeKey) PublishCode 297ms (Select RelationshipTypes.Description as Relationship, Codes.Code, Codes.Description as Value from Relationships, RelationshipTypes, Codes where Relationships.SourceKey = 133602 and Relationships.RelationshipTypeKey = RelationshipTypes.RelationshipTypeKey and Relationships.TargetKey = Codes.CodeKey) PublishCode 249ms (Select RelationshipTypes.Description as Relationship, Codes.Code, Codes.Description as Value from Relationships, RelationshipTypes, Codes where Relationships.SourceKey = 89004 and Relationships.RelationshipTypeKey = RelationshipTypes.RelationshipTypeKey and Relationships.TargetKey = Codes.CodeKey) filterBySQL 249ms (select SourceKey as Key from Relationships where RelationshipTypeKey = 30 and TargetKey in (select CodeKey from Codes where Description = 'DOC' COLLATE NOCASE) order by SourceKey ASC) PublishCode 188ms (Select RelationshipTypes.Description as Relationship, Codes.Code, Codes.Description as Value from Relationships, RelationshipTypes, Codes where Relationships.SourceKey = 127573 and Relationships.RelationshipTypeKey = RelationshipTypes.RelationshipTypeKey and Relationships.TargetKey = Codes.CodeKey) PublishCode 157ms (Select RelationshipTypes.Description as Relationship, Codes.Code, Codes.Description as Value from Relationships, RelationshipTypes, Codes where Relationships.SourceKey = 156279 and Relationships.RelationshipTypeKey = RelationshipTypes.RelationshipTypeKey and Relationships.TargetKey = Codes.CodeKey) PublishCode 141ms (Select RelationshipTypes.Description as Relationship, Codes.Code, Codes.Description as Value from Relationships, RelationshipTypes, Codes where Relationships.SourceKey = 174583 and Relationships.RelationshipTypeKey = RelationshipTypes.RelationshipTypeKey and Relationships.TargetKey = Codes.CodeKey) PublishCode 124ms (Select RelationshipTypes.Description as Relationship, Codes.Code, Codes.Description as Value from Relationships, RelationshipTypes, Codes where Relationships.SourceKey = 203165 and Relationships.RelationshipTypeKey = RelationshipTypes.RelationshipTypeKey and Relationships.TargetKey = Codes.CodeKey) PublishCode 78ms (Select RelationshipTypes.Description as Relationship, Codes.Code, Codes.Description as Value from Relationships, RelationshipTypes, Codes where Relationships.SourceKey = 188969 and Relationships.RelationshipTypeKey = RelationshipTypes.RelationshipTypeKey and Relationships.TargetKey = Codes.CodeKey) PublishCode 32ms (Select RelationshipTypes.Description as Relationship, Codes.Code, Codes.Description as Value from Relationships, RelationshipTypes, Codes where Relationships.SourceKey = 192183 and Relationships.RelationshipTypeKey = RelationshipTypes.RelationshipTypeKey and Relationships.TargetKey = Codes.CodeKey))
FHIR