Sunday, 24 March 2013

Joomla 1.5 Getting a list of CCB Forum users names and email

On a Joomla 1.5 setup where they are using the CCB forum I wanted to get a list of Names and email addresses of the forum users. here's the mysql I used for this.
SELECT, FROM `jos_ccb_users` AS jcu LEFT JOIN `jos_users` AS ju ON = jcu.user_id WHERE > 1

No comments: