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
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
AG01001155  01001155  T大和アグロファーム(キリン堂)  やまとあぐろふぁーむ  01  893228bb2581960aa3cc2d5bbdcc86c00b4614a4      2019-10-29 11:49:39  2016-07-01 00:00:00  2016-07-31 00:00:00  2016-08-30 12:23:25  MG00000001  2017-10-20 15:42:46  AG01001155  View Edit Delete
AG01001266  01001266  T亀田裕行  かめだひろゆき  01  87b61df05017322dc411d6eca20a205f57ed487e      2019-11-01 11:38:20  2016-08-29 00:00:00    2016-08-30 12:23:26  MG00000001  2019-11-01 11:38:38  AG01001266  View Edit Delete
AG01001267  01001267  T久保智弘  くぼともひろ  01  87b61df05017322dc411d6eca20a205f57ed487e      2024-01-24 13:52:11  2016-08-29 00:00:00    2016-08-30 12:23:26  MG00000001  2017-09-25 11:34:31  AG01001267  View Edit Delete
AG01001353  01001353  T三木好美  みきよしみ  01  d98496bc13710e341b3e8cef8bdf56b92e8cf324      2024-01-22 11:45:13  2016-08-29 00:00:00    2016-08-30 12:23:27  MG00000001  2023-01-26 10:02:33  AG01001353  View Edit Delete
AG01001559  01001559  T野本勝一  のもとかついち  01  87b61df05017322dc411d6eca20a205f57ed487e      2019-11-01 11:37:03  2016-08-29 00:00:00    2016-08-30 12:23:29  MG00000001  2019-11-01 11:37:20  AG01001559  View Edit Delete
AG01001569  01001569  T三原央行  みはらひろゆき  01  87b61df05017322dc411d6eca20a205f57ed487e  rtccx553@yahoo.co.jp    2024-01-23 12:16:21  2016-08-29 00:00:00    2016-08-30 12:23:29  MG00000001  2023-08-18 08:05:49  AG01001569  View Edit Delete
AG01001579  01001579  T中野智輝  なかのともき  01  87b61df05017322dc411d6eca20a205f57ed487e      2024-01-24 11:28:29  2016-08-29 00:00:00    2016-08-30 12:23:29  MG00000001  2019-11-01 11:39:12  AG01001579  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 321 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`.`update_user` asc LIMIT 202020248
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