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
189  33057  01 20 33  (岡山)川口ふれあい市部会B  かわぐちふれあいしぶかい  2019-04-18 00:00:00    2000  1000  2000            View Edit Delete
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
194  33092  01 20 33  おかやま青果_250B  おかやませいか  2019-04-18 00:00:00    2000  1000  2000            View Edit Delete
195  33060  01 20 33  建部B  たけべ  2019-04-18 00:00:00    2000  1000  2000            View Edit Delete
196  33074  01 20 33  落合出荷組合(集荷)B  おちあいしゅっかくみあい  2019-04-18 00:00:00    2000  1000  2000            View Edit Delete
197  33075  01 20 33  落合出荷組合(直納)B  おちあいしゅっかくみあい  2019-04-18 00:00:00    2000  1000  2000            View Edit Delete
198  36019  01 9 36  徳島市B  とくしまし  2019-04-18 00:00:00    2000  1000  2000            View Edit Delete
199  36028  01 9 36  阿南市北部B  あなんしほくぶ  2019-04-18 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
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
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
105  40002  01 11 40  久留米  くるめ  2019-11-05 16:13:51    2000  1000  2000            View Edit Delete

Page 5 of 8, showing 20 records out of 158 total, starting on record 81, ending on 100

(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`.`use_start_day` asc LIMIT 80, 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