CREATE 
    ALGORITHM = UNDEFINED 
    DEFINER = `aerion`@`localhost` 
    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`.`258` AS `258`,
        `vw_consult_dyn2`.`1358` AS `1358`,
        `vw_consult_dyn2`.`1369` AS `1369`,
        `vw_consult_dyn2`.`1666` AS `1666`,
        `vw_consult_dyn2`.`259` AS `259`,
        `vw_consult_dyn2`.`67` AS `67`,
        `vw_consult_dyn2`.`1707` AS `1707`,
        `vw_consult_dyn2`.`262` AS `262`,
        `vw_consult_dyn2`.`263` AS `263`,
        `vw_consult_dyn2`.`1022` AS `1022`,
        `vw_consult_dyn2`.`260` AS `260`,
        `vw_consult_dyn2`.`261` AS `261`,
        `vw_consult_dyn2`.`289` AS `289`,
        `vw_consult_dyn2`.`290` AS `290`,
        `vw_consult_dyn2`.`291` AS `291`,
        `vw_consult_dyn2`.`293` AS `293`,
        `vw_consult_dyn2`.`297` AS `297`,
        `vw_consult_dyn2`.`1405` AS `1405`,
        `vw_consult_dyn2`.`255` AS `255`,
        `vw_consult_dyn2`.`256` AS `256`,
        `vw_consult_dyn2`.`295` AS `295`,
        `vw_consult_dyn2`.`296` AS `296`,
        `vw_consult_dyn2`.`975` AS `975`,
        `vw_consult_dyn2`.`974` AS `974`,
        `vw_consult_dyn2`.`973` AS `973`,
        `vw_consult_dyn2`.`1417` AS `1417`,
        `vw_consult_dyn2`.`1418` AS `1418`,
        `vw_consult_dyn2`.`1678` AS `1678`,
        `vw_consult_dyn2`.`1680` AS `1680`,
        `vw_consult_dyn2`.`1706` AS `1706`,
        `vw_consult_dyn2`.`1682` AS `1682`,
        `vw_consult_dyn2`.`1684` AS `1684`,
        `vw_consult_dyn2`.`1686` AS `1686`,
        `vw_consult_dyn2`.`1687` AS `1687`,
        `vw_consult_dyn2`.`1688` AS `1688`,
        `vw_consult_dyn2`.`121` AS `121`,
        `vw_consult_dyn2`.`3` AS `3`,
        `vw_consult_dyn2`.`32` AS `32`,
        `vw_consult_dyn2`.`33` AS `33`,
        `vw_consult_dyn2`.`288` AS `288`,
        `vw_consult_dyn2`.`253` AS `253`,
        `vw_consult_dyn2`.`294` AS `294`,
        `vw_consult_dyn2`.`972` AS `972`,
        `vw_consult_dyn2`.`1416` AS `1416`,
        `vw_consult_dyn2`.`1677` AS `1677`,
        `vw_consult_dyn2`.`1681` AS `1681`,
        `vw_consult_dyn2`.`1685` AS `1685`,
        IF((0 OR (`vw_consult_dyn2`.`121` = 1)
                OR (`vw_consult_dyn2`.`3` = 1)
                OR (`vw_consult_dyn2`.`32` = 1)
                OR (`vw_consult_dyn2`.`33` = 1)
                OR (`vw_consult_dyn2`.`288` = 1)
                OR (`vw_consult_dyn2`.`253` = 1)
                OR (`vw_consult_dyn2`.`294` = 1)
                OR (`vw_consult_dyn2`.`972` = 1)
                OR (`vw_consult_dyn2`.`1416` = 1)
                OR (`vw_consult_dyn2`.`1677` = 1)
                OR (`vw_consult_dyn2`.`1681` = 1)
                OR (`vw_consult_dyn2`.`1685` = 1)),
            1,
            0) AS `Total_Missing`
    FROM
        `vw_consult_dyn2`
    ORDER BY `vw_consult_dyn2`.`last_updated` DESC