CREATE 
    ALGORITHM = UNDEFINED 
    DEFINER = `aerion`@`localhost` 
    SQL SECURITY DEFINER
VIEW `vw_consult_dyn2` AS
    SELECT 
        `vw_consult_dyn1`.`prosp_consult_id` AS `prosp_consult_id`,
        `vw_consult_dyn1`.`prosp_first_name` AS `prosp_first_name`,
        `vw_consult_dyn1`.`prosp_last_name` AS `prosp_last_name`,
        `vw_consult_dyn1`.`nickname` AS `nickname`,
        `vw_consult_dyn1`.`gender` AS `gender`,
        `vw_consult_dyn1`.`emp_assigned_id` AS `emp_assigned_id`,
        `vw_consult_dyn1`.`mod_call_recv_dt` AS `mod_call_recv_dt`,
        `vw_consult_dyn1`.`call_recv_dt` AS `call_recv_dt`,
        `vw_consult_dyn1`.`mod_next_call_dt` AS `mod_next_call_dt`,
        `vw_consult_dyn1`.`next_call_dt` AS `next_call_dt`,
        `vw_consult_dyn1`.`call_note` AS `call_note`,
        `vw_consult_dyn1`.`prosp_summary` AS `prosp_summary`,
        `vw_consult_dyn1`.`last_updated` AS `last_updated`,
        `vw_consult_dyn1`.`mod_last_updated` AS `mod_last_updated`,
        `vw_consult_dyn1`.`prosp_level` AS `prosp_level`,
        `vw_consult_dyn1`.`prosp_lvl_desc` AS `prosp_lvl_desc`,
        `vw_consult_dyn1`.`contacts` AS `contacts`,
        `vw_consult_dyn1`.`prosp_tag` AS `prosp_tag`,
        `vw_consult_dyn1`.`file_group` AS `file_group`,
        `vw_consult_dyn1`.`258` AS `258`,
        `vw_consult_dyn1`.`1358` AS `1358`,
        `vw_consult_dyn1`.`1369` AS `1369`,
        `vw_consult_dyn1`.`1666` AS `1666`,
        `vw_consult_dyn1`.`259` AS `259`,
        `vw_consult_dyn1`.`67` AS `67`,
        `vw_consult_dyn1`.`1707` AS `1707`,
        `vw_consult_dyn1`.`262` AS `262`,
        `vw_consult_dyn1`.`263` AS `263`,
        `vw_consult_dyn1`.`1022` AS `1022`,
        `vw_consult_dyn1`.`260` AS `260`,
        `vw_consult_dyn1`.`261` AS `261`,
        `vw_consult_dyn1`.`289` AS `289`,
        `vw_consult_dyn1`.`290` AS `290`,
        `vw_consult_dyn1`.`291` AS `291`,
        `vw_consult_dyn1`.`293` AS `293`,
        `vw_consult_dyn1`.`297` AS `297`,
        `vw_consult_dyn1`.`1405` AS `1405`,
        `vw_consult_dyn1`.`255` AS `255`,
        `vw_consult_dyn1`.`256` AS `256`,
        `vw_consult_dyn1`.`295` AS `295`,
        `vw_consult_dyn1`.`296` AS `296`,
        `vw_consult_dyn1`.`975` AS `975`,
        `vw_consult_dyn1`.`974` AS `974`,
        `vw_consult_dyn1`.`973` AS `973`,
        `vw_consult_dyn1`.`1417` AS `1417`,
        `vw_consult_dyn1`.`1418` AS `1418`,
        `vw_consult_dyn1`.`1678` AS `1678`,
        `vw_consult_dyn1`.`1680` AS `1680`,
        `vw_consult_dyn1`.`1706` AS `1706`,
        `vw_consult_dyn1`.`1682` AS `1682`,
        `vw_consult_dyn1`.`1684` AS `1684`,
        `vw_consult_dyn1`.`1686` AS `1686`,
        `vw_consult_dyn1`.`1687` AS `1687`,
        `vw_consult_dyn1`.`1688` AS `1688`,
        IF((0 OR (`vw_consult_dyn1`.`258` > 0)
                OR (`vw_consult_dyn1`.`1358` > 0)
                OR (`vw_consult_dyn1`.`1369` > 0)
                OR (`vw_consult_dyn1`.`1666` > 0)),
            0,
            1) AS `121`,
        IF((0 OR (`vw_consult_dyn1`.`259` > 0)
                OR (`vw_consult_dyn1`.`67` > 0)
                OR (`vw_consult_dyn1`.`1707` > 0)),
            0,
            1) AS `3`,
        IF((0 OR (`vw_consult_dyn1`.`262` > 0)
                OR (`vw_consult_dyn1`.`263` > 0)
                OR (`vw_consult_dyn1`.`1022` > 0)),
            0,
            1) AS `32`,
        IF((0 OR (`vw_consult_dyn1`.`260` > 0)
                OR (`vw_consult_dyn1`.`261` > 0)),
            0,
            1) AS `33`,
        IF((0 OR (`vw_consult_dyn1`.`289` > 0)
                OR (`vw_consult_dyn1`.`290` > 0)
                OR (`vw_consult_dyn1`.`291` > 0)
                OR (`vw_consult_dyn1`.`293` > 0)
                OR (`vw_consult_dyn1`.`297` > 0)
                OR (`vw_consult_dyn1`.`1405` > 0)),
            0,
            1) AS `288`,
        IF((0 OR (`vw_consult_dyn1`.`255` > 0)
                OR (`vw_consult_dyn1`.`256` > 0)),
            0,
            1) AS `253`,
        IF((0 OR (`vw_consult_dyn1`.`295` > 0)
                OR (`vw_consult_dyn1`.`296` > 0)),
            0,
            1) AS `294`,
        IF((0 OR (`vw_consult_dyn1`.`975` > 0)
                OR (`vw_consult_dyn1`.`974` > 0)
                OR (`vw_consult_dyn1`.`973` > 0)),
            0,
            1) AS `972`,
        IF((0 OR (`vw_consult_dyn1`.`1417` > 0)
                OR (`vw_consult_dyn1`.`1418` > 0)),
            0,
            1) AS `1416`,
        IF((0 OR (`vw_consult_dyn1`.`1678` > 0)
                OR (`vw_consult_dyn1`.`1680` > 0)
                OR (`vw_consult_dyn1`.`1706` > 0)),
            0,
            1) AS `1677`,
        IF((0 OR (`vw_consult_dyn1`.`1682` > 0)
                OR (`vw_consult_dyn1`.`1684` > 0)),
            0,
            1) AS `1681`,
        IF((0 OR (`vw_consult_dyn1`.`1686` > 0)
                OR (`vw_consult_dyn1`.`1687` > 0)
                OR (`vw_consult_dyn1`.`1688` > 0)),
            0,
            1) AS `1685`
    FROM
        `vw_consult_dyn1`