Farmer Products

Id Farmer Trader Cmp Product Company Cd Co Product Cd Sys Product Cd Display Product Nm Display Product Fk Display Locality Farmer Edit Flg Brc Shipment Product Characters Brc Shipment Product Cd Brc Price Cd Brc Price Characters Shipment Start Month Shipment End Month Use Start Day Use End Day Del Flg Created Insert User Modified Update User Actions
1733733  AG01000723 01  32941 031  544824  90000  農産物24  のうさんぶつ24  奈良県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
17544824  12  2023-07-11 00:00:00    2023-04-11 00:00:00  MG00000001  2023-04-11 00:00:00  MG00000001  View Edit Delete
1733734  AG01000723 01  32942 031  544825  90000  農産物25  のうさんぶつ25  奈良県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
17544825  12  2023-07-11 00:00:00    2023-04-11 00:00:00  MG00000001  2023-04-11 00:00:00  MG00000001  View Edit Delete
1733735  AG01000723 01  32943 031  544826  90000  農産物26  のうさんぶつ26  奈良県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
17544826  12  2023-07-11 00:00:00    2023-04-11 00:00:00  MG00000001  2023-04-11 00:00:00  MG00000001  View Edit Delete
1733736  AG01000723 01  32944 031  544827  90000  農産物27  のうさんぶつ27  奈良県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
17544827  12  2023-07-11 00:00:00    2023-04-11 00:00:00  MG00000001  2023-04-11 00:00:00  MG00000001  View Edit Delete
1733737  AG01000723 01  32945 031  544828  90000  農産物28  のうさんぶつ28  奈良県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
17544828  12  2023-07-11 00:00:00    2023-04-11 00:00:00  MG00000001  2023-04-11 00:00:00  MG00000001  View Edit Delete
1733738  AG01000723 01  32946 031  544829  90000  農産物29  のうさんぶつ29  奈良県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
17544829  12  2023-07-11 00:00:00    2023-04-11 00:00:00  MG00000001  2023-04-11 00:00:00  MG00000001  View Edit Delete
1733739  AG01000723 01  32947 031  544830  90000  農産物30  のうさんぶつ30  奈良県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
17544830  12  2023-07-11 00:00:00    2023-04-11 00:00:00  MG00000001  2023-04-11 00:00:00  MG00000001  View Edit Delete
4530  AG01000762 01  6413 004  343074  90001  野菜  やさい  奈良県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2343074  12  2016-08-29 00:00:00    2016-08-30 12:26:48  MG00000001  2017-08-01 15:51:18  MG00000001  View Edit Delete
4531  AG01000762 01  6486 004  499074  90007  果物  くだもの  奈良県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2499074  12  2016-08-29 00:00:00    2016-08-30 12:26:48  MG00000001  2017-08-01 15:51:30  MG00000001  View Edit Delete
4702  AG01000851 01  6414 004  343095  90001  野菜  やさい  奈良県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2343095  12  2016-08-29 00:00:00    2016-08-30 12:26:49  MG00000001  2017-08-01 15:54:40  MG00000001  View Edit Delete
4703  AG01000851 01  6487 004  499095  90007  果物  くだもの  奈良県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2499095  12  2016-08-29 00:00:00    2016-08-30 12:26:49  MG00000001  2017-08-01 15:54:53  MG00000001  View Edit Delete
1733080  AG01000851 01  32288 031  557701  90002  のらぼうな  のらぼうな  奈良県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
17557701  12  2023-07-11 00:00:00    2023-04-11 00:00:00  MG00000001  2023-04-11 00:00:00  MG00000001  View Edit Delete
1733081  AG01000851 01  32289 031  557702  33920  菜の花  なのはな  奈良県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
17557702  12  2023-07-11 00:00:00    2023-04-11 00:00:00  MG00000001  2023-04-11 00:00:00  MG00000001  View Edit Delete
1733082  AG01000851 01  32290 031  557703  31800  ほうれん草  ほうれんそう  奈良県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
17557703  12  2023-07-11 00:00:00    2023-04-11 00:00:00  MG00000001  2023-04-11 00:00:00  MG00000001  View Edit Delete
1733083  AG01000851 01  32291 031  557704  90002  ビタミン菜  びたみんな  奈良県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
17557704  12  2023-07-11 00:00:00    2023-04-11 00:00:00  MG00000001  2023-04-11 00:00:00  MG00000001  View Edit Delete
1733084  AG01000851 01  32292 031  557705  30100  葉付大根  はづけだいこん  奈良県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
17557705  12  2023-07-11 00:00:00    2023-04-11 00:00:00  MG00000001  2023-04-11 00:00:00  MG00000001  View Edit Delete
1733085  AG01000851 01  32293 031  557706  30100  大根  だいこん  奈良県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
17557706  12  2023-07-11 00:00:00    2023-04-11 00:00:00  MG00000001  2023-04-11 00:00:00  MG00000001  View Edit Delete
1733086  AG01000851 01  32294 031  557707  31700  春キャベツ  はるきゃべつ  奈良県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
17557707  12  2023-07-11 00:00:00    2023-04-11 00:00:00  MG00000001  2023-04-11 00:00:00  MG00000001  View Edit Delete
1733087  AG01000851 01  32295 031  557708  90000  農産物08  のうさんぶつ08  奈良県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
17557708  12  2023-07-11 00:00:00    2023-04-11 00:00:00  MG00000001  2023-04-11 00:00:00  MG00000001  View Edit Delete
1733088  AG01000851 01  32296 031  557709  90000  農産物09  のうさんぶつ09  奈良県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
17557709  12  2023-07-11 00:00:00    2023-04-11 00:00:00  MG00000001  2023-04-11 00:00:00  MG00000001  View Edit Delete

