Contractors

Id Farmer Trader Company Cd Created Insert User Modified Update User Actions
9587  AG06000006 06 661          View Edit Delete
9586  AG06000005 06 661          View Edit Delete
9585  AG06000004 06 661          View Edit Delete
9584  AG06000003 06 661  2022-03-15 13:58:12  MG00000001  2022-03-15 13:58:12  MG00000001  View Edit Delete
9583  AG02100104 02 53  2022-03-15 08:39:54  MG00000001  2022-03-15 08:39:54  MG00000001  View Edit Delete
9582  AG08000053 08 96  2022-03-14 09:05:46  MG00000001  2022-03-14 09:05:46  MG00000001  View Edit Delete
9580  AG06000002 06 661  2022-03-11 10:31:06  MG00000001  2022-03-11 10:31:06  MG00000001  View Edit Delete
9578  AG06000001 06 661  2022-03-09 15:28:43  MG00000001  2022-03-09 15:28:43  MG00000001  View Edit Delete
9575  AG01004074 01 006  2022-02-28 15:16:16  MG00000001  2022-02-28 15:16:16  MG00000001  View Edit Delete
9574  AG01004074 01 002  2022-02-28 15:15:23  MG00000001  2022-02-28 15:15:23  MG00000001  View Edit Delete
9570  AG01004641 01 002  2022-02-18 13:35:54  MG00000001  2022-02-18 13:35:54  MG00000001  View Edit Delete
9569  AG01004640 01 002  2022-02-18 13:31:53  MG00000001  2022-02-18 13:31:53  MG00000001  View Edit Delete
9568  AG01004639 01 002  2022-02-18 13:24:10  MG00000001  2022-02-18 13:24:10  MG00000001  View Edit Delete
9567  AG01004355 01 002  2022-02-18 13:08:19  MG00000001  2022-02-18 13:08:19  MG00000001  View Edit Delete
9566  AG01004613 01 002  2022-02-18 13:07:22  MG00000001  2022-02-18 13:07:22  MG00000001  View Edit Delete
9565  AG01001299 01 002  2022-02-18 11:54:36  MG00000001  2022-02-18 11:54:36  MG00000001  View Edit Delete
9564  AG01004606 01 002  2022-02-18 11:52:52  MG00000001  2022-02-18 11:52:52  MG00000001  View Edit Delete
9563  AG01000701 01 002  2022-02-18 11:40:08  MG00000001  2022-02-18 11:40:08  MG00000001  View Edit Delete
9562  AG01004609 01 002  2022-02-18 11:38:30  MG00000001  2022-02-18 11:38:30  MG00000001  View Edit Delete
9561  AG01001108 01 004  2016-08-30 12:24:22  MG00000001  2016-08-30 12:24:22  MG00000001  View Edit Delete

Page 282 of 373, showing 20 records out of 7458 total, starting on record 5621, ending on 5640

(default) 2 queries took 36 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SELECT `Contractor`.`id`, `Contractor`.`farmer_id`, `Contractor`.`trader_id`, `Contractor`.`company_cd`, `Contractor`.`created`, `Contractor`.`insert_user`, `Contractor`.`modified`, `Contractor`.`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`, `Trader`.`id`, `Trader`.`formal_trader_nm`, `Trader`.`formal_trader_fk`, `Trader`.`designation_file`, `Trader`.`use_start_day`, `Trader`.`use_end_day`, `Trader`.`margin_price_yen`, `Trader`.`created`, `Trader`.`insert_user`, `Trader`.`modified`, `Trader`.`update_user` FROM `sato_agri`.`contractors` AS `Contractor` LEFT JOIN `sato_agri`.`farmers` AS `Farmer` ON (`Contractor`.`farmer_id` = `Farmer`.`user_id`) LEFT JOIN `sato_agri`.`traders` AS `Trader` ON (`Contractor`.`trader_id` = `Trader`.`id`) WHERE 1 = 1 ORDER BY `Contractor`.`id` desc LIMIT 5620, 20202019
2SELECT COUNT(*) AS `count` FROM `sato_agri`.`contractors` AS `Contractor` LEFT JOIN `sato_agri`.`farmers` AS `Farmer` ON (`Contractor`.`farmer_id` = `Farmer`.`user_id`) LEFT JOIN `sato_agri`.`traders` AS `Trader` ON (`Contractor`.`trader_id` = `Trader`.`id`) WHERE 1 = 11117