SELECT bizServer WHERE id = $id$ SELECT bizApplication WHERE device_id = $id$ SELECT bizPatch WHERE device_id = $id$ SELECT bizInterface WHERE device_id = $id$ SELECT lnkContactRealObject WHERE object_id = $id$ SELECT lnkInfraTicket WHERE infra_id = $id$ SELECT bizChangeTicket AS Change JOIN lnkInfraChangeTicket AS Link ON Link.ticket_id = Change.id WHERE Link.infra_id = $id$ SELECT lnkInfraGrouping WHERE infra_id = $id$ SELECT lnkDocumentRealObject WHERE object_id = $id$