Order Label Roll Logs

Purchase Number Order Number Pickup Point Order Label Roll No Order Day Order User Receipt Day Receipt User Created Insert User Modified Update User Actions

Page 1 of 1, showing 0 records out of 0 total, starting on record 0, ending on 0

< previousnext >
(default) 1 query took 1 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SELECT `OrderLabelRollLog`.`purchase_number`, `OrderLabelRollLog`.`order_number`, `OrderLabelRollLog`.`pickup_point_id`, `OrderLabelRollLog`.`order_label_roll_no`, `OrderLabelRollLog`.`order_day`, `OrderLabelRollLog`.`order_user_id`, `OrderLabelRollLog`.`receipt_day`, `OrderLabelRollLog`.`receipt_user_id`, `OrderLabelRollLog`.`created`, `OrderLabelRollLog`.`insert_user`, `OrderLabelRollLog`.`modified`, `OrderLabelRollLog`.`update_user`, `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`, `OrderUser`.`id`, `OrderUser`.`login_id`, `OrderUser`.`user_nm`, `OrderUser`.`user_fk`, `OrderUser`.`user_type`, `OrderUser`.`password`, `OrderUser`.`mail_address_1`, `OrderUser`.`mail_address_2`, `OrderUser`.`login_rock_flg`, `OrderUser`.`last_login_day`, `OrderUser`.`use_start_day`, `OrderUser`.`use_end_day`, `OrderUser`.`del_flg`, `OrderUser`.`init_pass_flg`, `OrderUser`.`created`, `OrderUser`.`insert_user`, `OrderUser`.`modified`, `OrderUser`.`update_user`, `ReceiptUser`.`id`, `ReceiptUser`.`login_id`, `ReceiptUser`.`user_nm`, `ReceiptUser`.`user_fk`, `ReceiptUser`.`user_type`, `ReceiptUser`.`password`, `ReceiptUser`.`mail_address_1`, `ReceiptUser`.`mail_address_2`, `ReceiptUser`.`login_rock_flg`, `ReceiptUser`.`last_login_day`, `ReceiptUser`.`use_start_day`, `ReceiptUser`.`use_end_day`, `ReceiptUser`.`del_flg`, `ReceiptUser`.`init_pass_flg`, `ReceiptUser`.`created`, `ReceiptUser`.`insert_user`, `ReceiptUser`.`modified`, `ReceiptUser`.`update_user` FROM `sato_agri`.`order_label_roll_log` AS `OrderLabelRollLog` LEFT JOIN `sato_agri`.`pickup_points` AS `PickupPoint` ON (`OrderLabelRollLog`.`pickup_point_id` = `PickupPoint`.`id`) LEFT JOIN `sato_agri`.`users` AS `OrderUser` ON (`OrderLabelRollLog`.`order_user_id` = `OrderUser`.`id`) LEFT JOIN `sato_agri`.`users` AS `ReceiptUser` ON (`OrderLabelRollLog`.`receipt_user_id` = `ReceiptUser`.`id`) WHERE 1 = 1 ORDER BY `OrderLabelRollLog`.`receipt_day` asc LIMIT 20001