select tEzai.c_tEzai_orgid as orgid, 
       tEzai.c_tEzai_tktype as tokenid, 
       tokentext as tokentype,
       count(distinct c_tEzai_sno) as total,
       count(distinct c_tEztkbind_sno) as consumed, 
       (count(distinct c_tEzai_sno) - count(distinct c_tEztkbind_sno)) as free 
from tokentext LEFT JOIN tEzai ON tokenid = c_tEzai_tktype 
               LEFT JOIN tEztkbind ON tokenid = c_tEztkbind_tktype 
where c_tEzai_orgid = 1 and c_tEztkbind_orgid = 1 
group by tokentext order by tokenid;