1
select `cnt`.`ContactID` AS `ContactID`,`cnt`.`ClientID` AS `ClientID`,`cnt`.`LocationID` AS `LocationID`,concat(`cnt`.`Firstname`,' ',`cnt`.`LastName`) AS `ContactName`,count(`cmp`.`ContactID`) AS `ContactAssetCount`,`cnt`.`Email` AS `ContactEmail`,`cnt`.`Phone` AS `ContactPhone`,`cnt`.`Cell` AS `ContactCell`,concat(`cnt`.`Address1`,if((`cnt`.`Address2` is not null),concat(', ',`cnt`.`Address2`),'')) AS `ContactAddress`,`cnt`.`City` AS `ContactCity`,`cnt`.`State` AS `ContactState`,`cnt`.`Zip` AS `ContactZip`,`cnt`.`Fax` AS `ContactFax`,`cnt`.`Pager` AS `ContactPager`,`cnt`.`MSN` AS `ContactIMMSN`,`cnt`.`AIM` AS `ContactIMAIM`,`cnt`.`ICQ` AS `ContactIMICQ`,`cnt`.`NetBiosName` AS `ContactIMNetBios` from (`labtech`.`contacts` `cnt` left join `labtech`.`computers` `cmp` on((`cnt`.`ContactID` = `cmp`.`ContactID`))) group by `cnt`.`ContactID`