view.sql

CREATE
    /*[ALGORITHM = {UNDEFINED | MERGE | TEMPTABLE}]
    [DEFINER = { user | CURRENT_USER }]
    [SQL SECURITY { DEFINER | INVOKER }]*/
    VIEW `SalesViewStage`.`followup_notes_seen_ex` 
    AS
(SELECT
  ID,
  ALERT_ID,
  PROJECT_ID,
  PROJECT_ITEM_ID,
  QUOTE_ID,
  CONTACT_ID,
  FOLLOWUP_STATUS,
  NOTE_TYPE,
  NOTE_SEEN
FROM quotes_followup_notes_status_EX
LEFT JOIN quotes_followup_notes_ex
	ON quotes_followup_notes_status_ex.QUOTE_FOLLOWUP_NOTE_ID = quotes_followup_notes_status_ex.ID
	WHERE (`quotes_followup_notes_status_EX`.`NOTE_SEEN` = 1))
	AND QUOTE_FOLLOWUP_NOTES_MODIFIED_DATE <= IN_DATE
	AND QUOTE_FOLLOWUP_NOTES_DELETED_DATE IS NULL
	
	AND MODIFIED_DATE <= IN_dATE
	AND DELETED_DATE IS NULL;