select a.MenuId,b.name as menuName,a.AnnotatetypeID,NoteId,a.asid,count(1) as num from dl_cookMode a left outer join dl_menu b on a.menuId=b.id group by a.MenuId,b.name,a.AnnotatetypeID,NoteId,a.asid having count(1)>1