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
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
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
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
131  36018  01 9 36  東みよし町  ひがしみよしちょう  2021-07-08 00:00:00    2000  1000  2000            View Edit Delete
132  27005  01 6 27  IZ八尾店  いずやおてん  2021-07-08 00:00:00    2000  1000  2000            View Edit Delete
133  29014  01 4 29  信貴山  しんぎさん  2021-07-08 00:00:00    2000  1000  2000            View Edit Delete
134  33027  01 20 33  アオキF(集荷)  あおきえふしゅうか  2021-07-08 00:00:00    2000  1000  2000            View Edit Delete
136  33029  01 20 33  アオキF(直納)  あおきえふしゅうのう  2021-07-08 00:00:00    2000  1000  2000            View Edit Delete
137  33028  01 20 33  秋山(センター)  あきやませんたー  2021-07-08 00:00:00    2000  1000  2000            View Edit Delete
138  33030  01 20 33  笠岡干拓(直納)  ささおかかんたく  2021-07-08 00:00:00    2000  1000  2000            View Edit Delete
139  28002  01 7 28  佐用町  さようちょう  2021-07-08 00:00:00    2000  1000  2000            View Edit Delete
142  33032  01 20 33  HF佐々木(センター)  えいちえふささきせんたー  2021-07-08 00:00:00    2000  1000  2000            View Edit Delete
143  33033  01 20 33  HFアグリA(センター)  えいちえふあぐりえーせんたー  2021-07-08 00:00:00    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

Page 7 of 8, showing 20 records out of 158 total, starting on record 121, ending on 140

(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 120, 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