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
MG00000008  test2@test.com  くだもの    99  020d4b86eaf8e6ef9a2363fa468ca5b66dcd2918  test2@test.com      2024-02-27 00:00:00    2024-02-27 14:17:29  MG00000001  2024-02-27 14:17:29  MG00000001  View Edit Delete
MG00000001  grp-support.agri-harvest@sato-global.com  T管理者(サトー)  かんりしゃ(さとー)  99  d0b76682a2a6ab4bf95ebec0f45212fe60830f61  grp-support.agri-harvest@sato-global.com    2025-03-06 15:14:24  2016-08-01 00:00:00    2016-08-26 17:04:05  MG00000001  2016-09-01 10:51:25  MG00000001  View Edit Delete
MG00000002  yasuaki.ishida@sato-global.com  T石田康晃  いしだやすあき  99  562ea7a8a15ddce7fcce7167c6fc1a0bbed14325  yasuaki.ishida@sato-global.com    2023-11-30 10:48:45  2016-09-01 10:31:37    2016-09-01 10:31:37    2016-12-27 11:40:08  MG00000001  View Edit Delete
MG00000003  koichi.takahashi@sato-global.com  T高橋 幸一  たかはしこういち  99  27119deb2f93bfd8f877c5c725b58e6e06f71e42  koichi.takahashi@sato-global.com    2020-05-20 11:32:46  2019-12-06 00:00:00    2019-12-06 10:39:26  MG00000001  2019-12-10 16:30:55  MG00000001  View Edit Delete
MG00000004  satoko.ogawa@sato-global.com  T小川 聡子  おがわさとこ  99  ac48bb28a0645c54ceaa56652880baae9e7e9d57  satoko.ogawa@sato-global.com    2020-03-02 17:33:00  2019-12-06 00:00:00    2019-12-06 10:47:13  MG00000001  2020-01-17 10:13:44  MG00000001  View Edit Delete
MG00000005  t.hisano@info-sense.co.jp  T久野友崇  ひさのともたか  99  3712a121fcffa0396831c0ebe451ee0c5934de60  t.hisano@info-sense.co.jp    2022-09-01 09:03:44  2020-06-02 00:00:00    2020-06-02 11:17:11  MG00000001  2020-06-02 11:18:50  MG00000001  View Edit Delete
MG00000006  hikaru.ichimaru@sato-global.com  T市丸耀  いちまるひかる  99  0f1674756a2ae16b91a851d5191c5e509b59895a  hikaru.ichimaru@sato-global.com    2023-12-28 13:56:50  2023-06-29 00:00:00    2023-06-29 13:53:36  MG00000001  2023-11-01 14:54:13  MG00000001  View Edit Delete
MG00000007  asako.kusakari@sato-global.com  T草刈 麻子  くさかりあさこ  99  1972d2e89233a4a4fd382476a52f8b43f3e4763f  asako.kusakari@sato-global.com    2024-01-19 08:55:42  2023-09-21 00:00:00    2023-09-21 11:14:19  MG00000001  2023-09-21 11:54:22  MG00000001  View Edit Delete
TR01000002  01000002  TJA道央  どうおう  12  6854c1657ab410f1b3602210a45fac88a48da88b  01000002      2016-07-01 00:00:00  2030-07-31 00:00:00  2016-08-30 12:23:37  MG00000001  2016-11-18 09:03:15  MG00000001  View Edit Delete
TR01000003  01000003  T長沼  ながぬま  12  39f562c4834b2d854dba536e7c019ca57e00c077  01000003      2016-07-01 00:00:00  2016-07-31 00:00:00  2016-08-30 12:23:37  MG00000001  2016-11-18 09:03:53  MG00000001  View Edit Delete
TR01000022  01000022  TJA北いしかり①  きたいしかり  12  c2c81757eb4dcd50afb2592e2e371d808a9b6d32  01000022      2016-07-01 00:00:00  2016-07-31 00:00:00  2016-08-30 12:23:37  MG00000001  2016-11-18 09:08:05  MG00000001  View Edit Delete
TR01000023  01000023  TJA北いしかり②  きたいしかり  12  59916f16ae49dfd40b5ab983a49f922067a079f7  01000023      2016-07-01 00:00:00  2016-07-31 00:00:00  2016-08-30 12:23:37  MG00000001  2016-11-18 09:08:16  MG00000001  View Edit Delete
TR01000004  01000004  T南幌  なんぽろ  12  64aff6315bb39eca37879c2131e6db5572692057  01000004      2016-07-01 00:00:00  2016-07-31 00:00:00  2016-08-30 12:23:37  MG00000001  2016-11-18 09:04:32  MG00000001  View Edit Delete
TR01000032  01000032  T木津川市  きづがわ  12  b8d449de72ea4676276609e441c08148753b7679  01000032      2016-08-29 00:00:00    2016-08-30 12:23:37  MG00000001  2016-11-18 09:10:45  MG00000001  View Edit Delete
TR01000033  01000033  T亀岡市  かめおか  12  d0ab0a8ba3990a2fac024ed147a5a44e11b2202e  01000033      2016-08-29 00:00:00    2016-08-30 12:23:37  MG00000001  2016-11-18 09:10:56  MG00000001  View Edit Delete
TR01000034  01000034  TMAB京都  きょうと  12  e0fc39d68e1a0a326bfefe81892602ca28ad354e  01000034      2016-08-29 00:00:00    2016-08-30 12:23:37  MG00000001  2016-11-18 09:11:08  MG00000001  View Edit Delete
TR01000108  yaf@yaf-nara.com  T大和アグロファーム  やまとあぐろふぁーむ  12  e42652ab16049d9c1dea8a88c238d266a85dbe47  yaf@yaf-nara.com    2019-04-04 16:20:31  2019-03-27 00:00:00    2019-03-27 14:12:14  MG00000001  2019-04-04 16:21:10  MG00000001  View Edit Delete
TR01000036  01000036  T郡山市  こおりやま  12  7ba904560e55516e994029752d78820a5cd2014b  01000036      2016-08-29 00:00:00    2016-08-30 12:23:37  MG00000001  2016-11-18 09:11:41  MG00000001  View Edit Delete
TR01000037  01000037  T高田市  たかだ  12  f16b982165486693063bdd0e2b4f34dcc4e71aff  01000037      2016-08-29 00:00:00    2016-08-30 12:23:37  MG00000001  2016-11-18 09:11:51  MG00000001  View Edit Delete
TR01000107  test-yaf@yaf-nara.com  T大和アグロファーム  やまとあぐろふぁーむ  12  eb8c15a26cd54e42321ca619733379d1579b06c9  test-yaf@yaf-nara.com    2019-03-27 14:02:59  2018-03-23 17:57:53    2018-03-23 17:57:53    2019-03-27 14:03:30  MG00000001  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 316 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 ORDER BY `User`.`user_type` desc LIMIT 202020244
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 = 11172