text: CREATE 
      ALGORITHM = UNDEFINED 
      DEFINER = `admin`@`192.168.1.2` 
      SQL SECURITY DEFINER
  VIEW `banner_info_vw` AS
      SELECT 
          `br`.`id` AS `ID`,
          `br`.`bannerID` AS `Banner_ID`,
          `r`.`name` AS `Region`,
          `br`.`name` AS `Name`,
          `br`.`start_date` AS `Start_Date`,
          `br`.`end_date` AS `End_Date`,
          `br`.`image` AS `Image`,
          IF((`r`.`name` = 'en'),
              `br`.`start_date`,
              (`br`.`start_date` + INTERVAL 2 YEAR)) AS `NAStart_Date`,
          IF((`r`.`name` = 'en'),
              `br`.`end_date`,
              (`br`.`end_date` + INTERVAL 2 YEAR)) AS `NAEnd_Date`,
          IF((`r`.`name` = 'en'),
              MONTH(`br`.`start_date`),
              MONTH((`br`.`start_date` + INTERVAL 2 YEAR))) AS `NAStart_Month`,
          IF((`r`.`name` = 'en'),
              YEAR(`br`.`start_date`),
              YEAR((`br`.`start_date` + INTERVAL 2 YEAR))) AS `NAStart_Year`
      FROM
          (`banner_region` `br`
          JOIN `region` `r` ON ((`r`.`id` = `br`.`regionID`)))
      ORDER BY `br`.`name`