select distinct isa.site_id as siteId, sb.site_name as siteName, isf.id as id, isad.type_id as typeId, ist.type_name as typeName, isf.create_user_id as commitUserId, isad.content_item_id as contentItemId, u.user_phone as commitTelephone, case when isad.content_item_id IS NOT NULL THEN isci.item_name when isad.content_item_id IS NULL THEN isad.other_item_name end as contentItemName from table