Page 33 of 15485, showing 20 records out of 309681 total, starting on record 641, ending on 660

(default) 2 queries took 949 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SELECT `FarmerProduct`.`id`, `FarmerProduct`.`farmer_id`, `FarmerProduct`.`trader_id`, `FarmerProduct`.`cmp_product_id`, `FarmerProduct`.`company_cd`, `FarmerProduct`.`co_product_cd`, `FarmerProduct`.`sys_product_cd`, `FarmerProduct`.`display_product_nm`, `FarmerProduct`.`display_product_fk`, `FarmerProduct`.`display_locality`, `FarmerProduct`.`farmer_edit_status`, `FarmerProduct`.`brc_shipment_product_characters`, `FarmerProduct`.`brc_shipment_product_cd`, `FarmerProduct`.`brc_price_cd`, `FarmerProduct`.`brc_price_characters`, `FarmerProduct`.`company_shipment_cd`, `FarmerProduct`.`brc_type_flag`, `FarmerProduct`.`brc_mid_flag`, `FarmerProduct`.`val_pos_pattern`, `FarmerProduct`.`mid_checkdigit_flag`, `FarmerProduct`.`shipment_start_month`, `FarmerProduct`.`shipment_end_month`, `FarmerProduct`.`use_start_day`, `FarmerProduct`.`use_end_day`, `FarmerProduct`.`del_flg`, `FarmerProduct`.`created`, `FarmerProduct`.`insert_user`, `FarmerProduct`.`modified`, `FarmerProduct`.`update_user`, `Farmer`.`user_id`, `Farmer`.`agreement_start_day`, `Farmer`.`agreement_end_day`, `Farmer`.`plan_code`, `Farmer`.`agreement_amount`, `Farmer`.`rental_printer_sn`, `Farmer`.`rental_tablet_sn`, `Farmer`.`rental_tablet_tel`, `Farmer`.`rental_tablet_gmail`, `Farmer`.`label_flg`, `Farmer`.`seal_flg`, `Farmer`.`blog_flg`, `Farmer`.`log_save_number`, `Farmer`.`user_post_number`, `Farmer`.`user_address`, `Farmer`.`user_tel`, `Farmer`.`qr_url`, `Farmer`.`notification_file`, `Farmer`.`plain_password`, `Farmer`.`admin_memo`, `Farmer`.`biz_browser_authorized_devices_count`, `Farmer`.`biz_browser_authorized_devices_limit`, `Farmer`.`created`, `Farmer`.`insert_user`, `Farmer`.`modified`, `Farmer`.`update_user`, `CmpProduct`.`id`, `CmpProduct`.`trader_id`, `CmpProduct`.`company_cd`, `CmpProduct`.`co_product_cd`, `CmpProduct`.`co_product_nm`, `CmpProduct`.`co_product_reciept_nm`, `CmpProduct`.`co_product_fk`, `CmpProduct`.`sys_product_cd`, `CmpProduct`.`farmer_linked_flag`, `CmpProduct`.`limited_user_id`, `CmpProduct`.`barcode_generate_pattern`, `CmpProduct`.`barcode_display_format`, `CmpProduct`.`use_start_day`, `CmpProduct`.`use_end_day`, `CmpProduct`.`created`, `CmpProduct`.`insert_user`, `CmpProduct`.`modified`, `CmpProduct`.`update_user`, `SysProduct`.`sys_product_cd`, `SysProduct`.`sys_product_nm`, `SysProduct`.`sys_product_fk`, `SysProduct`.`classify_cd`, `SysProduct`.`use_start_day`, `SysProduct`.`use_end_day`, `SysProduct`.`del_flg`, `SysProduct`.`created`, `SysProduct`.`insert_user`, `SysProduct`.`modified`, `SysProduct`.`update_user` FROM `sato_agri`.`farmer_products` AS `FarmerProduct` LEFT JOIN `sato_agri`.`farmers` AS `Farmer` ON (`FarmerProduct`.`farmer_id` = `Farmer`.`user_id`) LEFT JOIN `sato_agri`.`cmp_products` AS `CmpProduct` ON (`FarmerProduct`.`cmp_product_id` = `CmpProduct`.`id`) LEFT JOIN `sato_agri`.`sys_products` AS `SysProduct` ON (`FarmerProduct`.`sys_product_cd` = `SysProduct`.`sys_product_cd`) WHERE 1 = 1 ORDER BY `FarmerProduct`.`farmer_id` asc LIMIT 640, 2020206
2SELECT COUNT(*) AS `count` FROM `sato_agri`.`farmer_products` AS `FarmerProduct` LEFT JOIN `sato_agri`.`farmers` AS `Farmer` ON (`FarmerProduct`.`farmer_id` = `Farmer`.`user_id`) LEFT JOIN `sato_agri`.`cmp_products` AS `CmpProduct` ON (`FarmerProduct`.`cmp_product_id` = `CmpProduct`.`id`) LEFT JOIN `sato_agri`.`sys_products` AS `SysProduct` ON (`FarmerProduct`.`sys_product_cd` = `SysProduct`.`sys_product_cd`) WHERE 1 = 111943