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
190  34002  01 24 34  瀬戸ふれあい市部会A  せとふれあいしぶかい  2019-04-18 00:00:00    2000  1000  2000            View Edit Delete
191  34003  01 24 34  瀬戸ふれあい市部会B  せとふれあいしぶかい  2019-04-18 00:00:00    2000  1000  2000            View Edit Delete
192  34005  01 24 34  川口ふれあい市部会B  かわぐちふれあいしぶかい  2019-04-18 00:00:00    2000  1000  2000            View Edit Delete
193  34007  01 24 34  大津野ふれあい市部会B  おおつのふれいあいしぶかい  2019-04-18 00:00:00    2000  1000  2000            View Edit Delete
127  02001  01 23 02  青森県  あおもりけん  2021-04-22 00:00:00    2000  1000  2000  2021-04-22 00:00:00  2021-04-22 00:00:00  MG00000005      View Edit Delete
114  44101  01 22 44  豊後大野(きばる)  ぶんごおおのきばる  2021-01-15 00:00:00    2000  1000  2000  2021-01-15 12:23:16  2021-01-15 12:23:37  MG00000005      View Edit Delete
107  41001  01 21 41  白石町  しらいしちょう  2019-11-11 16:40:56    2000  1000  2000            View Edit Delete
187  41002  01 21 42  あんくる佐賀  あんくるふくおか  2019-04-18 00:00:00    2000  1000  2000            View Edit Delete
97  33002  01 20 33  富谷選果場  とみたにせんかじょう  2019-04-09 00:00:00    2000  1000  2000            View Edit Delete
98  33003  01 20 33  はなやか西  はなやかにし  2019-04-10 00:00:00    2000  1000  2000            View Edit Delete
100  33001  01 20 33  JA岡山  じぇいえーおかやま  2019-05-16 08:54:19    2000  1000  2000            View Edit Delete
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

Page 1 of 8, showing 20 records out of 158 total, starting on record 1, ending on 20

< previous12345678
(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` desc LIMIT 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