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
150  27008  01 6 27  IZ六地蔵店  いずみやろくじぞう  2022-07-20 10:09:11    2000  1000  2000            View Edit Delete
151  27009  01 6 27  河南町  かなんちょう  2019-04-18 00:00:00    2000  1000  2000            View Edit Delete
152  42100  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
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
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
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
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
157  26006  01 5 26  IZ六地蔵店  いずみやむじぞう  2022-07-20 10:09:11    2000  1000  2000            View Edit Delete
158  33035  01 20 33  HFループ(センター)  えいちえふるーぷ  2021-07-08 00:00:00    2000  1000  2000            View Edit Delete
159  33036  01 20 33  HF木村(センター)  えいちえふきむら  2021-07-08 00:00:00    2000  1000  2000            View Edit Delete
160  27010  01 6 27  IZ桑津店  いずみやくわつてん  2021-07-08 00:00:00    2000  1000  2000            View Edit Delete
161  27011  01 6 27  箕面市  みのおし  2021-07-08 00:00:00    2000  1000  2000            View Edit Delete
162  33013  01 20 33  山根(直納)  やまねちょくのう  2021-07-08 00:00:00    2000  1000  2000            View Edit Delete
163  33037  01 20 33  おかやま青果_250  おかやませいか  2021-07-08 00:00:00    2000  1000  2000            View Edit Delete
164  33039  01 20 33  おかやま青果_300  おかやませいか  2021-07-08 00:00:00    2000  1000  2000            View Edit Delete
165  33038  01 20 33  おかやま青果_280  おかやませいか  2021-07-08 00:00:00    2000  1000  2000            View Edit Delete
166  40004  01 11 40  ゼンキョウ店舗持込  ぜんきょうてんぽもちこみ  2021-07-08 00:00:00    2000  1000  2000            View Edit Delete
167  40005  01 11 40  コウヨウ(集荷)  こうようしゅうか  2021-07-08 00:00:00    2000  1000  2000            View Edit Delete
168  40006  01 11 40  コクヨウ(持込)  こくようもちこみ  2021-07-08 00:00:00    2000  1000  2000            View Edit Delete
169  27013  01 6 27  枚方穂谷  まいかたほたに  2019-04-18 00:00:00    2000  1000  2000            View Edit Delete

Page 4 of 8, showing 20 records out of 158 total, starting on record 61, ending on 80

(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`.`modified` asc LIMIT 60, 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