1
select `avcs`.`ComputerId` AS `ComputerID`,`avcs`.`AvPluginGUID` AS `AvPluginGUID`,(select `labtech`.`plugins`.`Name` from `labtech`.`plugins` where (`labtech`.`plugins`.`GUID` = `avcs`.`AvPluginGUID`)) AS `AVProductName`,`avcs`.`ConfigurationId` AS `ConfigurationID`,`avcl`.`SectionName` AS `SectionName`,`avcl`.`ConfigurationName` AS `ConfigurationName`,group_concat(`avcs`.`SettingValue` separator ', ') AS `SettingsValue`,`avcl`.`ConfigurationDescription` AS `ConfigurationDescription` from (`labtech`.`antivirusconfigurationsettings` `avcs` join `labtech`.`antivirusconfigurationlookup` `avcl` on(((`avcs`.`AvPluginGUID` = `avcl`.`AvPluginGUID`) and (`avcs`.`ConfigurationId` = `avcl`.`ConfigurationId`)))) group by `avcs`.`ComputerId`,`avcs`.`AvPluginGUID`,`avcs`.`ConfigurationId`