Users

Id Login User Nm User Fk User Type Password Mail Address 1 Mail Address 2 Login Rock Flg Last Login Day Use Start Day Use End Day Del Flg Init Pass Flg Created Insert User Modified Update User Actions
AG00000000  00000000  T佐藤トヨ  さとうとよ  01  545d791e435fb1f7966d84362bc6cd3d77f6b07c      2025-03-06 08:47:32  2016-07-01 00:00:00  2030-07-31 00:00:00  2016-08-22 11:34:46  MG00000001  2021-02-24 10:01:24  AG00000000  View Edit Delete
AG01000001  01000001  T佐藤 野菜  さとうやさい  01  8f14cf117c8a77a294a63f30d72fe4b94f945c5f      2023-05-19 16:33:40  2016-07-01 00:00:00  2030-07-31 00:00:00  2016-08-30 12:23:16  MG00000001  2021-07-28 14:59:06  MG00000001  View Edit Delete
AG01000335  01000335  T上田伊佐男  うえだいさお  01  128daf96fd3b3f779b1dc0104b938fd122025e35  coccodaisukidesu@yahoo.co.jp    2022-01-24 15:55:45  2016-08-29 00:00:00    2016-08-30 12:23:18  MG00000001  2022-06-01 11:05:04  MG00000001  View Edit Delete
AG01000611  01000611  T梨子本マミ子  なしもとまみこ  01  893228bb2581960aa3cc2d5bbdcc86c00b4614a4      2023-05-02 13:57:16  2016-08-29 00:00:00    2016-08-30 12:23:20  MG00000001  2017-08-03 17:31:18  MG00000002  View Edit Delete
AG01000643  01000643  Tマルミヤ農園  まるみやのうえん  01  8f14cf117c8a77a294a63f30d72fe4b94f945c5f      2017-07-07 10:28:01  2016-08-29 00:00:00    2016-08-30 12:23:20  MG00000001  2017-03-17 17:37:14  MG00000001  View Edit Delete
AG01000675  01000675  T梨子本晃士  なしもとこうじ  01  893228bb2581960aa3cc2d5bbdcc86c00b4614a4      2017-09-08 13:55:16  2016-08-29 00:00:00    2016-08-30 12:23:21  MG00000001  2017-08-03 17:31:41  MG00000002  View Edit Delete
AG01000677  01000677  T鵜山久雄  うやまひさお  01  893228bb2581960aa3cc2d5bbdcc86c00b4614a4      2017-08-02 14:32:51  2016-08-29 00:00:00    2016-08-30 12:23:21  MG00000001  2017-07-27 11:24:56  MG00000001  View Edit Delete
AG01000683  01000683  T吉井康  よしいやすし  01  893228bb2581960aa3cc2d5bbdcc86c00b4614a4      2017-09-08 13:54:37  2016-08-29 00:00:00    2016-08-30 12:23:21  MG00000001  2017-08-03 17:33:28  MG00000002  View Edit Delete
AG01000684  01000684  T吉村孝雄  よしむらたかお  01  893228bb2581960aa3cc2d5bbdcc86c00b4614a4      2017-09-17 21:47:18  2016-08-29 00:00:00    2016-08-30 12:23:21  MG00000001  2017-07-27 18:48:54  MG00000001  View Edit Delete
AG01000685  01000685  T吉村俊幸  よしむらとしゆき  01  893228bb2581960aa3cc2d5bbdcc86c00b4614a4      2017-09-02 09:56:04  2016-08-29 00:00:00    2016-08-30 12:23:21  MG00000001  2017-07-27 19:06:36  MG00000001  View Edit Delete
AG01000692  01000692  T寺田佳史  てらだよしふみ  01  893228bb2581960aa3cc2d5bbdcc86c00b4614a4      2017-08-01 14:28:28  2016-08-29 00:00:00    2016-08-30 12:23:21  MG00000001  2017-08-03 17:34:21  MG00000002  View Edit Delete
AG01000693  01000693  T寺田勉  てらだつとむ  01  893228bb2581960aa3cc2d5bbdcc86c00b4614a4      2017-09-08 13:57:20  2016-08-29 00:00:00    2016-08-30 12:23:21  MG00000001  2017-07-28 10:06:03  MG00000001  View Edit Delete
AG01000695  01000695  T上田美加子  うえだみかこ  01  893228bb2581960aa3cc2d5bbdcc86c00b4614a4      2017-09-08 14:02:26  2016-08-29 00:00:00    2016-08-30 12:23:21  MG00000001  2017-07-28 10:26:04  MG00000001  View Edit Delete
AG01000699  01000699  T森本輝雄  もりもとみつお  01  893228bb2581960aa3cc2d5bbdcc86c00b4614a4      2017-09-08 14:01:07  2016-08-29 00:00:00    2016-08-30 12:23:21  MG00000001  2017-07-28 10:35:53  MG00000001  View Edit Delete
AG01000700  01000700  T西藪勝彦  にしやぶかつひこ  01  893228bb2581960aa3cc2d5bbdcc86c00b4614a4      2017-07-31 12:46:13  2016-08-29 00:00:00    2016-08-30 12:23:21  MG00000001  2017-07-28 10:39:43  MG00000001  View Edit Delete
AG01000701  01000701  T川本晃顯  かわもとてるあき  01  893228bb2581960aa3cc2d5bbdcc86c00b4614a4      2017-08-01 14:48:52  2016-08-29 00:00:00    2016-08-30 12:23:21  MG00000001  2017-07-28 10:43:11  MG00000001  View Edit Delete
AG01000703  01000703  T前田全計  まえだぜんけい  01  893228bb2581960aa3cc2d5bbdcc86c00b4614a4      2017-10-25 18:22:03  2016-08-29 00:00:00    2016-08-30 12:23:21  MG00000001  2017-08-01 14:50:15  MG00000001  View Edit Delete
AG01000704  01000704  T増田順彦(高田市)  ますだよりひこたかたし  01  893228bb2581960aa3cc2d5bbdcc86c00b4614a4      2017-09-17 07:03:29  2016-08-29 00:00:00    2016-08-30 12:23:21  MG00000001  2017-08-03 17:36:56  MG00000002  View Edit Delete
AG01000709  01000709  T仲本まゆみ  なかもとまゆみ  01  893228bb2581960aa3cc2d5bbdcc86c00b4614a4      2017-09-02 10:01:04  2016-08-29 00:00:00    2016-08-30 12:23:21  MG00000001  2017-07-28 10:52:37  MG00000001  View Edit Delete
AG01000710  01000710  T藤川光政  ふじかわみつまさ  01  893228bb2581960aa3cc2d5bbdcc86c00b4614a4      2017-08-03 17:17:53  2016-08-29 00:00:00    2016-08-30 12:23:21  MG00000001  2017-08-03 17:38:45  MG00000002  View Edit Delete

