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
AG01006024  01006024  T八代祟洋  やしろたかひろ  01  c429bccaaf941b3a2c604fc696a5fa6eb5651d2c      2024-01-23 07:57:57  2023-12-22 00:00:00    2023-12-22 00:00:00  MG00000001  2023-12-22 00:00:00  MG00000001  View Edit Delete
AG01006025  01006025  T(直)佐藤範雄  さとうのりお  01  da943ad198e8d7ebea40efe2a031d16cccbe97fb        2023-12-22 00:00:00    2023-12-22 00:00:00  MG00000001  2023-12-22 00:00:00  MG00000001  View Edit Delete
AG01006026  01006026  T佐藤範雄  さとうのりお  01  c429bccaaf941b3a2c604fc696a5fa6eb5651d2c        2023-12-22 00:00:00    2023-12-22 00:00:00  MG00000001  2023-12-22 00:00:00  MG00000001  View Edit Delete
AG01006027  01006027  Tみつせ村農園(有)アサヒ・アグリ佐賀  みつせむらのうえんあさひあぐり  01  da943ad198e8d7ebea40efe2a031d16cccbe97fb      2024-01-16 14:43:12  2023-12-22 00:00:00    2023-12-22 00:00:00  MG00000001  2023-12-22 00:00:00  MG00000001  View Edit Delete
AG01006028  01006028  T古賀美津子  こがみつこ  01  da943ad198e8d7ebea40efe2a031d16cccbe97fb        2023-12-22 00:00:00    2023-12-22 00:00:00  MG00000001  2023-12-22 00:00:00  MG00000001  View Edit Delete
AG01006029  01006029  T今村智宏  いまむらともひろ  01  da943ad198e8d7ebea40efe2a031d16cccbe97fb      2024-01-22 15:35:16  2023-12-28 00:00:00    2023-12-28 15:49:11  MG00000006  2023-12-28 16:07:08  MG00000006  View Edit Delete
AG01006030  01006030  てすとテスト    01  11d6dbda1a938bc96f4b8e125a039642173518a8        2024-02-27 00:00:00    2024-02-27 14:10:21  MG00000001  2024-02-27 14:10:21  MG00000001  View Edit Delete
AG01006031  01006031  てすと    01  c429bccaaf941b3a2c604fc696a5fa6eb5651d2c        2024-03-11 00:00:00    2024-03-11 14:34:18  TR01000110  2024-03-11 14:34:18  TR01000110  View Edit Delete
AG01006032  01006032  中間業者テスト    01  72a60a75775c1dd5dbef162bf95c107fc7711668      2024-03-15 14:34:26  2024-03-12 00:00:00    2024-03-12 11:41:45  TR01000110  2024-03-12 11:41:45  TR01000110  View Edit Delete
AG01006033  01006033  佐藤テスト    01  0e8852433a57eb7742c6162444d97c02202e90b8      2024-03-14 11:39:00  2024-03-13 00:00:00    2024-03-13 11:04:37  TR01000110  2024-03-13 11:04:37  TR01000110  View Edit Delete
AG02000001  02000001  Tよつばマルシェ 1  よつばまるしぇいち  01  733d15d5c81a7daa65441425cfac18e4e539d3dc  maze_vegetable@gmail.com    2024-01-24 15:58:41  2017-02-01 00:00:00    2017-02-01 00:00:00  MG00000001  2018-09-07 16:13:16  MG00000001  View Edit Delete
AG02000002  02000002  Tよつばマルシェ 2  よつばまるしぇに  01  733d15d5c81a7daa65441425cfac18e4e539d3dc      2023-11-10 12:53:06  2017-02-01 00:00:00    2017-02-01 00:00:00  MG00000001  2017-12-28 13:04:28  MG00000002  View Edit Delete
AG02000003  02000003  Tよつばマルシェ 3  よつばまるしぇさん  01  733d15d5c81a7daa65441425cfac18e4e539d3dc      2021-04-21 13:22:45  2017-02-01 00:00:00    2017-02-01 00:00:00  MG00000001  2017-02-27 20:12:12  MG00000002  View Edit Delete
AG02000004  02000004  Tよつばマルシェ 4  よつばまるしぇよん  01  733d15d5c81a7daa65441425cfac18e4e539d3dc      2023-11-14 10:08:17  2017-02-01 00:00:00    2017-02-01 00:00:00  MG00000001  2017-02-27 20:11:31  MG00000002  View Edit Delete
AG02000005  02000005  Tよつばマルシェ 5  よつばまるしぇご  01  733d15d5c81a7daa65441425cfac18e4e539d3dc      2023-02-16 09:42:39  2017-02-01 00:00:00    2017-02-01 00:00:00  MG00000001  2017-03-24 18:06:36  MG00000001  View Edit Delete
AG02000006  02000006  Tよつばマルシェ 6  よつばまるしぇろく  01  733d15d5c81a7daa65441425cfac18e4e539d3dc      2023-11-09 16:04:09  2017-02-01 00:00:00    2017-02-01 00:00:00  MG00000001  2020-11-11 09:03:01  MG00000005  View Edit Delete
AG02000007  02000007  Tよつばマルシェ 7  よつばまるしぇなな  01  733d15d5c81a7daa65441425cfac18e4e539d3dc  nomotonouen@tv-naruto.ne.jp    2023-12-13 14:37:26  2017-02-01 00:00:00    2017-02-01 00:00:00  MG00000001  2017-04-07 13:22:23  MG00000001  View Edit Delete
AG02000008  02000008  Tよつばマルシェ 8  よつばまるしぇはち  01  733d15d5c81a7daa65441425cfac18e4e539d3dc  tani5037@icloud.com    2024-01-03 13:25:16  2017-02-01 00:00:00    2017-02-01 00:00:00  MG00000001  2017-04-07 13:22:40  MG00000001  View Edit Delete
AG02000009  02000009  Tよつばマルシェ 9  よつばまるしぇく  01  733d15d5c81a7daa65441425cfac18e4e539d3dc  chyobi-1957.9.2@docomo.ne.jp    2024-01-24 16:19:37  2017-02-01 00:00:00    2017-02-01 00:00:00  MG00000001  2017-04-07 13:22:51  MG00000001  View Edit Delete
AG02000010  02000010  Tよつばマルシェ 10  よつばまるしぇじゅう  01  733d15d5c81a7daa65441425cfac18e4e539d3dc      2023-05-28 15:21:05  2017-02-01 00:00:00    2017-02-01 00:00:00  MG00000001  2017-04-07 13:21:01  MG00000001  View Edit Delete

Page 154 of 256, showing 20 records out of 5104 total, starting on record 3061, ending on 3080

(default) 2 queries took 217 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 3060, 202020144
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