TYPE=VIEW
query=select `nhrc_network`.`organizations`.`id` AS `id`,`nhrc_network`.`organizations`.`name` AS `name`,`nhrc_network`.`organizations`.`eng_name` AS `eng_name`,`nhrc_network`.`organizations`.`short_name` AS `short_name`,`nhrc_network`.`organizations`.`eng_short_name` AS `eng_short_name`,`nhrc_network`.`organizations`.`address1` AS `address1`,`nhrc_network`.`organizations`.`address2` AS `address2`,`nhrc_network`.`organizations`.`postal_code` AS `postal_code`,`nhrc_network`.`organizations`.`telephone1` AS `telephone1`,`nhrc_network`.`organizations`.`telephone2` AS `telephone2`,`nhrc_network`.`organizations`.`telephone3` AS `telephone3`,`nhrc_network`.`organizations`.`fax` AS `fax`,`nhrc_network`.`organizations`.`email` AS `email`,`nhrc_network`.`organizations`.`url` AS `url`,`nhrc_network`.`organizations`.`founded` AS `founded`,`nhrc_network`.`organizations`.`work_level` AS `work_level`,`nhrc_network`.`organizations`.`objective` AS `objective`,`nhrc_network`.`organizations`.`publish` AS `publish`,`nhrc_network`.`organizations`.`is_activated` AS `is_activated`,`nhrc_network`.`organizations`.`role_id` AS `role_id`,`nhrc_network`.`organizations`.`district_id` AS `district_id`,`nhrc_network`.`organizations`.`organization_id` AS `organization_id`,`nhrc_network`.`organizations`.`joined` AS `joined`,`nhrc_network`.`organizations`.`is_nationwide` AS `is_nationwide`,`nhrc_network`.`organizations`.`created` AS `created`,`nhrc_network`.`organizations`.`modified` AS `modified`,`nhrc_network`.`organizations`.`createdby` AS `createdby`,`nhrc_network`.`organizations`.`modifiedby` AS `modifiedby`,NULL AS `JOB_RUN_KEY`,\'ภาคี\' AS `SOURCE_SYSTEM_CODE`,\'organizations\' AS `SOURCE_TABLE_NAME`,\'N\' AS `DELETED_FLAG`,`nhrc_network`.`organizations`.`modified` AS `SOURCE_LAST_UPDATE_DATE_TIME`,now() AS `LAST_UPDATE_DATE_TIME` from `nhrc_network`.`organizations`
md5=1d609830cc04930a9761b5612d2c12ad
updatable=1
algorithm=0
definer_user=bietl
definer_host=%
suid=2
with_check_option=0
timestamp=2018-04-06 12:49:24
create-version=1
source=SELECT `organizations`.`id`,\n    `organizations`.`name`,\n    `organizations`.`eng_name`,\n    `organizations`.`short_name`,\n    `organizations`.`eng_short_name`,\n    `organizations`.`address1`,\n    `organizations`.`address2`,\n		`organizations`.`postal_code`,\n		`organizations`.`telephone1`,\n		`organizations`.`telephone2`,\n		`organizations`.`telephone3`,\n		`organizations`.`fax`,\n		`organizations`.`email`,\n		`organizations`.`url`,\n		`organizations`.`founded`,\n		`organizations`.`work_level`,\n		`organizations`.`objective`,\n		`organizations`.`publish`,\n    `organizations`.`is_activated`,\n		`organizations`.`role_id`,\n    `organizations`.`district_id`,\n		`organizations`.`organization_id`,\n    `organizations`.`joined`,\n    `organizations`.`is_nationwide`,\n    `organizations`.`created`,\n    `organizations`.`modified`,\n    `organizations`.`createdby`,\n    `organizations`.`modifiedby`,\n    NULL AS JOB_RUN_KEY, \n	\'ภาคี\' AS SOURCE_SYSTEM_CODE, \n    \'organizations\' AS SOURCE_TABLE_NAME, \n    \'N\' AS DELETED_FLAG, \n    `organizations`.`modified` AS SOURCE_LAST_UPDATE_DATE_TIME, \n    NOW() AS LAST_UPDATE_DATE_TIME \nFROM `nhrc_network`.`organizations`
client_cs_name=utf8
connection_cl_name=utf8_general_ci
view_body_utf8=select `nhrc_network`.`organizations`.`id` AS `id`,`nhrc_network`.`organizations`.`name` AS `name`,`nhrc_network`.`organizations`.`eng_name` AS `eng_name`,`nhrc_network`.`organizations`.`short_name` AS `short_name`,`nhrc_network`.`organizations`.`eng_short_name` AS `eng_short_name`,`nhrc_network`.`organizations`.`address1` AS `address1`,`nhrc_network`.`organizations`.`address2` AS `address2`,`nhrc_network`.`organizations`.`postal_code` AS `postal_code`,`nhrc_network`.`organizations`.`telephone1` AS `telephone1`,`nhrc_network`.`organizations`.`telephone2` AS `telephone2`,`nhrc_network`.`organizations`.`telephone3` AS `telephone3`,`nhrc_network`.`organizations`.`fax` AS `fax`,`nhrc_network`.`organizations`.`email` AS `email`,`nhrc_network`.`organizations`.`url` AS `url`,`nhrc_network`.`organizations`.`founded` AS `founded`,`nhrc_network`.`organizations`.`work_level` AS `work_level`,`nhrc_network`.`organizations`.`objective` AS `objective`,`nhrc_network`.`organizations`.`publish` AS `publish`,`nhrc_network`.`organizations`.`is_activated` AS `is_activated`,`nhrc_network`.`organizations`.`role_id` AS `role_id`,`nhrc_network`.`organizations`.`district_id` AS `district_id`,`nhrc_network`.`organizations`.`organization_id` AS `organization_id`,`nhrc_network`.`organizations`.`joined` AS `joined`,`nhrc_network`.`organizations`.`is_nationwide` AS `is_nationwide`,`nhrc_network`.`organizations`.`created` AS `created`,`nhrc_network`.`organizations`.`modified` AS `modified`,`nhrc_network`.`organizations`.`createdby` AS `createdby`,`nhrc_network`.`organizations`.`modifiedby` AS `modifiedby`,NULL AS `JOB_RUN_KEY`,\'ภาคี\' AS `SOURCE_SYSTEM_CODE`,\'organizations\' AS `SOURCE_TABLE_NAME`,\'N\' AS `DELETED_FLAG`,`nhrc_network`.`organizations`.`modified` AS `SOURCE_LAST_UPDATE_DATE_TIME`,now() AS `LAST_UPDATE_DATE_TIME` from `nhrc_network`.`organizations`