Pickup Points

Id Pickup Point Cd Trader Locality Locality Cd Pickup Point Nm Pickup Point Fk Use Start Day Use End Day Remain Label Roll Threshold Label Roll Inventory Label Roll Inventory Date Created Insert User Modified Update User Actions
104  33007  01 20 33  真庭市HF  まにわしえいちえふ  2019-10-23 09:40:09    2000  1000  2000            View Edit Delete
108  33008  01 20 33  真庭市AG  まにわしえいじー  2019-10-23 09:40:09    2000  1000  2000            View Edit Delete
110  33010  01 20 33  ATT  えーてぃーてぃー  2019-06-13 09:53:21    2000  1000  2000            View Edit Delete
111  33009  01 20 33  ATT西大寺店  えーてぃーてぃーにしだいじてん  2019-06-13 09:53:21    2000  1000  2000            View Edit Delete
115  33018  01 20 33  落合出荷組合(集荷)  おちあいしゅっかくみあいしゅうか  2021-01-18 00:00:00    2000  1000  2000  2021-01-18 12:23:16  2021-01-18 14:03:51  MG00000001      View Edit Delete
116  33019  01 20 33  落合出荷組合(直納)  おちあいしゅっかくみあいちょくのう  2021-01-20 00:00:00    2000  1000  2000  2021-01-18 12:23:16  2021-01-18 14:03:51  MG00000001      View Edit Delete
117  33011  01 20 33  山根(センター)  やまねせんたー  2021-01-20 00:00:00    2000  1000  2000  2021-01-18 12:23:16  2021-01-18 14:03:51  MG00000001      View Edit Delete
118  33012  01 20 33  山根西大寺店(集荷)  やまねにしおおでらてんしゅうか  2021-01-20 00:00:00    2000  1000  2000  2021-01-18 12:23:16  2021-01-18 14:03:51  MG00000001      View Edit Delete
119  33016  01 20 33  池田農園(集荷)  いけだのうえんしゅうか  2021-01-20 00:00:00    2000  1000  2000  2021-01-18 12:23:16  2021-01-18 14:03:51  MG00000001      View Edit Delete
120  33017  01 20 33  池田農園(直納)  いけだのうえんちょくのう  2021-01-20 00:00:00    2000  1000  2000  2021-01-18 12:23:16  2021-01-18 14:03:51  MG00000001      View Edit Delete
121  33015  01 20 33  農愛会(直納)  のうあいかいちょくのう  2021-03-08 00:00:00    2000  1000  2000  2021-01-18 12:23:16  2021-01-18 14:03:51  MG00000001      View Edit Delete
122  33022  01 20 33  HFR2(直納)  えいちえふあーるちょくのう  2021-01-20 00:00:00    2000  1000  2000  2021-01-18 12:23:16  2021-01-18 14:03:51  MG00000001      View Edit Delete
123  33023  01 20 33  HFR2(集荷)  えいちえふあーるしゅうか  2021-01-20 00:00:00    2000  1000  2000  2021-01-18 12:23:16  2021-01-18 14:03:51  MG00000001      View Edit Delete
128  33021  01 20 33  岡山大学(直納)  おかやまだいがくちょくのう  2021-01-20 00:00:00    2000  1000  2000  2021-01-18 12:23:16  2021-01-18 14:03:51  MG00000001      View Edit Delete
129  33024  01 20 33  岡山大学(センター)  おかやまだいがくせんたー  2021-01-20 00:00:00    2000  1000  2000  2021-01-18 12:23:16  2021-01-18 14:03:51  MG00000001      View Edit Delete
134  33027  01 20 33  アオキF(集荷)  あおきえふしゅうか  2021-07-08 00:00:00    2000  1000  2000            View Edit Delete
136  33029  01 20 33  アオキF(直納)  あおきえふしゅうのう  2021-07-08 00:00:00    2000  1000  2000            View Edit Delete
137  33028  01 20 33  秋山(センター)  あきやませんたー  2021-07-08 00:00:00    2000  1000  2000            View Edit Delete
138  33030  01 20 33  笠岡干拓(直納)  ささおかかんたく  2021-07-08 00:00:00    2000  1000  2000            View Edit Delete
142  33032  01 20 33  HF佐々木(センター)  えいちえふささきせんたー  2021-07-08 00:00:00    2000  1000  2000            View Edit Delete

Page 4 of 8, showing 20 records out of 158 total, starting on record 61, ending on 80

(default) 2 queries took 2 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SELECT `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`, `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`, `Locality`.`id`, `Locality`.`trader_id`, `Locality`.`locality_cd`, `Locality`.`locality_nm`, `Locality`.`use_start_day`, `Locality`.`use_end_day`, `Locality`.`created`, `Locality`.`insert_user`, `Locality`.`modified`, `Locality`.`update_user` FROM `sato_agri`.`pickup_points` AS `PickupPoint` LEFT JOIN `sato_agri`.`traders` AS `Trader` ON (`PickupPoint`.`trader_id` = `Trader`.`id`) LEFT JOIN `sato_agri`.`localities` AS `Locality` ON (`PickupPoint`.`locality_id` = `Locality`.`id`) WHERE 1 = 1 ORDER BY `PickupPoint`.`locality_cd` desc LIMIT 60, 2020201
2SELECT COUNT(*) AS `count` FROM `sato_agri`.`pickup_points` AS `PickupPoint` LEFT JOIN `sato_agri`.`traders` AS `Trader` ON (`PickupPoint`.`trader_id` = `Trader`.`id`) LEFT JOIN `sato_agri`.`localities` AS `Locality` ON (`PickupPoint`.`locality_id` = `Locality`.`id`) WHERE 1 = 1111