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
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
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
46  30001  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
47  30002  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
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
185  30004  01 3 30  泉南GF(和歌山)  せんなん  2019-04-18 00:00:00    2000  1000  2000            View Edit Delete
178  31001  01 20 33  Palfo A  ぱるふぉ  2019-04-18 00:00:00    2000  1000  2000            View Edit Delete
179  31002  01 20 33  Palfo B  ぱるふぉ  2019-04-18 00:00:00    2000  1000  2000            View Edit Delete
100  33001  01 20 33  JA岡山  じぇいえーおかやま  2019-05-16 08:54:19    2000  1000  2000            View Edit Delete
97  33002  01 20 33  富谷選果場  とみたにせんかじょう  2019-04-09 00:00:00    2000  1000  2000            View Edit Delete
98  33003  01 20 33  はなやか西  はなやかにし  2019-04-10 00:00:00    2000  1000  2000            View Edit Delete
101  33004  01 20 33  建部  たけべ  2019-06-13 09:52:39    2000  1000  2000            View Edit Delete
102  33005  01 20 33  賀茂川  かもがわ  2019-06-13 09:53:21    2000  1000  2000            View Edit Delete
103  33006  01 20 33  はなやか中央  はなやかちゅうおう  2019-06-25 00:00:00    2000  1000  2000            View Edit Delete
104  33007  01 20 33  真庭市HF  まにわしえいちえふ  2019-10-23 09:40:09    2000  1000  2000            View Edit Delete
108  33008  01 20 33  真庭市AG  まにわしえいじー  2019-10-23 09:40:09    2000  1000  2000            View Edit Delete
111  33009  01 20 33  ATT西大寺店  えーてぃーてぃーにしだいじてん  2019-06-13 09:53:21    2000  1000  2000            View Edit Delete
110  33010  01 20 33  ATT  えーてぃーてぃー  2019-06-13 09:53:21    2000  1000  2000            View Edit Delete
117  33011  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

Page 3 of 8, showing 20 records out of 158 total, starting on record 41, ending on 60

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