The query is ok. The field shows fine when the module shows on page... index.php?option=com_comprofiler&view=pluginclass&plugin=cbactivity&action=recentactivity
Here is the query...
Code:
[code]SELECT
(SELECT COUNT(DISTINCT session_id) FROM #__session WHERE guest = 0) AS guest_0_count,
(SELECT COUNT(DISTINCT session_id) FROM #__session WHERE guest = 1) AS guest_1_count,
((SELECT COUNT(DISTINCT s.session_id)
FROM #__session s
JOIN #__cbsubs_subscriptions sub ON s.userid = sub.user_id
WHERE s.guest = 0 AND sub.status = 'A') - 1) AS total_matching_count;
[/code]
krileon
