Below for example returns the number of people they've shared their plan with.
Code:
SELECT COUNT(*)
FROM `#__cbsubs_family` AS f
LEFT JOIN `#__cbsubs_subscriptions` AS s
ON s.`id` = f.`sub_id`
WHERE f.`user_id` = '[user_id]'
AND s.`plan_id` = PLAN_ID_HERE
Replace PLAN_ID_HERE with the plan you want to query against. Extend with whatever additional checks you'd like. Example includes joining the subscriptions table. So for example you could join _comprofiler and run the math against your share limit field to return how many shares they have left or whatever you like really.
krileon
