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
AG01003361  01003361  T金岐  かなげ  01  128daf96fd3b3f779b1dc0104b938fd122025e35      2018-01-26 00:00:00  2018-01-26 00:00:00    2018-01-26 00:00:00  MG00000001  2018-01-26 00:00:00  MG00000001  View Edit Delete
AG01003362  01003362  Tマサコのヤサイ  まさこのやさい  01  128daf96fd3b3f779b1dc0104b938fd122025e35      2019-02-21 10:22:41  2018-01-26 00:00:00    2018-01-26 00:00:00  MG00000001  2018-01-26 00:00:00  MG00000001  View Edit Delete
AG01003363  01003363  Tすずめファーム  すずめふぁーむ  01  128daf96fd3b3f779b1dc0104b938fd122025e35      2020-08-07 06:21:43  2018-01-26 00:00:00    2018-01-26 00:00:00  MG00000001  2018-01-26 00:00:00  MG00000001  View Edit Delete
AG01003364  01003364  T間口アグリファクトリー  まぐちあぐりふぁくとりー  01  128daf96fd3b3f779b1dc0104b938fd122025e35      2018-01-26 00:00:00  2018-01-26 00:00:00    2018-01-26 00:00:00  MG00000001  2018-01-26 00:00:00  MG00000001  View Edit Delete
AG01003365  01003365  T古谷一也  ふるやかずなり  01  128daf96fd3b3f779b1dc0104b938fd122025e35      2021-10-07 18:58:17  2018-01-26 00:00:00    2018-01-26 00:00:00  MG00000001  2022-06-01 11:08:00  MG00000001  View Edit Delete
AG01003366  01003366  Tさき農園  さきのうえん  01  128daf96fd3b3f779b1dc0104b938fd122025e35      2018-01-30 09:57:07  2018-01-26 00:00:00    2018-01-26 00:00:00  MG00000001  2018-01-26 00:00:00  MG00000001  View Edit Delete
AG01003367  01003367  T武田雅子  たけだまさこ  01  58f4fd3c2c2dd87378f26bdd22b1bb2571336af3      2019-06-26 12:07:39  2018-01-29 00:00:00    2018-01-29 00:00:00  MG00000001  2018-01-29 00:00:00  MG00000001  View Edit Delete
AG01003368  01003368  T奥村誠  おくむらまこと  01  d98496bc13710e341b3e8cef8bdf56b92e8cf324      2023-10-18 16:30:17  2018-01-30 00:00:00    2018-01-30 00:00:00  MG00000001  2023-01-26 10:04:27  AG01003368  View Edit Delete
AG01003369  01003369  T合屋フルーツトマト農園  あいやふるーつとまとのうえん  01  58f4fd3c2c2dd87378f26bdd22b1bb2571336af3      2018-03-30 14:07:23  2018-02-05 00:00:00    2018-02-05 00:00:00  MG00000001  2018-02-05 00:00:00  MG00000001  View Edit Delete
AG01003370  01003370  T(株)イチダイ産業  いちだいさんぎょう  01  bbe379aaf618fd4e0e5af55c1bd11b818dd4af68      2018-04-12 10:54:26  2018-02-08 00:00:00    2018-02-08 00:00:00  MG00000001  2018-02-08 17:39:27  AG01003370  View Edit Delete
AG01003371  01003371  T大嶋農園  おおしまのうえん  01  bbe379aaf618fd4e0e5af55c1bd11b818dd4af68      2019-01-26 08:57:13  2018-02-22 00:00:00    2018-02-22 00:00:00  MG00000001  2018-02-22 17:39:27  AG01003370  View Edit Delete
AG01003372  01003372  T中村隆之  なかむらのうえん  01  bbe379aaf618fd4e0e5af55c1bd11b818dd4af68  vall-mama@i.softbank.jp    2024-01-22 13:38:01  2018-02-22 00:00:00    2018-02-22 00:00:00  MG00000001  2022-06-16 08:49:23  MG00000001  View Edit Delete
AG01003373  01003373  Tさくらベリーズガーデン  さくらべりーずがーでん  01  bbe379aaf618fd4e0e5af55c1bd11b818dd4af68      2018-08-02 09:58:20  2018-03-09 00:00:00    2018-03-09 00:00:00  MG00000001  2018-03-09 17:39:27  AG01003373  View Edit Delete
AG01003374  01003374  T森巧治  もりたけじ  01  bbe379aaf618fd4e0e5af55c1bd11b818dd4af68      2018-06-26 12:06:56  2018-03-09 00:00:00    2018-03-09 00:00:00  MG00000001  2018-03-09 17:39:27  AG01003374  View Edit Delete
AG01003375  01003375  T中野真樹  なかののうえん  01  bbe379aaf618fd4e0e5af55c1bd11b818dd4af68      2024-01-23 08:13:40  2018-02-22 00:00:00    2018-02-22 00:00:00  MG00000001  2022-06-16 08:49:58  MG00000001  View Edit Delete
AG01003376  01003376  T梶原甲亮  かじわらこうすけ  01  52f6f70a27d83a8c15ac091e58f211ee7d0197d4      2023-08-21 16:56:38  2018-03-15 00:00:00    2018-03-15 00:00:00  MG00000001  2018-03-15 14:06:04  AG01003376  View Edit Delete
AG01003377  01003377  T権藤清  ごんどうきよし  01  58f4fd3c2c2dd87378f26bdd22b1bb2571336af3      2018-12-26 13:05:30  2018-03-20 00:00:00    2018-03-20 00:00:00  MG00000001  2018-03-20 00:00:00  MG00000001  View Edit Delete
AG01003378  01003378  T石橋ファーム  いしばしふぁーむ  01  58f4fd3c2c2dd87378f26bdd22b1bb2571336af3      2022-04-08 07:57:18  2018-03-22 00:00:00    2018-03-22 00:00:00  MG00000001  2018-03-22 00:00:00  MG00000001  View Edit Delete
AG01003379  01003379  T亀山農研  かめやまのうけん  01  bbe379aaf618fd4e0e5af55c1bd11b818dd4af68      2018-06-11 12:56:05  2018-03-27 00:00:00    2018-03-27 00:00:00  MG00000001  2018-03-27 17:39:27  AG01003370  View Edit Delete
AG01003380  01003380  T諸戸清士  もろとぐりーんらぼらとり  01  bbe379aaf618fd4e0e5af55c1bd11b818dd4af68      2024-01-20 09:06:40  2018-03-27 00:00:00    2018-03-27 00:00:00  MG00000001  2022-06-14 10:37:23  MG00000001  View Edit Delete

Page 21 of 256, showing 20 records out of 5104 total, starting on record 401, ending on 420

(default) 2 queries took 103 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 400, 20202030
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