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
199  36028  01 9 36  阿南市北部B  あなんしほくぶ  2019-04-18 00:00:00    2000  1000  2000            View Edit Delete
198  36019  01 9 36  徳島市B  とくしまし  2019-04-18 00:00:00    2000  1000  2000            View Edit Delete
197  33075  01 20 33  落合出荷組合(直納)B  おちあいしゅっかくみあい  2019-04-18 00:00:00    2000  1000  2000            View Edit Delete
196  33074  01 20 33  落合出荷組合(集荷)B  おちあいしゅっかくみあい  2019-04-18 00:00:00    2000  1000  2000            View Edit Delete
195  33060  01 20 33  建部B  たけべ  2019-04-18 00:00:00    2000  1000  2000            View Edit Delete
194  33092  01 20 33  おかやま青果_250B  おかやませいか  2019-04-18 00:00:00    2000  1000  2000            View Edit Delete
193  34007  01 24 34  大津野ふれあい市部会B  おおつのふれいあいしぶかい  2019-04-18 00:00:00    2000  1000  2000            View Edit Delete
192  34005  01 24 34  川口ふれあい市部会B  かわぐちふれあいしぶかい  2019-04-18 00:00:00    2000  1000  2000            View Edit Delete
191  34003  01 24 34  瀬戸ふれあい市部会B  せとふれあいしぶかい  2019-04-18 00:00:00    2000  1000  2000            View Edit Delete
190  34002  01 24 34  瀬戸ふれあい市部会A  せとふれあいしぶかい  2019-04-18 00:00:00    2000  1000  2000            View Edit Delete
189  33057  01 20 33  (岡山)川口ふれあい市部会B  かわぐちふれあいしぶかい  2019-04-18 00:00:00    2000  1000  2000            View Edit Delete
188  33056  01 20 33  高野青空市B  たかのあおぞらいち  2019-04-18 00:00:00    2000  1000  2000            View Edit Delete
187  41002  01 21 42  あんくる佐賀  あんくるふくおか  2019-04-18 00:00:00    2000  1000  2000            View Edit Delete
186  40008  01 11 40  あんくる福岡  あんくるふくおか  2019-04-18 00:00:00    2000  1000  2000            View Edit Delete
185  30004  01 3 30  泉南GF(和歌山)  せんなん  2019-04-18 00:00:00    2000  1000  2000            View Edit Delete
184  33051  01 20 33  井原市B  いはらし  2019-04-18 00:00:00    2000  1000  2000            View Edit Delete
183  33053  01 20 33  高島支部B  たかしましぶ  2019-04-18 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`.`id` 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