SELECT COUNT(sub.user_id) AS subscribers, plan.title FROM xiszt_payplans_subscription sub LEFT JOIN xiszt_payplans_plan plan ON plan.plan_id = sub.plan_id WHERE sub.STATUS = 1601 GROUP BY sub.plan_id;
SELECT COUNT(sub.user_id) AS subscribers, plan.title FROM xiszt_payplans_subscription sub LEFT JOIN xiszt_payplans_plan plan ON plan.plan_id = sub.plan_id WHERE sub.STATUS = 1601 GROUP BY sub.plan_id;
Comments