CREATE 
    ALGORITHM = UNDEFINED 
    DEFINER = `aerion`@`localhost` 
    SQL SECURITY DEFINER
VIEW `vw_immi_receipt2` AS
    SELECT 
        `a`.`status_id` AS `status_id`,
        `a`.`receipt_id` AS `receipt_id`,
        `a`.`rec_status` AS `rec_status`,
        `a`.`stat_dt_dt` AS `stat_dt_dt`,
        `a`.`stat_e_dt` AS `stat_e_dt`,
        `a`.`no_days` AS `no_days`,
        `a`.`idlook_stat_order` AS `idlook_stat_order`,
        `b`.`receipt_id` AS `receipt_id2`,
        `b`.`receipt_type` AS `receipt_type`,
        `b`.`filed_dt` AS `filed_dt`,
        `b`.`filed_dt_m` AS `filed_dt_m`,
        `b`.`filed_dt_y` AS `filed_dt_y`,
        `b`.`expire_dt_new` AS `expire_dt_new`,
        `b`.`expire_diff` AS `expire_diff`,
        `b`.`from_dt` AS `from_dt`,
        `b`.`to_dt` AS `to_dt`,
        `b`.`validity` AS `validity`,
        `b`.`valid_days` AS `valid_days`,
        `b`.`expire_dt` AS `expire_dt`,
        `b`.`look_street_no_id` AS `look_street_no_id`,
        `b`.`suite_no` AS `suite_no`,
        `b`.`stat_st_dt` AS `stat_st_dt`,
        `b`.`stat_e_dt` AS `stat_e_dt2`,
        `b`.`no_days` AS `no_days2`,
        `b`.`rec_status` AS `rec_status2`,
        `b`.`immi_summary` AS `immi_summary`,
        `b`.`reftable` AS `reftable`,
        `b`.`emp_id` AS `emp_id`,
        `b`.`comp_id` AS `comp_id`,
        `b`.`receipt_no` AS `receipt_no`,
        `b`.`ad` AS `ad`,
        `b`.`imi_source` AS `imi_source`,
        `b`.`combo` AS `combo`,
        `c`.`look_values` AS `status`,
        `b`.`company` AS `company`,
        `b`.`typst` AS `typst`,
        `b`.`name` AS `name`
    FROM
        ((`immi_status` `a`
        LEFT JOIN `look_values` `c` ON ((`a`.`rec_status` = `c`.`look_values_id`)))
        LEFT JOIN `vw_immi_legal` `b` ON ((`a`.`receipt_id` = `b`.`receipt_id`)))