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
AG01003391  01003391  T國武 文江  くにたけ ふみえ  01  52f6f70a27d83a8c15ac091e58f211ee7d0197d4      2018-04-24 13:23:39  2018-04-24 00:00:00    2018-04-24 12:52:12  MG00000001  2018-04-24 12:52:12  MG00000001  View Edit Delete
AG01003392  01003392  T鷹乃産業有限会社  たかのさんぎょうゆうげんがいしゃ  01  52f6f70a27d83a8c15ac091e58f211ee7d0197d4      2018-08-28 17:20:02  2018-05-10 00:00:00    2018-05-10 11:37:20  MG00000001  2018-05-10 11:37:20  MG00000001  View Edit Delete
AG01003393  01003393  Tアースワンファーム  あーすわんふぁーむ  01  bbe379aaf618fd4e0e5af55c1bd11b818dd4af68      2023-10-24 09:10:00  2018-05-11 00:00:00    2018-05-11 13:51:16  MG00000001  2018-05-11 13:51:16  MG00000001  View Edit Delete
AG01003394  01003394  Tすずらん農園  すずらんのうえん  01  bbe379aaf618fd4e0e5af55c1bd11b818dd4af68      2018-09-04 12:14:22  2018-05-11 00:00:00    2018-05-11 13:52:46  MG00000001  2018-05-11 13:52:46  MG00000001  View Edit Delete
AG01003395  01003395  T宮崎農園  みやざきのうえん  01  bbe379aaf618fd4e0e5af55c1bd11b818dd4af68      2019-05-09 08:09:16  2018-05-11 00:00:00    2018-05-11 13:53:58  MG00000001  2018-05-11 13:53:58  MG00000001  View Edit Delete
AG01003396  01003396  T(有)フジタ  ゆうげんがいしゃふじた  01  bbe379aaf618fd4e0e5af55c1bd11b818dd4af68      2019-05-09 12:08:06  2018-05-11 00:00:00    2018-05-11 13:55:08  MG00000001  2018-05-11 13:55:08  MG00000001  View Edit Delete
AG01003397  01003397  Tドリームファームスズカ  どりーむふぁーむすずか  01  bbe379aaf618fd4e0e5af55c1bd11b818dd4af68      2018-12-05 08:49:46  2018-05-11 00:00:00    2018-05-11 13:56:06  MG00000001  2018-05-11 13:56:06  MG00000001  View Edit Delete
AG01003398  01003398  T内田潤  かぶしきがいしゃななはち  01  bbe379aaf618fd4e0e5af55c1bd11b818dd4af68      2022-06-09 07:30:42  2018-05-14 00:00:00    2018-05-14 15:11:14  MG00000001  2022-06-14 10:38:13  MG00000001  View Edit Delete
AG01003399  01003399  Tシフクノヤサイ  しふくのやさい  01  58f4fd3c2c2dd87378f26bdd22b1bb2571336af3      2018-07-13 14:07:55  2018-05-15 00:00:00    2018-05-15 09:18:59  MG00000001  2018-05-15 09:40:52  MG00000001  View Edit Delete
AG01003400  01003400  T古川雅彦  ふるかわまさひこ  01  cac7a3687b6ed9b2729ffee01f445c1938dcaf8d      2023-10-02 14:59:25  2018-05-25 00:00:00    2018-05-25 09:40:22  MG00000001  2018-05-25 09:40:22  MG00000001  View Edit Delete
AG01003473  01003473  T鈴江悠司  すずえゆうじ  01  cac7a3687b6ed9b2729ffee01f445c1938dcaf8d      2024-01-18 14:42:42  2018-05-28 00:00:00    2018-05-28 10:31:52  MG00000001  2018-05-28 10:31:52  MG00000001  View Edit Delete
AG01003474  01003474  T畠口健一  はたぐちけんいち  01  cac7a3687b6ed9b2729ffee01f445c1938dcaf8d      2023-02-13 18:59:06  2018-05-28 00:00:00    2018-05-28 10:34:00  MG00000001  2018-05-28 10:34:00  MG00000001  View Edit Delete
AG01003475  01003475  T高知国沢農園  こうちくにさわのうえん  01  89d212cfb095b9bfdee9bda8c8e20c4c8f7a4c11        2018-05-28 00:00:00    2018-05-28 10:37:12  MG00000001  2018-05-28 10:37:12  MG00000001  View Edit Delete
AG01003476  01003476  T原田四郎  はらだしろう  01  89d212cfb095b9bfdee9bda8c8e20c4c8f7a4c11        2018-05-28 00:00:00    2018-05-28 10:39:50  MG00000001  2018-05-28 10:39:50  MG00000001  View Edit Delete
AG01003477  01003477  T宮崎武士  みやざきたけし  01  89d212cfb095b9bfdee9bda8c8e20c4c8f7a4c11        2018-05-28 00:00:00    2018-05-28 10:40:52  MG00000001  2018-05-28 10:40:52  MG00000001  View Edit Delete
AG01003478  01003478  T生田ウメノ  いくたうめの  01  cac7a3687b6ed9b2729ffee01f445c1938dcaf8d      2022-03-26 01:02:54  2018-05-28 00:00:00    2018-05-28 10:41:47  MG00000001  2020-03-27 09:14:34  AG01003478  View Edit Delete
AG01003479  01003479  T山麓農園ふぉりば  さんろくのうえんふぉりば  01  bbe379aaf618fd4e0e5af55c1bd11b818dd4af68      2020-08-05 09:31:31  2018-05-31 00:00:00    2018-05-31 09:48:26  MG00000001  2018-05-31 09:48:26  MG00000001  View Edit Delete
AG01003480  01003480  T矢田 稔  やだみのる  01  bbe379aaf618fd4e0e5af55c1bd11b818dd4af68      2018-12-07 18:10:47  2018-05-31 00:00:00    2018-05-31 09:49:24  MG00000001  2018-05-31 09:49:24  MG00000001  View Edit Delete
AG01003481  01003481  T堀田 明彦  ほったあきひこ  01  bbe379aaf618fd4e0e5af55c1bd11b818dd4af68      2018-12-01 10:27:59  2018-05-31 00:00:00    2018-05-31 09:50:03  MG00000001  2018-05-31 09:50:03  MG00000001  View Edit Delete
AG01003482  01003482  THATAKEYA  はたけや  01  bbe379aaf618fd4e0e5af55c1bd11b818dd4af68      2019-11-19 10:30:44  2018-05-31 00:00:00    2018-05-31 09:50:45  MG00000001  2018-05-31 09:50:45  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 326 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`.`mail_address_2` desc LIMIT 202020250
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 = 11176