select OperatingEmName,COUNT(OperatingEmName)
 from Base_SystemSecurity 
 where 
 (OperatingIP like '%iPhone%'
 or OperatingIP like '%Android%')
 and exists(select 1 from Base_Users where companyID!=19 and Base_Users.UserID=Base_SystemSecurity.UserID)

 group by OperatingEmName