text: CREATE 
      ALGORITHM = UNDEFINED 
      DEFINER = `admin`@`192.168.1.2` 
      SQL SECURITY DEFINER
  VIEW `event_vw` AS
      SELECT 
          `e`.`id` AS `ID`,
          `e`.`bannerRegionID` AS `Banner_RegionID`,
          `et`.`name` AS `Type`,
          `e`.`name` AS `Name`,
          `sc`.`image` AS `Image`
      FROM
          ((`event` `e`
          JOIN `event_type` `et` ON ((`et`.`id` = `e`.`eventTypeID`)))
          LEFT JOIN `summon_campaign` `sc` ON ((`sc`.`eventID` = `e`.`id`)))
      ORDER BY `e`.`bannerRegionID` , `et`.`sortOrder` , `e`.`id`