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
68  37007  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
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
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
113  36017  01 9 36  NNR吉野川市  えぬえぬあーるよしのがわし  2016-08-29 00:00:00    2000  1000  2000  2016-08-30 12:23:16  2016-08-30 12:23:37  MG00000001  2016-09-20 10:12:42  TR01000082  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
80  MZ01  02 14 36  南風ベジタブル  まぜべじたぶる  2017-02-22 00:00:00    2000  1000  2000  2017-02-22 00:00:00          View Edit Delete
81  27001  01 6 27  茨木市  いばらぎし  2016-08-29 00:00:00    2000  1000  2000  2017-04-18 13:36:00  2017-04-18 13:36:00  MG00000001  2017-04-18 13:36:00  MG00000001  View Edit Delete
82  36012  01 9 36  阿南市北部2  あなんしほくぶに  2016-08-29 00:00:00    2000  1000  2000  2017-04-18 13:36:00  2017-04-18 13:36:00  MG00000001  2017-04-18 13:36:00  MG00000001  View Edit Delete
83  36013  01 9 36  阿南市北部3  あなんしほくぶさん  2016-08-29 00:00:00    2000  1000  2000  2017-04-18 13:36:00  2017-04-18 13:36:00  MG00000001  2017-04-18 13:36:00  MG00000001  View Edit Delete
84  40001  01 11 40  須恵  すえ  2016-07-01 00:00:00    2000  1000  2000  2017-04-18 13:36:00  2017-04-18 13:36:00  MG00000001  2017-04-18 13:36:00  MG00000001  View Edit Delete
86  SR01  03 13 20  駿河屋魚一  するがやうおいち  2017-05-11 00:00:00    2000  1000  2000  2017-05-11 00:00:00          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
89  24001  01 2 24  三重県  みえけん  2017-09-19 15:31:55    2000  1000  2000  2017-09-19 15:32:07          View Edit Delete
93  ARA01  08 17 14  荒井ベジアス  あらいべじあす  2018-03-08 17:02:00    2000  1000  2000  2018-03-08 17:02:14  2018-03-08 17:02:19  MG00000001  2017-04-18 13:36:00  MG00000001  View Edit Delete
94  NR01  09 18 37  日本農産流通株式会社  にほんのうさんりゅうつうかぶしきがいしゃ  2018-06-15 00:00:00    2000  1000  2000  2018-06-15 17:17:12  2018-06-15 17:17:23    2018-06-15 17:17:26    View Edit Delete
114  44101  01 22 44  豊後大野(きばる)  ぶんごおおのきばる  2021-01-15 00:00:00    2000  1000  2000  2021-01-15 12:23:16  2021-01-15 12:23:37  MG00000005      View Edit Delete
115  33018  01 20 33  落合出荷組合(集荷)  おちあいしゅっかくみあいしゅうか  2021-01-18 00:00:00    2000  1000  2000  2021-01-18 12:23:16  2021-01-18 14:03:51  MG00000001      View Edit Delete
116  33019  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
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

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`.`inventory_date` asc 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