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
109  24002  01 2 24  四日市市  よっかいちし  2020-02-19 09:26:05    2000  1000  2000            View Edit Delete
106  42009  01 10 42  山野  やまの  2019-11-06 16:00:59    2000  1000  2000            View Edit Delete
118  33012  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
162  33013  01 20 33  山根(直納)  やまねちょくのう  2021-07-08 00:00:00    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
90  43001  01 12 43  山都町  やまとちょう  2017-10-30 09:57:55    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
96  06001  01 19 06  山形市  やまがたし  2018-11-27 22:54:34    2000  1000  2000            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
172  33041  01 20 33  明治ごんぼう村(直納)A  めいじごんぼうむら  2019-04-18 00:00:00    2000  1000  2000            View Edit Delete
173  33042  01 20 33  明治ごんぼう村(直納)B  めいじごんぼうむら  2019-04-18 00:00:00    2000  1000  2000            View Edit Delete
174  33043  01 20 33  明治ごんぼう村(センター)A  めいじごんぼうむら  2019-04-18 00:00:00    2000  1000  2000            View Edit Delete
175  33044  01 20 33  明治ごんぼう村(センター)B  めいじごんぼうむら  2019-04-18 00:00:00    2000  1000  2000            View Edit Delete
112  40003  01 11 40  宮若市  みやわかし  2019-11-05 16:13:51    2000  1000  2000            View Edit Delete
51  36004  01 9 36  美馬市  みまし  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
161  27011  01 6 27  箕面市  みのおし  2021-07-08 00:00:00    2000  1000  2000            View Edit Delete
53  36006  01 9 36  美波町  みなみちょう  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
61  37001  01 8 37  三豊市  みとよし  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
124  42101  01 10 42  瑞穂(きばる)  みずほきばる  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 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`.`pickup_point_fk` 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