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
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
AG01002762  01002762  T江藤信雄  えとうのぶお  01  58f4fd3c2c2dd87378f26bdd22b1bb2571336af3      2023-07-26 10:19:19  2016-07-01 00:00:00    2017-04-18 13:36:00  MG00000001  2017-05-24 12:34:23  MG00000001  View Edit Delete
AG01002763  01002763  T川内農園  かわうちのうえん  01  58f4fd3c2c2dd87378f26bdd22b1bb2571336af3      2017-09-08 19:17:15  2016-07-01 00:00:00    2017-04-18 13:36:00  MG00000001  2017-05-24 12:34:35  MG00000001  View Edit Delete
AG01002764  01002764  T谷口恵子  たにぐちけいこ  01  58f4fd3c2c2dd87378f26bdd22b1bb2571336af3      2022-03-31 11:22:02  2016-07-01 00:00:00    2017-04-18 13:36:00  MG00000001  2017-05-24 12:34:46  MG00000001  View Edit Delete
AG01002765  01002765  T花田果樹園  はなだかじゅえん  01  58f4fd3c2c2dd87378f26bdd22b1bb2571336af3      2019-04-21 13:01:47  2016-07-01 00:00:00    2017-04-18 13:36:00  MG00000001  2017-04-20 11:25:41  MG00000001  View Edit Delete
AG01002766  01002766  T久冨農園  くふのうえん  01  58f4fd3c2c2dd87378f26bdd22b1bb2571336af3      2022-03-31 13:25:53  2016-07-01 00:00:00    2017-04-18 13:36:00  MG00000001  2017-04-20 11:25:32  MG00000001  View Edit Delete
AG01002767  01002767  T水上拓哉  みなかみたくや  01  58f4fd3c2c2dd87378f26bdd22b1bb2571336af3      2024-01-24 11:35:33  2016-07-01 00:00:00    2017-04-18 13:36:00  MG00000001  2021-01-25 16:07:48  MG00000005  View Edit Delete
AG01002768  01002768  T水城太喜男  みずきたきお  01  58f4fd3c2c2dd87378f26bdd22b1bb2571336af3  qq5u3st9@almond.ocn.ne.jp    2023-04-05 13:26:22  2016-07-01 00:00:00    2017-04-18 13:36:00  MG00000001  2018-07-06 09:24:20  MG00000001  View Edit Delete
AG01002769  01002769  T山下グリーンファーム  やましたぐりーんふぁーむ  01  58f4fd3c2c2dd87378f26bdd22b1bb2571336af3      2023-03-07 19:50:35  2016-07-01 00:00:00    2017-04-18 13:36:00  MG00000001  2017-04-20 11:26:01  MG00000001  View Edit Delete
AG01002770  01002770  T山本清福  やまもときよふく  01  58f4fd3c2c2dd87378f26bdd22b1bb2571336af3      2017-04-20 11:51:03  2016-07-01 00:00:00    2017-04-18 13:36:00  MG00000001  2017-04-20 11:26:15  MG00000001  View Edit Delete
AG01002771  01002771  T㈱結之こころ  ゆいのこころ  01  58f4fd3c2c2dd87378f26bdd22b1bb2571336af3      2017-04-20 14:14:05  2016-07-01 00:00:00    2017-04-18 13:36:00  MG00000001  2017-04-20 13:09:33  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
TR01000005  01000005  TJAいしかり  いしかり  12  1f65e792f507f481c677a4f079f58fa9f1ec5aa5  01000005      2016-07-01 00:00:00  2016-07-31 00:00:00  2016-08-30 12:23:37  MG00000001  2016-11-18 09:04:44  MG00000001  View Edit Delete
TR01000006  01000006  T月形新鮮組  つきがたしんせんぐみ  12  5f31cd69ee346b09cc6fed468dcfe1370d02c8bf  01000006      2016-07-01 00:00:00  2016-07-31 00:00:00  2016-08-30 12:23:37  MG00000001  2016-11-18 09:04:59  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 317 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`.`use_start_day` 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 = 11172