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
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
TR05000095  yamagishi@okumurashoji.co.jp  T山岸 愛  やまぎし あい  11  6548c964eb1e689c1c6561d647f33d7169360845  yamagishi@okumurashoji.co.jp    2022-10-25 10:03:56  2017-12-26 14:00:41    2017-12-26 14:00:41    2017-12-30 17:34:27  MG00000002  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
AG02000014  02000014  Tよつばマルシェ 14  よつばまるしぇじゅうよん  01  733d15d5c81a7daa65441425cfac18e4e539d3dc  xptlx952@ybb.ne.jp    2024-01-24 12:52:52  2017-02-01 00:00:00    2017-02-01 00:00:00  MG00000001  2017-04-07 13:23:30  MG00000001  View Edit Delete
TR08000108  vegeus-farm@arai-group.co.jp  T平塚土屋の直売所  ひらつかつちやのちょくばいじょ  11  c55104ba172037d21bbdad9518aa66b82bc97092  vegeus-farm@arai-group.co.jp    2024-01-24 12:06:03  2023-03-23 00:00:00    2023-03-23 13:36:27  MG00000001  2023-03-23 14:23:04  MG00000001  View Edit Delete
AG01003372  01003372  T中村隆之  なかむらのうえん  01  bbe379aaf618fd4e0e5af55c1bd11b818dd4af68  vall-mama@i.softbank.jp    2024-01-22 13:38:01  2018-02-22 00:00:00    2018-02-22 00:00:00  MG00000001  2022-06-16 08:49:23  MG00000001  View Edit Delete
AG02000028  02000028  Tよつばマルシェ 28  よつばまるしぇにじゅうはち  01  733d15d5c81a7daa65441425cfac18e4e539d3dc  tuyoshikameda31@docomo.ne.jp    2023-12-23 13:35:32  2017-02-01 00:00:00    2017-02-01 00:00:00  MG00000001  2017-07-11 15:00:14  MG00000001  View Edit Delete
TR00000001  trmail@trader.co.jp  T三井物産アグロビジネス  みついぶっさんあぐろびじねす  11    trmail@trader.co.jp      2016-08-01 00:00:00    2016-08-26 17:04:05  MG00000001  2016-09-23 10:24:30  MG00000001  View Edit Delete
AG02000016  02000016  Tよつばマルシェ 16  よつばまるしぇじゅうろく  01  733d15d5c81a7daa65441425cfac18e4e539d3dc  the-last_etema.1-0.oth@docomo.ne.jp    2021-09-08 16:41:17  2017-02-01 00:00:00    2017-02-01 00:00:00  MG00000001  2017-07-11 13:58:33  MG00000001  View Edit Delete
TR02000104  test_maze.vegetable@gmail.com  T南風ベジタブルテスト  まぜべじたぶるてすと  11  d0b76682a2a6ab4bf95ebec0f45212fe60830f61  test_maze.vegetable@gmail.com    2021-02-02 14:48:49  2018-02-21 09:43:18    2018-02-21 09:43:18    2018-02-21 09:46:10  MG00000002  View Edit Delete
TR08000106  test_arai@gmail.com  Tテスト_荒井ベジアス  てすとあらべじあす  11  d0b76682a2a6ab4bf95ebec0f45212fe60830f61  test_arai@gmail.com    2018-03-19 11:55:00  2018-03-10 17:59:39    2018-03-10 17:59:39    2018-03-10 18:02:18  MG00000002  View Edit Delete
TR01000109  test@test.com  やさい    11  c8ae6862b7efa8edf8404740c8bfef8d89dc8b3d  test@test.com      2024-02-27 00:00:00    2024-02-27 14:15:46  MG00000001  2024-02-27 14:15:46  MG00000001  View Edit Delete
TR05000103  test@okumurashoji.co.jp  T奥村商事(埼玉)テスト  おくむらしょうじてすと  11  d0b76682a2a6ab4bf95ebec0f45212fe60830f61  test@okumurashoji.co.jp    2022-06-29 14:23:41  2018-02-21 09:42:06    2018-02-21 09:42:06    2019-08-30 17:07:29  MG00000001  View Edit Delete
TR04000002  test@nosoken.jp  T農総研テスト  のうそうけんてすと  11  d0b76682a2a6ab4bf95ebec0f45212fe60830f61  test@nosoken.jp    2022-07-29 15:27:40  2022-06-29 00:00:00    2022-06-29 14:29:26  MG00000001  2022-06-29 14:29:26  MG00000001  View Edit Delete
TR01000105  test@mitsui-agro.co.jp  T三井物産テスト  みついぶっさんてすと  11  d0b76682a2a6ab4bf95ebec0f45212fe60830f61  test@mitsui-agro.co.jp    2018-02-21 09:53:19  2018-02-21 09:51:45    2018-02-21 09:51:45    2018-02-21 09:53:35  MG00000002  View Edit Delete
TR03000102  test@hida-surugaya.com  T駿河屋テスト  するがやてすと  11  d0b76682a2a6ab4bf95ebec0f45212fe60830f61  test@hida-surugaya.com    2018-04-10 18:18:13  2018-02-21 09:40:21    2018-02-21 09:40:21    2018-04-01 16:29:38  MG00000002  View Edit Delete
TR01000113  test5@test.com  中間業者テスト    11  c2debdbc6537ad963c4aa33c00418a32194f4325  test5@test.com      2024-03-12 00:00:00    2024-03-12 08:55:24  MG00000001  2024-03-12 08:55:24  MG00000001  View Edit Delete
TR01000112  test4@test.com  中間業者テスト    11  d0b76682a2a6ab4bf95ebec0f45212fe60830f61  test4@test.com    2025-06-11 09:58:41  2024-03-12 00:00:00    2024-03-12 08:54:41  MG00000001  2024-03-12 08:54:41  MG00000001  View Edit Delete
TR01000110  test3@test.com  中間業者テスト    11  d0b76682a2a6ab4bf95ebec0f45212fe60830f61  test3@test.com    2024-03-15 14:26:49  2024-03-11 00:00:00    2024-03-11 13:55:09  MG00000001  2024-03-11 14:03:11  MG00000001  View Edit Delete
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

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`.`mail_address_1` desc LIMIT 202020243
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 = 11173