SELECT count(l.id) as statuscount, d.meta_value, month(`date_created`),year(`date_created`) FROM `rhmn_gf_entry` l LEFT JOIN rhmn_gf_entry_meta d on l.id =d.entry_id WHERE d.form_id =2 and d.meta_key like '113' and month(`date_created`) = '6' and year(`date_created`) ='2024' GROUP by d.meta_value
Jun 2024 Stats
LP Approved
Fit
Unfit
Restricted