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
188  33056  01 20 33  高野青空市B  たかのあおぞらいち  2019-04-18 00:00:00    2000  1000  2000            View Edit Delete
68  37007  01 8 37  高松市南部  たかまつしなんぶ  2016-08-29 00:00:00    2000  1000  2000  2016-08-30 12:23:16  2016-08-30 12:23:37  MG00000001  2016-08-30 12:23:37  MG00000001  View Edit Delete
101  33004  01 20 33  建部  たけべ  2019-06-13 09:52:39    2000  1000  2000            View Edit Delete
195  33060  01 20 33  建部B  たけべ  2019-04-18 00:00:00    2000  1000  2000            View Edit Delete
153  42102  01 10 42  大栄(きばる)  だいえいきばる  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
48  36001  01 9 36  徳島市  とくしまし  2016-08-29 00:00:00    2000  1000  2000  2016-08-30 12:23:16  2016-08-30 12:23:37  MG00000001  2016-09-20 10:12:42  TR01000082  View Edit Delete
198  36019  01 9 36  徳島市B  とくしまし  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
39  29006  01 4 29  奈良市  ならし  2016-08-29 00:00:00    2000  1000  2000  2016-08-30 12:23:16  2016-08-30 12:23:37  MG00000001  2016-08-30 12:23:37  MG00000001  View Edit Delete
52  36005  01 9 36  鳴門市  なるとし  2016-08-29 00:00:00    2000  1000  2000  2016-08-30 12:23:16  2016-08-30 12:23:37  MG00000001  2016-08-30 12:23:37  MG00000001  View Edit Delete
144  00001  01 10 42  西鉄ストア果実  にしてつすとあかじつ  2022-05-09 08:36:55    2000  1000  2000            View Edit Delete
94  NR01  09 18 37  日本農産流通株式会社  にほんのうさんりゅうつうかぶしきがいしゃ  2018-06-15 00:00:00    2000  1000  2000  2018-06-15 17:17:12  2018-06-15 17:17:23    2018-06-15 17:17:26    View Edit Delete
156  33034  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
47  30002  01 3 30  橋本市  はしもとし  2016-08-29 00:00:00    2000  1000  2000  2016-08-30 12:23:16  2016-08-30 12:23:37  MG00000001  2016-08-30 12:23:37  MG00000001  View Edit Delete
103  33006  01 20 33  はなやか中央  はなやかちゅうおう  2019-06-25 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
180  33049  01 20 33  はなやか東A  はなやかひがし  2019-04-18 00:00:00    2000  1000  2000            View Edit Delete
181  33050  01 20 33  はなやか東B  はなやかひがし  2019-04-18 00:00:00    2000  1000  2000            View Edit Delete
140  00000  01 5 26  阪急オアシス買取  はんきゅうおあしすかいとりよう  2022-05-09 08:36:55    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`.`pickup_point_fk` 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