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
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
171  27014  01 6 27  和泉市A  いずみし  2019-04-18 00:00:00    2000  1000  2000            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
31  26001  01 5 26  木津川市  きづがわし  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
32  26002  01 5 26  亀岡市  かめおかし  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
33  26099  01 5 26  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
87  26003  01 5 26  日吉町  ひよしまち  2017-09-11 13:56:34    2000  1000  2000  2017-09-11 13:56:54          View Edit Delete
88  26004  01 5 26  久御山町  くみやまちょう  2017-09-19 15:24:40    2000  1000  2000  2017-09-19 15:25:00          View Edit Delete
95  26005  01 5 26  京丹波町  きょうたんばまち  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
140  00000  01 5 26  阪急オアシス買取  はんきゅうおあしすかいとりよう  2022-05-09 08:36:55    2000  1000  2000            View Edit Delete
157  26006  01 5 26  IZ六地蔵店  いずみやむじぞう  2022-07-20 10:09:11    2000  1000  2000            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

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_id` 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