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
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
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
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
TR01000071  01000071  T金田  かねだ  12  586d0c1d030b93f66cc53ef8c5e27436d614600a  01000071      2016-07-01 00:00:00  2016-07-31 00:00:00  2016-08-30 12:23:37  MG00000001  2016-11-18 13:59:58  MG00000001  View Edit Delete
TR01000072  01000072  T大栄  だいえい  12  cc001c7b078cb3b458be9c724ba46eb1191e65b5  01000072      2016-07-01 00:00:00  2016-07-31 00:00:00  2016-08-30 12:23:37  MG00000001  2016-11-18 14:00:12  MG00000001  View Edit Delete
TR01000073  01000073  T深江  ふかえ  12  269be4618174f11cae30f3d850fa577b068815e6  01000073      2016-07-01 00:00:00  2016-07-31 00:00:00  2016-08-30 12:23:37  MG00000001  2016-11-18 14:00:32  MG00000001  View Edit Delete
TR01000074  01000074  T飯盛  いいもり  12  d45053cb396caa243df3fcf8351f13f003c07a70  01000074      2016-07-01 00:00:00  2016-07-31 00:00:00  2016-08-30 12:23:37  MG00000001  2016-11-18 14:01:39  MG00000001  View Edit Delete
TR01000075  01000075  T川田  かわた  12  b9e32ad2e725d66c09d95dd427f1d5d5cf77fd0b  01000075      2016-07-01 00:00:00  2016-07-31 00:00:00  2016-08-30 12:23:37  MG00000001  2016-11-18 14:01:50  MG00000001  View Edit Delete
TR01000076  01000076  T丸松  まるまつ  12  15a379e7166d63913a28880095a7e403421865a3  01000076      2016-07-01 00:00:00  2016-07-31 00:00:00  2016-08-30 12:23:37  MG00000001  2016-11-18 14:02:01  MG00000001  View Edit Delete
TR01000080  01000080  TYAFキリン堂  きりんどう  12  a90c5a22468d21d5b3a3f0217c71ea746b45fc6d  01000080      2016-07-01 00:00:00  2016-07-31 00:00:00  2016-08-30 12:23:37  MG00000001  2016-11-18 14:02:21  MG00000001  View Edit Delete
AG01000335  01000335  T上田伊佐男  うえだいさお  01  128daf96fd3b3f779b1dc0104b938fd122025e35  coccodaisukidesu@yahoo.co.jp    2022-01-24 15:55:45  2016-08-29 00:00:00    2016-08-30 12:23:18  MG00000001  2022-06-01 11:05:04  MG00000001  View Edit Delete
AG01000611  01000611  T梨子本マミ子  なしもとまみこ  01  893228bb2581960aa3cc2d5bbdcc86c00b4614a4      2023-05-02 13:57:16  2016-08-29 00:00:00    2016-08-30 12:23:20  MG00000001  2017-08-03 17:31:18  MG00000002  View Edit Delete
AG01000643  01000643  Tマルミヤ農園  まるみやのうえん  01  8f14cf117c8a77a294a63f30d72fe4b94f945c5f      2017-07-07 10:28:01  2016-08-29 00:00:00    2016-08-30 12:23:20  MG00000001  2017-03-17 17:37:14  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 322 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_end_day` desc 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 = 11174