Traders Pickup Points

Pickup Point Trader User Use Start Day Use End Day Created Insert User Modified Update User Actions
34  TR01000108 2019-03-27 00:00:00    2016-08-30 12:23:37  MG00000001  2019-03-27 14:12:14  MG00000001  View Edit Delete
36  TR01000107 0000-00-00 00:00:00    2018-03-23 17:57:53  MG00000002  2018-03-23 17:57:53  MG00000002  View Edit Delete
49  TR01000101 0000-00-00 00:00:00    2018-01-29 17:36:42  MG00000002  2018-01-29 17:36:42  MG00000002  View Edit Delete
49  TR01000100 0000-00-00 00:00:00    2018-01-29 17:25:48  MG00000002  2018-01-29 17:25:48  MG00000002  View Edit Delete
90  TR01000092 2017-10-30 00:00:00            View Edit Delete
89  TR01000091 2017-09-19 00:00:00            View Edit Delete
88  TR01000090 2017-09-19 00:00:00            View Edit Delete
87  TR01000089 2017-09-12 00:00:00            View Edit Delete
48  TR01000088 0000-00-00 00:00:00    2016-12-27 15:45:53  MG00000001  2016-12-27 15:45:53  MG00000001  View Edit Delete
90  TR01000082 2016-09-01 00:00:00    2016-09-01 14:09:25  MG00000001  2016-09-01 14:09:25  MG00000001  View Edit Delete
79  TR01000080 2016-07-01 00:00:00  2016-07-31 00:00:00  2016-08-30 12:23:37  MG00000001  2016-08-30 12:23:37  MG00000001  View Edit Delete
77  TR01000078 2016-08-29 00:00:00    2016-08-30 12:23:37  MG00000001  2016-08-30 12:23:37  MG00000001  View Edit Delete
76  TR01000077 2016-08-29 00:00:00    2016-08-30 12:23:37  MG00000001  2016-08-30 12:23:37  MG00000001  View Edit Delete
75  TR01000076 2016-07-01 00:00:00  2016-07-31 00:00:00  2016-08-30 12:23:37  MG00000001  2016-08-30 12:23:37  MG00000001  View Edit Delete
74  TR01000075 2016-07-01 00:00:00  2016-07-31 00:00:00  2016-08-30 12:23:37  MG00000001  2016-08-30 12:23:37  MG00000001  View Edit Delete
73  TR01000074 2016-07-01 00:00:00  2016-07-31 00:00:00  2016-08-30 12:23:37  MG00000001  2016-08-30 12:23:37  MG00000001  View Edit Delete
72  TR01000073 2016-07-01 00:00:00  2016-07-31 00:00:00  2016-08-30 12:23:37  MG00000001  2016-08-30 12:23:37  MG00000001  View Edit Delete
71  TR01000072 2016-07-01 00:00:00  2016-07-31 00:00:00  2016-08-30 12:23:37  MG00000001  2016-08-30 12:23:37  MG00000001  View Edit Delete
70  TR01000071 2016-07-01 00:00:00  2016-07-31 00:00:00  2016-08-30 12:23:37  MG00000001  2016-08-30 12:23:37  MG00000001  View Edit Delete
69  TR01000070 2016-08-29 00:00:00    2016-08-30 12:23:37  MG00000001  2016-08-30 12:23:37  MG00000001  View Edit Delete

Page 1 of 4, showing 20 records out of 61 total, starting on record 1, ending on 20

< previous1234
(default) 2 queries took 1 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SELECT `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`, `TraderUser`.`user_id`, `TraderUser`.`trader_id`, `TraderUser`.`created`, `TraderUser`.`insert_user`, `TraderUser`.`modified`, `TraderUser`.`update_user`, `PickupPoint`.`id`, `PickupPoint`.`pickup_point_cd`, `PickupPoint`.`trader_id`, `PickupPoint`.`locality_id`, `PickupPoint`.`locality_cd`, `PickupPoint`.`pickup_point_nm`, `PickupPoint`.`pickup_point_fk`, `PickupPoint`.`use_start_day`, `PickupPoint`.`use_end_day`, `PickupPoint`.`margin_price_yen`, `PickupPoint`.`remain_label_roll`, `PickupPoint`.`threshold_label_roll`, `PickupPoint`.`inventory_label_roll`, `PickupPoint`.`inventory_date`, `PickupPoint`.`created`, `PickupPoint`.`insert_user`, `PickupPoint`.`modified`, `PickupPoint`.`update_user`, `PickupPoint`.`password` FROM `sato_agri`.`traders_pickup_points` AS `TradersPickupPoint` LEFT JOIN `sato_agri`.`trader_users` AS `TraderUser` ON (`TradersPickupPoint`.`trader_user_id` = `TraderUser`.`user_id`) LEFT JOIN `sato_agri`.`pickup_points` AS `PickupPoint` ON (`TradersPickupPoint`.`trader_user_id` = `PickupPoint`.`id`) WHERE 1 = 1 ORDER BY `TradersPickupPoint`.`trader_user_id` desc LIMIT 2020201
2SELECT COUNT(*) AS `count` FROM `sato_agri`.`traders_pickup_points` AS `TradersPickupPoint` LEFT JOIN `sato_agri`.`trader_users` AS `TraderUser` ON (`TradersPickupPoint`.`trader_user_id` = `TraderUser`.`user_id`) LEFT JOIN `sato_agri`.`pickup_points` AS `PickupPoint` ON (`TradersPickupPoint`.`trader_user_id` = `PickupPoint`.`id`) WHERE 1 = 1110