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
101  33004  01 20 33  建部  たけべ  2019-06-13 09:52:39    2000  1000  2000            View Edit Delete
102  33005  01 20 33  賀茂川  かもがわ  2019-06-13 09:53:21    2000  1000  2000            View Edit Delete
103  33006  01 20 33  はなやか中央  はなやかちゅうおう  2019-06-25 00:00:00    2000  1000  2000            View Edit Delete
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

Page 6 of 8, showing 20 records out of 158 total, starting on record 101, ending on 120

(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_id` asc LIMIT 100, 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