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))