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
42  29009  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
43  29010  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
44  29011  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
45  29099  01 4 29  MAB奈良  えむえいびいなら  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
79  29012  01 4 29  YAFキリン堂  わいえいえふきりんどう  2016-07-01 00:00:00  2016-07-31 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
133  29014  01 4 29  信貴山  しんぎさん  2021-07-08 00:00:00    2000  1000  2000            View Edit Delete
92  AM01  07 16 28  山陽Amnak  さんようあむなっく  2017-12-22 13:11:02    2000  1000  2000            View Edit Delete
139  28002  01 7 28  佐用町  さようちょう  2021-07-08 00:00:00    2000  1000  2000            View Edit Delete
81  27001  01 6 27  茨木市  いばらぎし  2016-08-29 00:00:00    2000  1000  2000  2017-04-18 13:36:00  2017-04-18 13:36:00  MG00000001  2017-04-18 13:36:00  MG00000001  View Edit Delete
99  27002  01 6 27  大阪和泉  おおさかいずみ  2019-04-18 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
135  IZ001  06 6 27  いずみファーマーズ  いずみふぁーまーず  2017-12-22 13:11:02    2000  1000  2000            View Edit Delete
147  27007  01 6 27  IZ枚方  いずみやひらかた  2022-07-20 10:09:11    2000  1000  2000            View Edit Delete
148  27006  01 6 27  IZ住道  いずみやすみのどう  2022-07-20 10:09:11    2000  1000  2000            View Edit Delete
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
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
169  27013  01 6 27  枚方穂谷  まいかたほたに  2019-04-18 00:00:00    2000  1000  2000            View Edit Delete
170  27017  01 6 27  泉南GF(大阪)  せんなん  2019-04-18 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`.`locality_cd` desc 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