Contractors

Id Farmer Trader Company Cd Created Insert User Modified Update User Actions
6603  AG01001263 01 005  2017-10-20 19:37:31  MG00000001  2017-10-20 19:37:31  MG00000001  View Edit Delete
6602  AG01001262 01 005  2017-10-20 19:37:31  MG00000001  2017-10-20 19:37:31  MG00000001  View Edit Delete
6601  AG01001261 01 005  2017-10-20 19:37:31  MG00000001  2017-10-20 19:37:31  MG00000001  View Edit Delete
6600  AG01001260 01 005  2017-10-20 19:37:31  MG00000001  2017-10-20 19:37:31  MG00000001  View Edit Delete
6599  AG01001259 01 005  2017-10-20 19:37:31  MG00000001  2017-10-20 19:37:31  MG00000001  View Edit Delete
6598  AG01001258 01 005  2017-10-20 19:37:31  MG00000001  2017-10-20 19:37:31  MG00000001  View Edit Delete
6597  AG01001257 01 005  2017-10-20 19:37:31  MG00000001  2017-10-20 19:37:31  MG00000001  View Edit Delete
6596  AG01001256 01 005  2017-10-20 19:37:31  MG00000001  2017-10-20 19:37:31  MG00000001  View Edit Delete
6594  AG01001254 01 005  2017-10-20 19:37:31  MG00000001  2017-10-20 19:37:31  MG00000001  View Edit Delete
6593  AG01001253 01 005  2017-10-20 19:37:31  MG00000001  2017-10-20 19:37:31  MG00000001  View Edit Delete
6592  AG01001252 01 005  2017-10-20 19:37:31  MG00000001  2017-10-20 19:37:31  MG00000001  View Edit Delete
6591  AG01001251 01 005  2017-10-20 19:37:31  MG00000001  2017-10-20 19:37:31  MG00000001  View Edit Delete
6590  AG01001250 01 005  2017-10-20 19:37:31  MG00000001  2017-10-20 19:37:31  MG00000001  View Edit Delete
6589  AG01001249 01 005  2017-10-20 19:37:31  MG00000001  2017-10-20 19:37:31  MG00000001  View Edit Delete
6588  AG01001248 01 005  2017-10-20 19:37:31  MG00000001  2017-10-20 19:37:31  MG00000001  View Edit Delete
6587  AG01001247 01 005  2017-10-20 19:37:31  MG00000001  2017-10-20 19:37:31  MG00000001  View Edit Delete
6470  AG01001168 01 006  2017-10-20 19:37:30  MG00000001  2017-10-20 19:37:30  MG00000001  View Edit Delete
6380  AG02000059 02 51          View Edit Delete
6379  AG02000058 02 51          View Edit Delete
6378  AG02000057 02 51          View Edit Delete

Page 353 of 373, showing 20 records out of 7458 total, starting on record 7041, ending on 7060

(default) 2 queries took 40 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 7040, 20202024
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 = 11116