SELECT DISTINCT tab_comment.comid, tab_comment.comment, tab_comment.seq, tab_comment.updated_last, tab_comment.rowguid FROM tab_comment (NOLOCK) JOIN tab_roll_drawings (NOLOCK) ON (tab_comment.comid = tab_roll_drawings.comid OR tab_comment.comid = tab_roll_drawings.special_comid OR tab_comment.comid = tab_roll_drawings.bear_comid OR tab_comment.comid = tab_roll_drawings.bolt_circle_comid) JOIN tab_cu_press_information (NOLOCK) ON (tab_roll_drawings.roll_drawing_number = tab_cu_press_information.roll_drawing_number OR tab_roll_drawings.roll_drawing_number = tab_cu_press_information.plate_roll_number OR tab_roll_drawings.roll_drawing_number = tab_cu_press_information.anvil_roll_number) JOIN vue_die_composite (NOLOCK) ON tab_cu_press_information.counter = vue_die_composite.press_counter AND frm_type IN('FCS', 'FCS-RT') WHERE (tab_comment.updated_last >= @LAST_SYNC OR vue_die_composite.updated_last >= @LAST_SYNC OR tab_comment.rowguid IN(SELECT guid FROM #TEMP))