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
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
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
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
146  42111  01 10 42  サンチョク  さんちょく  2022-07-20 10:09:11    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
149  42112  01 10 42  きばる(サンチョク)  きばるさんちょく  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
157  26006  01 5 26  IZ六地蔵店  いずみやむじぞう  2022-07-20 10:09:11    2000  1000  2000            View Edit Delete
140  00000  01 5 26  阪急オアシス買取  はんきゅうおあしすかいとりよう  2022-05-09 08:36:55    2000  1000  2000            View Edit Delete
144  00001  01 10 42  西鉄ストア果実  にしてつすとあかじつ  2022-05-09 08:36:55    2000  1000  2000            View Edit Delete
131  36018  01 9 36  東みよし町  ひがしみよしちょう  2021-07-08 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
133  29014  01 4 29  信貴山  しんぎさん  2021-07-08 00:00:00    2000  1000  2000            View Edit Delete
134  33027  01 20 33  アオキF(集荷)  あおきえふしゅうか  2021-07-08 00:00:00    2000  1000  2000            View Edit Delete
136  33029  01 20 33  アオキF(直納)  あおきえふしゅうのう  2021-07-08 00:00:00    2000  1000  2000            View Edit Delete
137  33028  01 20 33  秋山(センター)  あきやませんたー  2021-07-08 00:00:00    2000  1000  2000            View Edit Delete
138  33030  01 20 33  笠岡干拓(直納)  ささおかかんたく  2021-07-08 00:00:00    2000  1000  2000            View Edit Delete
139  28002  01 7 28  佐用町  さようちょう  2021-07-08 00:00:00    2000  1000  2000            View Edit Delete
142  33032  01 20 33  HF佐々木(センター)  えいちえふささきせんたー  2021-07-08 00:00:00    2000  1000  2000            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`.`use_start_day` desc 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