1
select `md`.`MobileID` AS `MobileID`,group_concat(distinct `mcc`.`Name` separator ',') AS `ConfigClasses`,group_concat(distinct `mmg`.`Name` separator ',') AS `MobileGroups` from (((`labtech`.`mobiledevices` `md` join `labtech`.`mobilesubgroups` `msg` on((`md`.`MobileID` = `msg`.`MobileID`))) join `labtech`.`mobilemastergroups` `mmg` on((`msg`.`GroupID` = `mmg`.`GroupID`))) left join `labtech`.`mobileconfigclass` `mcc` on((find_in_set(`mcc`.`MobileConfigID`,concat((select `mdi`.`ConfigClasses` from `labtech`.`mobiledeviceinfo` `mdi` where (`mdi`.`MobileID` = `md`.`MobileID`) limit 1),`mmg`.`ConfigClasses`)) > 0))) group by `md`.`MobileID`