1
select `cnt`.`ClientID` AS `ClientID`,`cnt`.`ContactID` AS `ContactID`,`sci`.`ComputerId` AS `ComputerID`,`ca`.`SessionName` AS `SessionName`,`ca`.`ConnectedTime` AS `ConnectedTime`,`ca`.`DurationSeconds` AS `DurationSeconds` from ((`labtech`.`contacts` `cnt` join `labtech`.`plugin_screenconnect_connectionaudits` `ca` on((lower(`cnt`.`Email`) = lower(`ca`.`ParticipantName`)))) join `labtech`.`plugin_screenconnect_scinstalled` `sci` on((convert(`sci`.`SessionGUID` using utf8) = `ca`.`SessionID`)))