1
select sql_no_cache `pgp`.`GroupID` AS `GroupID`,`pgp`.`GroupName` AS `GroupName`,ifnull(`mg`.`FullName`,'') AS `FullName`,`pgp`.`Membership` AS `Membership`,`pgp`.`Priority` AS `Priority`,`pgp`.`InstallPolicy` AS `InstallPolicy`,`pgp`.`SoftwarePolicy` AS `SoftwarePolicy`,`pgp`.`RebootPolicy` AS `RebootPolicy`,ifnull(`ip`.`Name`,'Not Set') AS `InstallPolicyName`,ifnull(`sp`.`Name`,'Not Set') AS `SoftwarePolicyName`,ifnull(`rp`.`Name`,'Not Set') AS `RebootPolicyName`,(select count(0) AS `ApprovalPolicies` from `labtech`.`patchgroupapprovalpolicies` `pgap` where (`pgap`.`GroupID` = `pgp`.`GroupID`)) AS `ApprovalPolicies` from ((((`labtech`.`patchgrouppolicies` `pgp` left join `labtech`.`installsoftwarepolicies` `ip` on((`pgp`.`InstallPolicy` = `ip`.`ID`))) left join `labtech`.`installsoftwarepolicies` `sp` on((`pgp`.`SoftwarePolicy` = `sp`.`ID`))) left join `labtech`.`rebootpolicies` `rp` on((`pgp`.`RebootPolicy` = `rp`.`ID`))) left join `labtech`.`mastergroups` `mg` on((`pgp`.`GroupID` = `mg`.`GroupID`))) where (`pgp`.`GroupID` > -(1))