CREATE 
    ALGORITHM = UNDEFINED 
    DEFINER = `jitenpatel`@`%` 
    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`.`633` AS `633`,
        `vw_consult_dyn1`.`130` AS `130`,
        `vw_consult_dyn1`.`131` AS `131`,
        `vw_consult_dyn1`.`218` AS `218`,
        `vw_consult_dyn1`.`441` AS `441`,
        `vw_consult_dyn1`.`813` AS `813`,
        `vw_consult_dyn1`.`142` AS `142`,
        `vw_consult_dyn1`.`210` AS `210`,
        `vw_consult_dyn1`.`223` AS `223`,
        `vw_consult_dyn1`.`803` AS `803`,
        `vw_consult_dyn1`.`805` AS `805`,
        `vw_consult_dyn1`.`814` AS `814`,
        `vw_consult_dyn1`.`835` AS `835`,
        `vw_consult_dyn1`.`817` AS `817`,
        `vw_consult_dyn1`.`820` AS `820`,
        `vw_consult_dyn1`.`818` AS `818`,
        `vw_consult_dyn1`.`819` AS `819`,
        `vw_consult_dyn1`.`821` AS `821`,
        `vw_consult_dyn1`.`836` AS `836`,
        `vw_consult_dyn1`.`134` AS `134`,
        `vw_consult_dyn1`.`136` AS `136`,
        `vw_consult_dyn1`.`205` AS `205`,
        `vw_consult_dyn1`.`823` AS `823`,
        `vw_consult_dyn1`.`209` AS `209`,
        `vw_consult_dyn1`.`172` AS `172`,
        `vw_consult_dyn1`.`211` AS `211`,
        `vw_consult_dyn1`.`443` AS `443`,
        `vw_consult_dyn1`.`806` AS `806`,
        `vw_consult_dyn1`.`185` AS `185`,
        `vw_consult_dyn1`.`186` AS `186`,
        `vw_consult_dyn1`.`807` AS `807`,
        `vw_consult_dyn1`.`808` AS `808`,
        `vw_consult_dyn1`.`758` AS `758`,
        `vw_consult_dyn1`.`183` AS `183`,
        `vw_consult_dyn1`.`187` AS `187`,
        `vw_consult_dyn1`.`195` AS `195`,
        `vw_consult_dyn1`.`199` AS `199`,
        `vw_consult_dyn1`.`212` AS `212`,
        IF((0 OR (`vw_consult_dyn1`.`633` > 0)
                OR (`vw_consult_dyn1`.`130` > 0)
                OR (`vw_consult_dyn1`.`131` > 0)
                OR (`vw_consult_dyn1`.`218` > 0)
                OR (`vw_consult_dyn1`.`441` > 0)
                OR (`vw_consult_dyn1`.`813` > 0)),
            0,
            1) AS `129`,
        IF((0 OR (`vw_consult_dyn1`.`142` > 0)
                OR (`vw_consult_dyn1`.`210` > 0)
                OR (`vw_consult_dyn1`.`223` > 0)
                OR (`vw_consult_dyn1`.`803` > 0)
                OR (`vw_consult_dyn1`.`805` > 0)
                OR (`vw_consult_dyn1`.`814` > 0)
                OR (`vw_consult_dyn1`.`835` > 0)),
            0,
            1) AS `137`,
        IF((0 OR (`vw_consult_dyn1`.`817` > 0)
                OR (`vw_consult_dyn1`.`820` > 0)
                OR (`vw_consult_dyn1`.`818` > 0)
                OR (`vw_consult_dyn1`.`819` > 0)
                OR (`vw_consult_dyn1`.`821` > 0)
                OR (`vw_consult_dyn1`.`836` > 0)),
            0,
            1) AS `816`,
        IF((0 OR (`vw_consult_dyn1`.`134` > 0)
                OR (`vw_consult_dyn1`.`136` > 0)
                OR (`vw_consult_dyn1`.`205` > 0)
                OR (`vw_consult_dyn1`.`823` > 0)
                OR (`vw_consult_dyn1`.`209` > 0)),
            0,
            1) AS `133`,
        IF((0 OR (`vw_consult_dyn1`.`172` > 0)
                OR (`vw_consult_dyn1`.`211` > 0)
                OR (`vw_consult_dyn1`.`443` > 0)),
            0,
            1) AS `171`,
        IF((0 OR (`vw_consult_dyn1`.`806` > 0)
                OR (`vw_consult_dyn1`.`185` > 0)
                OR (`vw_consult_dyn1`.`186` > 0)
                OR (`vw_consult_dyn1`.`807` > 0)
                OR (`vw_consult_dyn1`.`808` > 0)
                OR (`vw_consult_dyn1`.`758` > 0)
                OR (`vw_consult_dyn1`.`183` > 0)
                OR (`vw_consult_dyn1`.`187` > 0)
                OR (`vw_consult_dyn1`.`195` > 0)
                OR (`vw_consult_dyn1`.`199` > 0)
                OR (`vw_consult_dyn1`.`212` > 0)),
            0,
            1) AS `182`
    FROM
        `vw_consult_dyn1`