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
AG02000011  02000011  Tよつばマルシェ 11  よつばまるしぇじゅういち  01  733d15d5c81a7daa65441425cfac18e4e539d3dc  dohgen.an@docomo.ne.jp    2024-01-24 11:02:02  2017-02-01 00:00:00    2017-02-01 00:00:00  MG00000001  2017-03-24 18:08:20  MG00000001  View Edit Delete
AG02000012  02000012  Tよつばマルシェ 12  よつばまるしぇじゅうに  01  733d15d5c81a7daa65441425cfac18e4e539d3dc  oharumaki455@gmail.com    2024-01-22 09:22:53  2017-02-01 00:00:00    2017-02-01 00:00:00  MG00000001  2017-03-24 18:06:51  MG00000001  View Edit Delete
AG02000013  02000013  Tよつばマルシェ 13  よつばまるしぇじゅうさん  01  733d15d5c81a7daa65441425cfac18e4e539d3dc  ninjin-musuko@docomo.ne.jp    2024-01-24 13:00:11  2017-02-01 00:00:00    2017-02-01 00:00:00  MG00000001  2017-04-07 13:23:15  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
AG02000015  02000015  Tよつばマルシェ 15  よつばまるしぇじゅうご  01  733d15d5c81a7daa65441425cfac18e4e539d3dc  morethanags.4491@docomo.ne.jp    2024-06-06 19:47:09  2017-02-01 00:00:00    2017-02-01 00:00:00  MG00000001  2017-02-27 16:56:16  MG00000002  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
AG02000017  02000017  Tよつばマルシェ 17  よつばまるしぇじゅうなな  01  733d15d5c81a7daa65441425cfac18e4e539d3dc  naoki.tamura5502@docomo.ne.jp    2022-06-02 10:49:11  2017-02-01 00:00:00    2017-02-01 00:00:00  MG00000001  2017-02-27 16:57:52  MG00000002  View Edit Delete
AG02000018  02000018  Tよつばマルシェ 18  よつばまるしぇじゅうはち  01  733d15d5c81a7daa65441425cfac18e4e539d3dc  rio3kasiko@ezweb.ne.jp    2024-01-23 12:27:56  2017-02-01 00:00:00    2017-02-01 00:00:00  MG00000001  2018-03-02 09:48:07  MG00000001  View Edit Delete
AG02000019  02000019  Tよつばマルシェ 19  よつばまるしぇじゅうく  01  733d15d5c81a7daa65441425cfac18e4e539d3dc  chi-bu22051@docomo.ne.jp    2022-10-21 09:54:27  2017-02-01 00:00:00    2017-02-01 00:00:00  MG00000001  2017-08-02 10:32:28  MG00000001  View Edit Delete
AG02000020  02000020  Tよつばマルシェ 20  よつばまるしぇにじゅう  01  733d15d5c81a7daa65441425cfac18e4e539d3dc  sakura.tuneko-0427@docomo.ne.jp    2024-01-23 12:23:04  2017-02-01 00:00:00    2017-02-01 00:00:00  MG00000001  2017-02-27 17:03:28  MG00000002  View Edit Delete
AG02000021  02000021  Tよつばマルシェ 21  よつばまるしぇにじゅういち  01  733d15d5c81a7daa65441425cfac18e4e539d3dc  miyochan-fumiochan1982.1.18@docomo.ne.jp    2021-04-07 11:58:23  2017-02-01 00:00:00    2017-02-01 00:00:00  MG00000001  2017-02-27 17:40:22  MG00000002  View Edit Delete
AG02000022  02000022  Tよつばマルシェ 22  よつばまるしぇにじゅうに  01  733d15d5c81a7daa65441425cfac18e4e539d3dc  lotusrootburdockbroccoli@softbank.ne.jp    2023-07-12 13:24:14  2017-02-01 00:00:00    2017-02-01 00:00:00  MG00000001  2017-02-27 17:41:05  MG00000002  View Edit Delete
AG02000023  02000023  Tよつばマルシェ 23  よつばまるしぇにじゅうさん  01  733d15d5c81a7daa65441425cfac18e4e539d3dc  m.8067-blue.gardenia@docomo.ne.jp    2021-11-07 13:20:40  2017-02-01 00:00:00    2017-02-01 00:00:00  MG00000001  2017-02-27 17:42:43  MG00000002  View Edit Delete
AG02000024  02000024  Tよつばマルシェ 24  よつばまるしぇにじゅうし  01  733d15d5c81a7daa65441425cfac18e4e539d3dc  puti-puti@ezweb.ne.jp    2022-06-07 11:27:36  2017-02-01 00:00:00    2017-02-01 00:00:00  MG00000001  2017-04-07 13:26:22  MG00000001  View Edit Delete
AG02000025  02000025  Tよつばマルシェ 25  よつばまるしぇにじゅうご  01  733d15d5c81a7daa65441425cfac18e4e539d3dc      2020-04-13 14:29:21  2017-02-01 00:00:00    2017-02-01 00:00:00  MG00000001  2018-10-11 15:02:43  MG00000001  View Edit Delete
AG02000026  02000026  Tよつばマルシェ 26  よつばまるしぇにじゅうろく  01  733d15d5c81a7daa65441425cfac18e4e539d3dc      2021-06-14 14:01:41  2017-02-01 00:00:00    2017-02-01 00:00:00  MG00000001  2017-02-27 20:01:32  MG00000002  View Edit Delete
AG02000027  02000027  Tよつばマルシェ 27  よつばまるしぇにじゅうなな  01  733d15d5c81a7daa65441425cfac18e4e539d3dc      2019-09-12 14:02:50  2017-02-01 00:00:00    2017-02-01 00:00:00  MG00000001  2017-02-27 20:00:35  MG00000002  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
AG02000029  02000029  Tよつばマルシェ 29  よつばまるしぇにじゅうく  01  733d15d5c81a7daa65441425cfac18e4e539d3dc  no_en.ishida@ezweb.ne.jp    2024-01-23 13:23:56  2017-02-01 00:00:00    2017-02-01 00:00:00  MG00000001  2017-04-03 16:44:47  MG00000001  View Edit Delete
AG02000030  02000030  Tよつばマルシェ 30  よつばまるしぇさんじゅう  01  733d15d5c81a7daa65441425cfac18e4e539d3dc      2023-12-14 13:52:39  2017-02-01 00:00:00    2017-02-01 00:00:00  MG00000001  2017-03-24 18:05:49  MG00000001  View Edit Delete

Page 155 of 256, showing 20 records out of 5104 total, starting on record 3081, ending on 3100

(default) 2 queries took 223 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 LIMIT 3080, 202020148
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 = 11175