select t1.id,t1.name,t1.id as bugID,t2.resolution from TABLE_PROJECT as t1 left join TABLE_BUG as t2 on t1.id=t2.project where t1.deleted='0' and t2.deleted='0' and t2.resolution!='' having bugID!=''