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
AG01005631  01005631  T山帰来村(おかやま青果)  さんきらいむらおかやませいか  01  c429bccaaf941b3a2c604fc696a5fa6eb5651d2c        2023-08-21 00:00:00    2023-08-21 00:00:00  MG00000001  2023-08-21 00:00:00  MG00000001  View Edit Delete
AG01005632  01005632  T(直)久恵農園  ひさえのうえん  01  a414b2d4cfef84f98d8c45e856482cf9c215707c      2023-12-04 14:58:51  2023-08-23 00:00:00    2023-08-23 11:04:51  MG00000001  2023-08-23 11:04:51  MG00000001  View Edit Delete
AG01005633  01005633  T(直)タマアグリ株式会社  たまあぐり  01  a414b2d4cfef84f98d8c45e856482cf9c215707c      2024-01-04 13:59:46  2023-08-23 00:00:00    2023-08-23 00:00:00  MG00000001  2023-08-23 00:00:00  MG00000001  View Edit Delete
AG01005634  01005634  T(直)ベジバンク筑後  べじばんくちくご  01  a414b2d4cfef84f98d8c45e856482cf9c215707c      2024-01-23 12:43:19  2023-08-23 00:00:00    2023-08-23 00:00:00  MG00000001  2023-08-23 00:00:00  MG00000001  View Edit Delete
AG01005635  01005635  T(直)平 たけ子  たいらたけこ  01  a414b2d4cfef84f98d8c45e856482cf9c215707c      2023-09-01 18:03:58  2023-08-23 00:00:00    2023-08-23 00:00:00  MG00000001  2023-08-23 00:00:00  MG00000001  View Edit Delete
AG01005636  01005636  T(直)原野 さおり  はらのさおり  01  a414b2d4cfef84f98d8c45e856482cf9c215707c      2024-01-05 09:09:02  2023-08-23 00:00:00    2023-08-23 00:00:00  MG00000001  2023-08-23 00:00:00  MG00000001  View Edit Delete
AG01005637  01005637  T(直)河原 農園  かわはらのうえん  01  a414b2d4cfef84f98d8c45e856482cf9c215707c      2023-12-27 07:02:45  2023-08-23 00:00:00    2023-08-23 00:00:00  MG00000001  2023-08-23 00:00:00  MG00000001  View Edit Delete
AG01005638  01005638  T(直)古庄 修  ふるしょうおさむ  01  a414b2d4cfef84f98d8c45e856482cf9c215707c      2023-11-16 08:31:03  2023-08-23 00:00:00    2023-08-23 00:00:00  MG00000001  2023-08-23 00:00:00  MG00000001  View Edit Delete
AG01005639  01005639  T(直)大石 静  おおいししずか  01  a414b2d4cfef84f98d8c45e856482cf9c215707c      2023-08-28 15:39:17  2023-08-23 00:00:00    2023-08-23 00:00:00  MG00000001  2023-08-23 00:00:00  MG00000001  View Edit Delete
AG01005640  01005640  T(直)堤 澄男  つつみすみお  01  a414b2d4cfef84f98d8c45e856482cf9c215707c      2023-12-07 08:25:56  2023-08-23 00:00:00    2023-08-23 00:00:00  MG00000001  2023-08-23 00:00:00  MG00000001  View Edit Delete
AG01005641  01005641  T(直)江崎 なおみ  えざきなおみ  01  a414b2d4cfef84f98d8c45e856482cf9c215707c        2023-08-23 00:00:00    2023-08-23 00:00:00  MG00000001  2023-08-23 00:00:00  MG00000001  View Edit Delete
AG01005642  01005642  T(直)マルト農園  まるとのうえん  01  a414b2d4cfef84f98d8c45e856482cf9c215707c      2024-01-22 08:43:44  2023-08-23 00:00:00    2023-08-23 00:00:00  MG00000001  2023-08-23 00:00:00  MG00000001  View Edit Delete
AG01005643  01005643  T(直)早田農園  そうだのうえん  01  a414b2d4cfef84f98d8c45e856482cf9c215707c      2024-01-16 07:55:53  2023-08-23 00:00:00    2023-08-23 00:00:00  MG00000001  2023-08-23 00:00:00  MG00000001  View Edit Delete
AG01005644  01005644  T(直)加藤 逸美  かとういつみ  01  a414b2d4cfef84f98d8c45e856482cf9c215707c        2023-08-23 00:00:00    2023-08-23 00:00:00  MG00000001  2023-08-23 00:00:00  MG00000001  View Edit Delete
AG01005645  01005645  T(直)原 高広  はらたかひろ  01  a414b2d4cfef84f98d8c45e856482cf9c215707c      2024-01-22 12:09:25  2023-08-23 00:00:00    2023-08-23 00:00:00  MG00000001  2023-08-23 00:00:00  MG00000001  View Edit Delete
AG01005646  01005646  T(直)九州ベジタブルサプライ  きゅうしゅうべじたぶるさぷらい  01  a414b2d4cfef84f98d8c45e856482cf9c215707c      2024-01-21 10:17:40  2023-08-23 00:00:00    2023-08-23 00:00:00  MG00000001  2023-08-23 00:00:00  MG00000001  View Edit Delete
AG01005647  01005647  T(直)尾本 翔次郎  おもとしょうじろう  01  a414b2d4cfef84f98d8c45e856482cf9c215707c      2024-01-19 07:35:48  2023-08-23 00:00:00    2023-08-23 00:00:00  MG00000001  2023-08-23 00:00:00  MG00000001  View Edit Delete
AG01005648  01005648  T(直)松崎 大  まつざきひろし  01  a414b2d4cfef84f98d8c45e856482cf9c215707c      2023-11-29 08:30:34  2023-08-23 00:00:00    2023-08-23 00:00:00  MG00000001  2023-08-23 00:00:00  MG00000001  View Edit Delete
AG01005649  01005649  T(直)末博商店  すえひろしょうてん  01  a414b2d4cfef84f98d8c45e856482cf9c215707c      2023-10-14 08:53:11  2023-08-23 00:00:00    2023-08-23 00:00:00  MG00000001  2023-08-23 00:00:00  MG00000001  View Edit Delete
AG01005650  01005650  T(直)梅野 拓郎  うめのたくろう  01  a414b2d4cfef84f98d8c45e856482cf9c215707c      2023-09-09 07:53:25  2023-08-23 00:00:00    2023-08-23 00:00:00  MG00000001  2023-08-23 00:00:00  MG00000001  View Edit Delete

Page 114 of 256, showing 20 records out of 5104 total, starting on record 2261, ending on 2280

(default) 2 queries took 354 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`.`insert_user` asc LIMIT 2260, 202020279
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