SELECT bizNetworkDevice WHERE id = $id$ SELECT bizInterface WHERE device_id = $id$ SELECT lnkContactInfra WHERE infra_id = $id$ SELECT lnkInfraTicket WHERE infra_id = $id$ SELECT bizChangeTicket AS c JOIN lnkInfraChangeTicket AS l ON l.ticket_id = c.id WHERE l.infra_id = $id$ SELECT lnkInfraGrouping WHERE infra_id = $id$ SELECT lnkDocumentRealObject WHERE object_id = $id$