SELECT a.`demographic_no`,`last_name`,`first_name`,`phone`,`provider_no` , COUNT( DISTINCT ( `DESCRIPTION` ) ) AS c, CONCAT( "/", d.demographic_no, "/" ) AS "DemoLink", CONCAT( "", "eChart", "" ) AS "eChart" FROM `allergies` a, `demographic` d WHERE a.`demographic_no`=d.`demographic_no` AND `patient_status`="AC" AND a.`demographic_no` IN ( SELECT `demographic_no` FROM `allergies` WHERE `DESCRIPTION` = "PENICILLINS" ) GROUP BY `demographic_no` ORDER BY c DESC;