SELECT DISTINCT CONCAT( "/", demo.demographic_no, "/" ) AS "DemoLink", If(GROUP_CONCAT(billing_date) like CONCAT("%",YEAR(NOW()),"%"),"","TBD") as "TBD", If(GROUP_CONCAT(billing_date) like CONCAT("%",YEAR(NOW()),"%"),"",CONCAT("",CONCAT(demo.last_name,", ",demo.first_name),"")) AS "TBD THIS YEAR", demo.last_name"Complex",demo.first_name"Care", GROUP_CONCAT(" ",(If(year(billing_date)",billing_date,""),CONCAT("",billing_date,"")))) AS "BILLED" FROM billing b, billingmaster bm, demographic demo WHERE (b.billing_no = bm.billing_no and demo.demographic_no = b.demographic_no and (bm.billing_code = '14033' or bm.billing_code = '14075') and demo.patient_status = 'AC' and demo.roster_status <> 'Private billings') GROUP by CONCAT(demo.last_name,demo.first_name)