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
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
126  42103  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
130  42104  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
154  42106  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
125  42107  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
155  42108  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
146  42111  01 10 42  サンチョク  さんちょく  2022-07-20 10:09:11    2000  1000  2000            View Edit Delete
149  42112  01 10 42  きばる(サンチョク)  きばるさんちょく  2022-07-20 10:09:11    2000  1000  2000            View Edit Delete
90  43001  01 12 43  山都町  やまとちょう  2017-10-30 09:57:55    2000  1000  2000            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
92  AM01  07 16 28  山陽Amnak  さんようあむなっく  2017-12-22 13:11:02    2000  1000  2000            View Edit Delete
93  ARA01  08 17 14  荒井ベジアス  あらいべじあす  2018-03-08 17:02:00    2000  1000  2000  2018-03-08 17:02:14  2018-03-08 17:02:19  MG00000001  2017-04-18 13:36:00  MG00000001  View Edit Delete
135  IZ001  06 6 27  いずみファーマーズ  いずみふぁーまーず  2017-12-22 13:11:02    2000  1000  2000            View Edit Delete
80  MZ01  02 14 36  南風ベジタブル  まぜべじたぶる  2017-02-22 00:00:00    2000  1000  2000  2017-02-22 00:00:00          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
91  OK01  05 15 15  奥村商事  おくむらしょうじ  2017-11-01 13:11:02    2000  1000  2000            View Edit Delete
145  OK02  04 15 15  奥村商事  おくむらしょうじ  2017-11-01 13:11:02    2000  1000  2000            View Edit Delete
86  SR01  03 13 20  駿河屋魚一  するがやうおいち  2017-05-11 00:00:00    2000  1000  2000  2017-05-11 00:00:00          View Edit Delete

Page 8 of 8, showing 18 records out of 158 total, starting on record 141, ending on 158

(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_cd` asc LIMIT 140, 2018181
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