You need to join other tables into your query if you want more information like that. So for example if you the subscription information and the users username then you need to join the _users table which contains the username. Example as follows.
Code:
SELECT u.`username`, s.*
FROM `jos_cbsubs_subscriptions` AS s
LEFT JOIN `jos_users` AS u
ON u.`id` = s.`user_id`
If you need access to CB field data then you need to also join CBs _comprofiler table. Example as follows.
Code:
SELECT u.`username`, c.`firstname`, s.*
FROM `jos_cbsubs_subscriptions` AS s
LEFT JOIN `jos_users` AS u
ON u.`id` = s.`user_id`
LEFT JOIN `jos_comprofiler` AS c
ON c.`id` = s.`user_id`
Replace jos_ with whatever your database table prefix is.
krileon
