Server IP : 180.180.241.3 / Your IP : 216.73.216.252 Web Server : Microsoft-IIS/7.5 System : Windows NT NETWORK-NHRC 6.1 build 7601 (Windows Server 2008 R2 Standard Edition Service Pack 1) i586 User : IUSR ( 0) PHP Version : 5.3.28 Disable Function : NONE MySQL : ON | cURL : ON | WGET : OFF | Perl : OFF | Python : OFF | Sudo : OFF | Pkexec : OFF Directory : /ProgramData/MySQL/MySQL Server 5.6/data/nhrc_network/ |
Upload File : |
TYPE=VIEW query=select (case when isnull(`nhrc_network`.`people`.`title`) then \'\' else `nhrc_network`.`people`.`title` end) AS `title`,(case when isnull(`nhrc_network`.`people`.`firstname`) then \'\' else `nhrc_network`.`people`.`firstname` end) AS `firstname`,(case when isnull(`nhrc_network`.`people`.`lastname`) then \'\' else `nhrc_network`.`people`.`lastname` end) AS `lastname`,`nhrc_network`.`people`.`is_activated` AS `is_activated`,(case when isnull(`nhrc_network`.`people`.`organization_id`) then 0 else `nhrc_network`.`people`.`organization_id` end) AS `organization_id`,`nhrc_network`.`people`.`joined` AS `joined`,`nhrc_network`.`people`.`district_id` AS `district_id`,`nhrc_network`.`people`.`is_nationwide` AS `is_nationwide`,\'\' AS `JOB_RUN_KEY`,\'ภาคี\' AS `SOURCE_SYSTEM_CODE`,\'people\' AS `SOURCE_TABLE_NAME`,\'N\' AS `DELETED_FLAG`,`nhrc_network`.`people`.`modified` AS `SOURCE_LAST_UPDATE_DATE_TIME`,now() AS `LAST_UPDATE_DATE_TIME` from `nhrc_network`.`people` md5=5beebaf379424a5055fd9ce4939c9626 updatable=1 algorithm=0 definer_user=bietl definer_host=% suid=1 with_check_option=0 timestamp=2018-06-28 18:47:32 create-version=1 source=SELECT \n (CASE\n WHEN ISNULL(`people`.`title`) THEN \'\'\n ELSE `people`.`title`\n END) AS `title`,\n (CASE\n WHEN ISNULL(`people`.`firstname`) THEN \'\'\n ELSE `people`.`firstname`\n END) AS `firstname`,\n (CASE\n WHEN ISNULL(`people`.`lastname`) THEN \'\'\n ELSE `people`.`lastname`\n END) AS `lastname`,\n `people`.`is_activated` AS `is_activated`,\n (CASE\n WHEN ISNULL(`people`.`organization_id`) THEN 0\n ELSE `people`.`organization_id`\n END) AS `organization_id`,\n joined,\n `people`.`district_id` AS `district_id`,\n `people`.`is_nationwide` AS `is_nationwide`,\n \'\' AS `JOB_RUN_KEY`,\n \'ภาคี\' AS `SOURCE_SYSTEM_CODE`,\n \'people\' AS `SOURCE_TABLE_NAME`,\n \'N\' AS `DELETED_FLAG`,\n `people`.`modified` AS `SOURCE_LAST_UPDATE_DATE_TIME`,\n NOW() AS `LAST_UPDATE_DATE_TIME`\n FROM\n `people` client_cs_name=utf8 connection_cl_name=utf8_general_ci view_body_utf8=select (case when isnull(`nhrc_network`.`people`.`title`) then \'\' else `nhrc_network`.`people`.`title` end) AS `title`,(case when isnull(`nhrc_network`.`people`.`firstname`) then \'\' else `nhrc_network`.`people`.`firstname` end) AS `firstname`,(case when isnull(`nhrc_network`.`people`.`lastname`) then \'\' else `nhrc_network`.`people`.`lastname` end) AS `lastname`,`nhrc_network`.`people`.`is_activated` AS `is_activated`,(case when isnull(`nhrc_network`.`people`.`organization_id`) then 0 else `nhrc_network`.`people`.`organization_id` end) AS `organization_id`,`nhrc_network`.`people`.`joined` AS `joined`,`nhrc_network`.`people`.`district_id` AS `district_id`,`nhrc_network`.`people`.`is_nationwide` AS `is_nationwide`,\'\' AS `JOB_RUN_KEY`,\'ภาคี\' AS `SOURCE_SYSTEM_CODE`,\'people\' AS `SOURCE_TABLE_NAME`,\'N\' AS `DELETED_FLAG`,`nhrc_network`.`people`.`modified` AS `SOURCE_LAST_UPDATE_DATE_TIME`,now() AS `LAST_UPDATE_DATE_TIME` from `nhrc_network`.`people`