CREATE 
    ALGORITHM = UNDEFINED 
    DEFINER = `jitenpatel`@`%` 
    SQL SECURITY DEFINER
VIEW `vw_consult_dyn3` AS
    SELECT 
        `vw_consult_dyn2`.`prosp_consult_id` AS `prosp_consult_id`,
        `vw_consult_dyn2`.`prosp_first_name` AS `prosp_first_name`,
        `vw_consult_dyn2`.`prosp_last_name` AS `prosp_last_name`,
        `vw_consult_dyn2`.`nickname` AS `nickname`,
        `vw_consult_dyn2`.`gender` AS `gender`,
        `vw_consult_dyn2`.`emp_assigned_id` AS `emp_assigned_id`,
        `vw_consult_dyn2`.`mod_call_recv_dt` AS `mod_call_recv_dt`,
        `vw_consult_dyn2`.`call_recv_dt` AS `call_recv_dt`,
        `vw_consult_dyn2`.`mod_next_call_dt` AS `mod_next_call_dt`,
        `vw_consult_dyn2`.`next_call_dt` AS `next_call_dt`,
        `vw_consult_dyn2`.`call_note` AS `call_note`,
        `vw_consult_dyn2`.`prosp_summary` AS `prosp_summary`,
        `vw_consult_dyn2`.`last_updated` AS `last_updated`,
        `vw_consult_dyn2`.`mod_last_updated` AS `mod_last_updated`,
        `vw_consult_dyn2`.`prosp_level` AS `prosp_level`,
        `vw_consult_dyn2`.`prosp_lvl_desc` AS `prosp_lvl_desc`,
        `vw_consult_dyn2`.`contacts` AS `contacts`,
        `vw_consult_dyn2`.`prosp_tag` AS `prosp_tag`,
        `vw_consult_dyn2`.`file_group` AS `file_group`,
        `vw_consult_dyn2`.`633` AS `633`,
        `vw_consult_dyn2`.`130` AS `130`,
        `vw_consult_dyn2`.`131` AS `131`,
        `vw_consult_dyn2`.`218` AS `218`,
        `vw_consult_dyn2`.`441` AS `441`,
        `vw_consult_dyn2`.`813` AS `813`,
        `vw_consult_dyn2`.`142` AS `142`,
        `vw_consult_dyn2`.`210` AS `210`,
        `vw_consult_dyn2`.`223` AS `223`,
        `vw_consult_dyn2`.`803` AS `803`,
        `vw_consult_dyn2`.`805` AS `805`,
        `vw_consult_dyn2`.`814` AS `814`,
        `vw_consult_dyn2`.`835` AS `835`,
        `vw_consult_dyn2`.`817` AS `817`,
        `vw_consult_dyn2`.`820` AS `820`,
        `vw_consult_dyn2`.`818` AS `818`,
        `vw_consult_dyn2`.`819` AS `819`,
        `vw_consult_dyn2`.`821` AS `821`,
        `vw_consult_dyn2`.`836` AS `836`,
        `vw_consult_dyn2`.`134` AS `134`,
        `vw_consult_dyn2`.`136` AS `136`,
        `vw_consult_dyn2`.`205` AS `205`,
        `vw_consult_dyn2`.`823` AS `823`,
        `vw_consult_dyn2`.`209` AS `209`,
        `vw_consult_dyn2`.`172` AS `172`,
        `vw_consult_dyn2`.`211` AS `211`,
        `vw_consult_dyn2`.`443` AS `443`,
        `vw_consult_dyn2`.`806` AS `806`,
        `vw_consult_dyn2`.`185` AS `185`,
        `vw_consult_dyn2`.`186` AS `186`,
        `vw_consult_dyn2`.`807` AS `807`,
        `vw_consult_dyn2`.`808` AS `808`,
        `vw_consult_dyn2`.`758` AS `758`,
        `vw_consult_dyn2`.`183` AS `183`,
        `vw_consult_dyn2`.`187` AS `187`,
        `vw_consult_dyn2`.`195` AS `195`,
        `vw_consult_dyn2`.`199` AS `199`,
        `vw_consult_dyn2`.`212` AS `212`,
        `vw_consult_dyn2`.`129` AS `129`,
        `vw_consult_dyn2`.`137` AS `137`,
        `vw_consult_dyn2`.`816` AS `816`,
        `vw_consult_dyn2`.`133` AS `133`,
        `vw_consult_dyn2`.`171` AS `171`,
        `vw_consult_dyn2`.`182` AS `182`,
        IF((0 OR (`vw_consult_dyn2`.`129` = 1)
                OR (`vw_consult_dyn2`.`137` = 1)
                OR (`vw_consult_dyn2`.`816` = 1)
                OR (`vw_consult_dyn2`.`133` = 1)
                OR (`vw_consult_dyn2`.`171` = 1)
                OR (`vw_consult_dyn2`.`182` = 1)),
            1,
            0) AS `Total_Missing`
    FROM
        `vw_consult_dyn2`
    ORDER BY `vw_consult_dyn2`.`last_updated` DESC