Please Log in to join the conversation.
SELECT COUNT( DISTINCT a.`id` )
FROM `jos_comprofiler` AS a
INNER JOIN `jos_users` AS b
ON b.`id` = a.`id`
LEFT JOIN `jos_session` AS c
ON c.`client_id` in (0,1)
AND c.`userid` = a.`id`
LEFT JOIN `jos_user_usergroup_map` AS d
ON d.`user_id` = a.`id`
Please Log in to join the conversation.