Find Community Impact Circles

select concat('',c.listname,'') as Circle_Name, case when c.Active = 'P' then 's' else Active end as Active, CreateDate as Date__Created, if(ifnull(visible,'') NOT LIKE 'N%', 'Yes','No') as Visible from nccs.userCustomListInfo c where ( (listtype ='I' or listType = 'P') and length(c.ListName)> 0 and Platform = 'nccs' and c.Active ='Yes' and c.Visible LIKE 'Y' ) order by c.listname