text: CREATE 
      ALGORITHM = UNDEFINED 
      DEFINER = `admin`@`192.168.1.2` 
      SQL SECURITY DEFINER
  VIEW `summon_campaign_servant_schedule_vw` AS
      SELECT 
          `scs`.`id` AS `ID`,
          `sc`.`id` AS `Summon_CampaignID`,
          `scsc`.`id` AS `ScheduleID`,
          `sc`.`eventID` AS `EventID`,
          `scsc`.`startDate` AS `Start_Date`,
          `scsc`.`endDate` AS `End_Date`,
          `s`.`id` AS `ServantID`,
          `s`.`name` AS `Servant`,
          `si`.`image` AS `Image`
      FROM
          (((((`summon_campaign_schedule` `scsc`
          JOIN `summon_campaign_servant` `scs` ON ((`scs`.`summonCampaignScheduleID` = `scsc`.`id`)))
          JOIN `summon_campaign` `sc` ON ((`sc`.`id` = `scs`.`summonCampaignID`)))
          JOIN `servant_image` `si` ON ((`si`.`servantID` = `scs`.`servantID`)))
          JOIN `servant` `s` ON ((`s`.`id` = `scs`.`servantID`)))
          JOIN `class` `c` ON ((`c`.`id` = `s`.`classID`)))
      WHERE
          ((`si`.`imageTypeID` = 1)
              AND (`si`.`imageSubtypeID` = 1)
              AND (`si`.`stage` = 1))
      ORDER BY `sc`.`eventID` , `sc`.`id` , `scsc`.`startDate` , `s`.`star_Level` DESC , `c`.`id` , `s`.`id`