Page 1 of 256, showing 20 records out of 5104 total, starting on record 1, ending on 20

< previous123456789
(default) 2 queries took 106 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SELECT `User`.`id`, `User`.`login_id`, `User`.`user_nm`, `User`.`user_fk`, `User`.`user_type`, `User`.`password`, `User`.`mail_address_1`, `User`.`mail_address_2`, `User`.`login_rock_flg`, `User`.`last_login_day`, `User`.`use_start_day`, `User`.`use_end_day`, `User`.`del_flg`, `User`.`init_pass_flg`, `User`.`created`, `User`.`insert_user`, `User`.`modified`, `User`.`update_user`, `Admin`.`user_id`, `Admin`.`mail_flg`, `Admin`.`created`, `Admin`.`insert_user`, `Admin`.`modified`, `Admin`.`update_user`, `Farmer`.`user_id`, `Farmer`.`agreement_start_day`, `Farmer`.`agreement_end_day`, `Farmer`.`plan_code`, `Farmer`.`agreement_amount`, `Farmer`.`rental_printer_sn`, `Farmer`.`rental_tablet_sn`, `Farmer`.`rental_tablet_tel`, `Farmer`.`rental_tablet_gmail`, `Farmer`.`label_flg`, `Farmer`.`seal_flg`, `Farmer`.`blog_flg`, `Farmer`.`log_save_number`, `Farmer`.`user_post_number`, `Farmer`.`user_address`, `Farmer`.`user_tel`, `Farmer`.`qr_url`, `Farmer`.`notification_file`, `Farmer`.`plain_password`, `Farmer`.`admin_memo`, `Farmer`.`biz_browser_authorized_devices_count`, `Farmer`.`biz_browser_authorized_devices_limit`, `Farmer`.`created`, `Farmer`.`insert_user`, `Farmer`.`modified`, `Farmer`.`update_user`, `TraderUser`.`user_id`, `TraderUser`.`trader_id`, `TraderUser`.`created`, `TraderUser`.`insert_user`, `TraderUser`.`modified`, `TraderUser`.`update_user`, `UsersPickupPoint`.`farmer_id`, `UsersPickupPoint`.`pickup_point_id`, `UsersPickupPoint`.`use_start_day`, `UsersPickupPoint`.`use_end_day`, `UsersPickupPoint`.`created`, `UsersPickupPoint`.`insert_user`, `UsersPickupPoint`.`modified`, `UsersPickupPoint`.`update_user`, `TradersFarmer`.`farmer_id`, `TradersFarmer`.`trader_id`, `TradersFarmer`.`farmer_cd`, `TradersFarmer`.`created`, `TradersFarmer`.`insert_user`, `TradersFarmer`.`modified`, `TradersFarmer`.`update_user`, `TradersPickupPoint`.`pickup_point_id`, `TradersPickupPoint`.`trader_user_id`, `TradersPickupPoint`.`use_start_day`, `TradersPickupPoint`.`use_end_day`, `TradersPickupPoint`.`created`, `TradersPickupPoint`.`insert_user`, `TradersPickupPoint`.`modified`, `TradersPickupPoint`.`update_user` FROM `sato_agri`.`users` AS `User` LEFT JOIN `sato_agri`.`admins` AS `Admin` ON (`Admin`.`user_id` = `User`.`id`) LEFT JOIN `sato_agri`.`farmers` AS `Farmer` ON (`Farmer`.`user_id` = `User`.`id`) LEFT JOIN `sato_agri`.`trader_users` AS `TraderUser` ON (`TraderUser`.`user_id` = `User`.`id`) LEFT JOIN `sato_agri`.`users_pickup_points` AS `UsersPickupPoint` ON (`UsersPickupPoint`.`farmer_id` = `User`.`id`) LEFT JOIN `sato_agri`.`traders_farmers` AS `TradersFarmer` ON (`TradersFarmer`.`farmer_id` = `User`.`id`) LEFT JOIN `sato_agri`.`traders_pickup_points` AS `TradersPickupPoint` ON (`TradersPickupPoint`.`trader_user_id` = `User`.`id`) WHERE 1 = 1 LIMIT 20202030
2SELECT COUNT(*) AS `count` FROM `sato_agri`.`users` AS `User` LEFT JOIN `sato_agri`.`admins` AS `Admin` ON (`Admin`.`user_id` = `User`.`id`) LEFT JOIN `sato_agri`.`farmers` AS `Farmer` ON (`Farmer`.`user_id` = `User`.`id`) LEFT JOIN `sato_agri`.`trader_users` AS `TraderUser` ON (`TraderUser`.`user_id` = `User`.`id`) LEFT JOIN `sato_agri`.`users_pickup_points` AS `UsersPickupPoint` ON (`UsersPickupPoint`.`farmer_id` = `User`.`id`) LEFT JOIN `sato_agri`.`traders_farmers` AS `TradersFarmer` ON (`TradersFarmer`.`farmer_id` = `User`.`id`) LEFT JOIN `sato_agri`.`traders_pickup_points` AS `TradersPickupPoint` ON (`TradersPickupPoint`.`trader_user_id` = `User`.`id`) WHERE 1 = 11176