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
123  33023  01 20 33  HFR2(集荷)  えいちえふあーるしゅうか  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
124  42101  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
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
128  33021  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
129  33024  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
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
141  30003  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
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
200  123456  01 3 30  集荷場A  しゅうかじょう  2024-03-01 00:00:00    2000  1000  1000    2024-03-01 16:45:13  MG00000001  2024-03-01 16:45:13  MG00000001  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
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
201  123456  01 8 37  集荷場A  しゅうかじょう  2024-03-12 00:00:00    2000  1000  1000    2024-03-12 11:40:41  TR01000110  2024-03-12 11:40:41  TR01000110  View Edit Delete
202  123123  01 6 27  大阪集荷場  おおさかしゅうかじょう  2024-03-13 00:00:00    2000  1000  1000    2024-03-13 11:15:30  TR01000110  2024-03-13 11:15:30  TR01000110  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`.`insert_user` 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