CREATE 
    ALGORITHM = UNDEFINED 
    DEFINER = `jitenpatel`@`%` 
    SQL SECURITY DEFINER
VIEW `aerion_master`.`vw_cnslt_conversion_table` AS
    SELECT 
        `b`.`table_name` AS `table_name`,
        `a`.`prosp_consult_id` AS `prosp_consult_id`,
        `a`.`prosp_first_name` AS `prosp_first_name`,
        `a`.`prosp_last_name` AS `prosp_last_name`,
        `a`.`nickname` AS `nickname`,
        `a`.`gender` AS `gender`,
        `a`.`emp_assigned_id` AS `emp_assigned_id`,
        `a`.`mod_call_recv_dt` AS `mod_call_recv_dt`,
        `a`.`call_recv_dt` AS `call_recv_dt`,
        `a`.`mod_next_call_dt` AS `mod_next_call_dt`,
        `a`.`next_call_dt` AS `next_call_dt`,
        `a`.`call_note` AS `call_note`,
        `a`.`prosp_summary` AS `prosp_summary`,
        `a`.`last_updated` AS `last_updated`,
        `a`.`mod_last_updated` AS `mod_last_updated`,
        `a`.`prosp_level` AS `prosp_level`,
        `a`.`prosp_lvl_desc` AS `prosp_lvl_desc`,
        `a`.`contacts` AS `contacts`,
        `a`.`prosp_tag` AS `prosp_tag`,
        `a`.`file_group` AS `file_group`,
        `a`.`258` AS `258`,
        `a`.`1358` AS `1358`,
        `a`.`1369` AS `1369`,
        `a`.`1666` AS `1666`,
        `a`.`259` AS `259`,
        `a`.`67` AS `67`,
        `a`.`1707` AS `1707`,
        `a`.`262` AS `262`,
        `a`.`263` AS `263`,
        `a`.`1022` AS `1022`,
        `a`.`260` AS `260`,
        `a`.`261` AS `261`,
        `a`.`289` AS `289`,
        `a`.`290` AS `290`,
        `a`.`291` AS `291`,
        `a`.`293` AS `293`,
        `a`.`297` AS `297`,
        `a`.`1405` AS `1405`,
        `a`.`255` AS `255`,
        `a`.`256` AS `256`,
        `a`.`295` AS `295`,
        `a`.`296` AS `296`,
        `a`.`975` AS `975`,
        `a`.`974` AS `974`,
        `a`.`973` AS `973`,
        `a`.`1417` AS `1417`,
        `a`.`1418` AS `1418`,
        `a`.`1678` AS `1678`,
        `a`.`1680` AS `1680`,
        `a`.`1706` AS `1706`,
        `a`.`1682` AS `1682`,
        `a`.`1684` AS `1684`,
        `a`.`1686` AS `1686`,
        `a`.`1687` AS `1687`,
        `a`.`1688` AS `1688`,
        `a`.`121` AS `121`,
        `a`.`3` AS `3`,
        `a`.`32` AS `32`,
        `a`.`33` AS `33`,
        `a`.`288` AS `288`,
        `a`.`253` AS `253`,
        `a`.`294` AS `294`,
        `a`.`972` AS `972`,
        `a`.`1416` AS `1416`,
        `a`.`1677` AS `1677`,
        `a`.`1681` AS `1681`,
        `a`.`1685` AS `1685`,
        `a`.`Total_Missing` AS `Total_Missing`
    FROM
        (`aerion_master`.`prosp_consult_merger` `a`
        LEFT JOIN `aerion_master`.`vw_cnslt_con_2` `b` ON ((`a`.`prosp_consult_id` = `b`.`consult_id`)))