CREATE 
    ALGORITHM = UNDEFINED 
    DEFINER = `ATS`@`localhost` 
    SQL SECURITY DEFINER
VIEW `ATS`.`vw_rpt_all_data_process_2` AS
    SELECT 
        `vw_dev_est_reqs_status`.`iddev_est_reqs` AS `iddev_est_reqs`,
        COUNT(0) AS `status_count`,
        GROUP_CONCAT(IFNULL(`vw_dev_est_reqs_status`.`status`,
                    _LATIN1' ')
            ORDER BY `vw_dev_est_reqs_status`.`iddev_est_reqs_status` ASC
            SEPARATOR '-->') AS `status_list`,
        SUBSTRING_INDEX(SUBSTRING_INDEX(GROUP_CONCAT(`vw_dev_est_reqs_status`.`assigned_to`
                            SEPARATOR ','),
                        _LATIN1',',
                        1),
                _LATIN1',',
                -(1)) AS `req_developer`,
        IF(((LENGTH(GROUP_CONCAT(`vw_dev_est_reqs_status`.`assigned_to`
                        SEPARATOR ',')) - LENGTH(REPLACE(GROUP_CONCAT(`vw_dev_est_reqs_status`.`assigned_to`
                            SEPARATOR ','),
                        _LATIN1',',
                        _LATIN1''))) >= 1),
            SUBSTRING_INDEX(SUBSTRING_INDEX(GROUP_CONCAT(`vw_dev_est_reqs_status`.`assigned_to`
                                SEPARATOR ','),
                            _LATIN1',',
                            2),
                    _LATIN1',',
                    -(1)),
            NULL) AS `rpt_req_analyst`
    FROM
        `ATS`.`vw_dev_est_reqs_status`
    GROUP BY `vw_dev_est_reqs_status`.`iddev_est_reqs`