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
AG01003269  01003269  T望農園  のぞみのうえん  01  bbe379aaf618fd4e0e5af55c1bd11b818dd4af68      2017-10-24 16:24:14  2017-10-24 00:00:00            View Edit Delete
AG01003283  01003283  T杉本紘基  すぎもとひろき  01  52f6f70a27d83a8c15ac091e58f211ee7d0197d4      2020-06-27 10:27:26  2017-10-30 00:00:00            View Edit Delete
AG01003284  01003284  T藤原隆子  ふじわらたかこ  01  52f6f70a27d83a8c15ac091e58f211ee7d0197d4      2018-09-25 16:55:02  2017-10-30 00:00:00            View Edit Delete
AG01003285  01003285  T山村敏秋  やまむらとしあき  01  52f6f70a27d83a8c15ac091e58f211ee7d0197d4      2023-03-20 15:39:00  2017-10-30 00:00:00            View Edit Delete
AG01003286  01003286  T山崎さつき  やまざきさつき  01  52f6f70a27d83a8c15ac091e58f211ee7d0197d4      2018-12-09 19:56:27  2017-10-30 00:00:00            View Edit Delete
AG01003287  01003287  T高森知佐子  たかもりちさこ  01  52f6f70a27d83a8c15ac091e58f211ee7d0197d4      2018-12-09 19:58:58  2017-10-30 00:00:00            View Edit Delete
AG01003288  01003288  T原口俊晴  はらぐちとしはる  01  52f6f70a27d83a8c15ac091e58f211ee7d0197d4      2018-12-09 19:59:08  2017-10-30 00:00:00            View Edit Delete
AG01003289  01003289  T井手マサ子  いでまさこ  01  52f6f70a27d83a8c15ac091e58f211ee7d0197d4      2022-11-14 16:26:54  2017-10-30 00:00:00            View Edit Delete
AG01003290  01003290  T㈱清和ミネラル会  せいわみねらるかい  01  52f6f70a27d83a8c15ac091e58f211ee7d0197d4      2020-09-25 07:34:11  2017-10-30 00:00:00            View Edit Delete
AG01003291  01003291  T上田清貴  うえだきよたか  01  52f6f70a27d83a8c15ac091e58f211ee7d0197d4      2018-05-03 15:33:10  2017-10-30 00:00:00            View Edit Delete
TR01000090  01000090  T久御山町  くみやまちょう  12  5eac4cedfb274ad8081adf87f495329d0a402357        2017-09-19 15:27:52            View Edit Delete
TR01000091  01000091  T三重県  みえけん  12  5eac4cedfb274ad8081adf87f495329d0a402357        2017-09-19 15:28:56            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
TR01000081  eggplant@vege.com  T佐藤テスト  さとうてすと  11  d0b76682a2a6ab4bf95ebec0f45212fe60830f61  eggplant@vege.com    2025-03-06 08:47:17  2016-09-01 14:06:49    2016-09-01 14:06:49    2016-09-01 14:07:14  MG00000001  View Edit Delete
TR01000082  cabbage@vege.com  T佐藤てすと  さとうてすと  12  d0b76682a2a6ab4bf95ebec0f45212fe60830f61  cabbage@vege.com    2023-08-29 18:10:17  2016-09-01 14:09:25    2016-09-01 14:09:25    2016-09-01 14:09:50  MG00000001  View Edit Delete
TR01000087  ch.endo@mitsui-agro.co.jp  T遠藤千暁  えんどうちあき  11  09aa23e69fbdeb82eb1adf86f3e877cd5d54061f  ch.endo@mitsui-agro.co.jp    2019-06-06 10:11:50  2016-09-23 10:24:00    2016-09-23 10:24:00    2016-09-23 10:24:16  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
TR01000086  a.nishiwaki@mitsui-agro.co.jp  T西脇愛  にしわきあい  11  2fe007686862aae206a535a33fd2b82e6709e369  a.nishiwaki@mitsui-agro.co.jp    2016-09-23 10:25:32  2016-09-23 10:14:49    2016-09-23 10:14:49    2016-09-23 10:26:09  MG00000001  View Edit Delete
TR01000085  s.tanaka@mitsui-agro.co.jp  T田中俊平  たなかしゅんぺい  11  f0e0ac0804bae9d9a806a317f1240438e37a92cd  s.tanaka@mitsui-agro.co.jp    2016-09-23 18:59:38  2016-09-23 10:12:14    2016-09-23 10:12:14    2016-09-23 19:00:22  MG00000001  View Edit Delete
TR01000084  k.takebayashi@mitsui-agro.co.jp  T竹林清宏  たけばやしきよひろ  11  267b098376910964b6b90b932642f88076bca49a  k.takebayashi@mitsui-agro.co.jp    2016-10-12 14:30:16  2016-09-23 09:43:24    2016-09-23 09:43:24    2016-10-12 14:30:27  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 318 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`.`modified` asc LIMIT 202020245
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