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`