CREATE 
    ALGORITHM = UNDEFINED 
    DEFINER = `aerion`@`localhost` 
    SQL SECURITY DEFINER
VIEW `vw_immi_usage2` AS
    SELECT 
        `vw_immi_legal`.`receipt_id` AS `receipt_id`,
        `vw_immi_legal`.`receipt_type` AS `receipt_type`,
        `vw_immi_legal`.`filed_dt` AS `filed_dt`,
        `vw_immi_legal`.`filed_dt_m` AS `filed_dt_m`,
        `vw_immi_legal`.`filed_dt_y` AS `filed_dt_y`,
        `vw_immi_legal`.`expire_dt_new` AS `expire_dt_new`,
        `vw_immi_legal`.`expire_diff` AS `expire_diff`,
        `vw_immi_legal`.`from_dt` AS `from_dt`,
        `vw_immi_legal`.`to_dt` AS `to_dt`,
        `vw_immi_legal`.`validity` AS `validity`,
        `vw_immi_legal`.`valid_days` AS `valid_days`,
        `vw_immi_legal`.`expire_dt` AS `expire_dt`,
        `vw_immi_legal`.`look_street_no_id` AS `look_street_no_id`,
        `vw_immi_legal`.`suite_no` AS `suite_no`,
        `vw_immi_legal`.`stat_st_dt` AS `stat_st_dt`,
        `vw_immi_legal`.`stat_e_dt` AS `stat_e_dt`,
        `vw_immi_legal`.`no_days` AS `no_days`,
        `vw_immi_legal`.`rec_status` AS `rec_status`,
        `vw_immi_legal`.`immi_summary` AS `immi_summary`,
        `vw_immi_legal`.`reftable` AS `reftable`,
        `vw_immi_legal`.`emp_id` AS `emp_id`,
        `vw_immi_legal`.`comp_id` AS `comp_id`,
        `vw_immi_legal`.`receipt_no` AS `receipt_no`,
        `vw_immi_legal`.`ad` AS `ad`,
        `vw_immi_legal`.`imi_source` AS `imi_source`,
        `vw_immi_legal`.`combo` AS `combo`,
        `vw_immi_legal`.`status` AS `status`,
        `vw_immi_legal`.`company` AS `company`,
        `vw_immi_legal`.`typst` AS `typst`,
        `vw_immi_legal`.`name` AS `name`
    FROM
        `vw_immi_legal`
    WHERE
        (NOT (`vw_immi_legal`.`receipt_id` IN (SELECT DISTINCT
                `immi_recpt_parent`.`receipt_parent_id` AS `receipt_parent_id`
            FROM
                `immi_recpt_parent`)))