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
89  24001  01 2 24  三重県  みえけん  2017-09-19 15:31:55    2000  1000  2000  2017-09-19 15:32:07          View Edit Delete
109  24002  01 2 24  四日市市  よっかいちし  2020-02-19 09:26:05    2000  1000  2000            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
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
34  29001  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
35  29002  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
36  29003  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
37  29004  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
38  29005  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
39  29006  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
40  29007  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
41  29008  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
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

Page 1 of 8, showing 20 records out of 158 total, starting on record 1, ending on 20

< previous12345678
(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_id` asc LIMIT 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