/*"sqlid" = '1758741314631-qydj',"tasktype" = 'etlDevelopTask',"set_var.phased_scheduler_max_concurrency" = '1',"objtype" = 'TASK',"set_var.enable_phased_scheduler" = 'true',"exectype" = 'UPDATE',"fabric-jobId" = '172bbcbd-603d-c3fc-2352-82b8f93c0500',"set_var.pipeline_dop" = '1',"set_var.connector_scan_use_query_mem_ratio" = '0.1',"instanceid" = '4OeMKX1agQ-OTM2NW',"objid" = '4OeMKX1agQ',"logid" = 'pe6RBXkRup'*/ INSERT /*+ SET_VAR("enable_phased_scheduler"= 'true', "phased_scheduler_max_concurrency"= '1', "pipeline_dop"= '1', "connector_scan_use_query_mem_ratio"= '0.1') */ OVERWRITE `lake`.`saas_datalake`.`ods_db_dd_sale_order_list_info_f` (`tax_amount`, `post_amount`, `open_id`, `order_tag`, `biz_desc`, `mask_post_receiver`, `shop_order_tag_ui`, `shop_cost_amount`, `supermarket_order_serial_no`, `mask_post_addr`, `order_status`, `biz`, `recommend_end_ship_time`, `only_platform_cost_amount`, `order_amount`, `author_cost_amount`, `user_coordinate`, `order_type`, `app_id`, `modify_post_amount`, `promise_detail`, `d_car_shop_biz_data`, `open_address_id`, `create_time`, `order_expire_time`, `shop_name`, `buyer_words`, `promotion_amount`, `post_promotion_amount`, `promotion_shop_amount`, `finish_time`, `pay_time`, `user_id_info`, `shop_id`, `appointment_ship_time`, `total_promotion_amount`, `post_insurance_amount`, `exp_ship_time`, `address_tag_ui`, `channel_payment_no`, `order_status_desc`, `latest_receipt_time`, `order_id`, `serial_number_list`, `order_operate_record_list`, `order_phase_list`, `sub_b_type`, `ship_time`, `promise_info`, `user_nick_name`, `shop_period_purchase_info`, `post_origin_amount`, `recommend_start_ship_time`, `promotion_redpack_talent_amount`, `update_time`, `seller_remark_stars`, `earliest_receipt_time`, `promotion_platform_amount`, `sku_order_list`, `doudian_open_id`, `user_icon`, `pay_type`, `promotion_talent_amount`, `b_type`, `platform_cost_amount`, `promotion_redpack_platform_amount`, `encrypt_post_tel`, `modify_amount`, `consolidate_info`, `b_type_desc`, `promotion_detail`, `early_arrival`, `sub_b_type_desc`, `pay_amount`, `order_level`, `tax_amount_not_come_out`, `post_addr`, `logistics_info`, `main_status_desc`, `target_arrival_time`, `cancel_reason`, `aweme_id`, `order_type_desc`, `encrypt_post_receiver`, `seller_words`, `receipt_date`, `trade_type_desc`, `trade_type`, `promotion_redpack_amount`, `promotion_pay_amount`, `main_status`, `mask_post_tel`, `user_tag_ui`, `origin_data`, `yuce_cube_shop_id`, `yuce_tenant_id`, `yuce_task_instance_id`, `yuce_data_create_time`, `dt`) (SELECT `tax_amount`, `post_amount`, `open_id`, `order_tag`, `biz_desc`, `mask_post_receiver`, `shop_order_tag_ui`, `shop_cost_amount`, `supermarket_order_serial_no`, `mask_post_addr`, `order_status`, `biz`, `recommend_end_ship_time`, `only_platform_cost_amount`, `order_amount`, `author_cost_amount`, `user_coordinate`, `order_type`, `app_id`, `modify_post_amount`, `promise_detail`, `d_car_shop_biz_data`, `open_address_id`, `create_time`, `order_expire_time`, `shop_name`, `buyer_words`, `promotion_amount`, `post_promotion_amount`, `promotion_shop_amount`, `finish_time`, `pay_time`, `user_id_info`, `shop_id`, `appointment_ship_time`, `total_promotion_amount`, `post_insurance_amount`, `exp_ship_time`, `address_tag_ui`, `channel_payment_no`, `order_status_desc`, `latest_receipt_time`, `order_id`, `serial_number_list`, `order_operate_record_list`, `order_phase_list`, `sub_b_type`, `ship_time`, `promise_info`, `user_nick_name`, `shop_period_purchase_info`, `post_origin_amount`, `recommend_start_ship_time`, `promotion_redpack_talent_amount`, `update_time`, `seller_remark_stars`, `earliest_receipt_time`, `promotion_platform_amount`, `sku_order_list`, `doudian_open_id`, `user_icon`, `pay_type`, `promotion_talent_amount`, `b_type`, `platform_cost_amount`, `promotion_redpack_platform_amount`, `encrypt_post_tel`, `modify_amount`, `consolidate_info`, `b_type_desc`, `promotion_detail`, `early_arrival`, `sub_b_type_desc`, `pay_amount`, `order_level`, `tax_amount_not_come_out`, `post_addr`, `logistics_info`, `main_status_desc`, `target_arrival_time`, `cancel_reason`, `aweme_id`, `order_type_desc`, `encrypt_post_receiver`, `seller_words`, `receipt_date`, `trade_type_desc`, `trade_type`, `promotion_redpack_amount`, `promotion_pay_amount`, `main_status`, `mask_post_tel`, `user_tag_ui`, `origin_data`, `yuce_cube_shop_id`, `yuce_tenant_id`, `yuce_task_instance_id`, `yuce_data_create_time`, `dt` FROM (SELECT CASE WHEN CASE WHEN `ods_db_dd_sale_order_list_info_du`.`update_time` IS NOT NULL THEN `ods_db_dd_sale_order_list_info_du`.`update_time` ELSE '' END < CASE WHEN `t1`.`update_time` IS NOT NULL THEN `t1`.`update_time` ELSE '' END THEN `t1`.`tax_amount` ELSE `ods_db_dd_sale_order_list_info_du`.`tax_amount` END AS `tax_amount`, CASE WHEN CASE WHEN `ods_db_dd_sale_order_list_info_du`.`update_time` IS NOT NULL THEN `ods_db_dd_sale_order_list_info_du`.`update_time` ELSE '' END < CASE WHEN `t1`.`update_time` IS NOT NULL THEN `t1`.`update_time` ELSE '' END THEN `t1`.`post_amount` ELSE `ods_db_dd_sale_order_list_info_du`.`post_amount` END AS `post_amount`, CASE WHEN CASE WHEN `ods_db_dd_sale_order_list_info_du`.`update_time` IS NOT NULL THEN `ods_db_dd_sale_order_list_info_du`.`update_time` ELSE '' END < CASE WHEN `t1`.`update_time` IS NOT NULL THEN `t1`.`update_time` ELSE '' END THEN `t1`.`open_id` ELSE `ods_db_dd_sale_order_list_info_du`.`open_id` END AS `open_id`, CASE WHEN CASE WHEN `ods_db_dd_sale_order_list_info_du`.`update_time` IS NOT NULL THEN `ods_db_dd_sale_order_list_info_du`.`update_time` ELSE '' END < CASE WHEN `t1`.`update_time` IS NOT NULL THEN `t1`.`update_time` ELSE '' END THEN `t1`.`order_tag` ELSE `ods_db_dd_sale_order_list_info_du`.`order_tag` END AS `order_tag`, CASE WHEN CASE WHEN `ods_db_dd_sale_order_list_info_du`.`update_time` IS NOT NULL THEN `ods_db_dd_sale_order_list_info_du`.`update_time` ELSE '' END < CASE WHEN `t1`.`update_time` IS NOT NULL THEN `t1`.`update_time` ELSE '' END THEN `t1`.`biz_desc` ELSE `ods_db_dd_sale_order_list_info_du`.`biz_desc` END AS `biz_desc`, CASE WHEN CASE WHEN `ods_db_dd_sale_order_list_info_du`.`update_time` IS NOT NULL THEN `ods_db_dd_sale_order_list_info_du`.`update_time` ELSE '' END < CASE WHEN `t1`.`update_time` IS NOT NULL THEN `t1`.`update_time` ELSE '' END THEN `t1`.`mask_post_receiver` ELSE `ods_db_dd_sale_order_list_info_du`.`mask_post_receiver` END AS `mask_post_receiver`, CASE WHEN CASE WHEN `ods_db_dd_sale_order_list_info_du`.`update_time` IS NOT NULL THEN `ods_db_dd_sale_order_list_info_du`.`update_time` ELSE '' END < CASE WHEN `t1`.`update_time` IS NOT NULL THEN `t1`.`update_time` ELSE '' END THEN `t1`.`shop_order_tag_ui` ELSE `ods_db_dd_sale_order_list_info_du`.`shop_order_tag_ui` END AS `shop_order_tag_ui`, CASE WHEN CASE WHEN `ods_db_dd_sale_order_list_info_du`.`update_time` IS NOT NULL THEN `ods_db_dd_sale_order_list_info_du`.`update_time` ELSE '' END < CASE WHEN `t1`.`update_time` IS NOT NULL THEN `t1`.`update_time` ELSE '' END THEN `t1`.`shop_cost_amount` ELSE `ods_db_dd_sale_order_list_info_du`.`shop_cost_amount` END AS `shop_cost_amount`, CASE WHEN CASE WHEN `ods_db_dd_sale_order_list_info_du`.`update_time` IS NOT NULL THEN `ods_db_dd_sale_order_list_info_du`.`update_time` ELSE '' END < CASE WHEN `t1`.`update_time` IS NOT NULL THEN `t1`.`update_time` ELSE '' END THEN `t1`.`supermarket_order_serial_no` ELSE `ods_db_dd_sale_order_list_info_du`.`supermarket_order_serial_no` END AS `supermarket_order_serial_no`, CASE WHEN CASE WHEN `ods_db_dd_sale_order_list_info_du`.`update_time` IS NOT NULL THEN `ods_db_dd_sale_order_list_info_du`.`update_time` ELSE '' END < CASE WHEN `t1`.`update_time` IS NOT NULL THEN `t1`.`update_time` ELSE '' END THEN `t1`.`mask_post_addr` ELSE `ods_db_dd_sale_order_list_info_du`.`mask_post_addr` END AS `mask_post_addr`, CASE WHEN CASE WHEN `ods_db_dd_sale_order_list_info_du`.`update_time` IS NOT NULL THEN `ods_db_dd_sale_order_list_info_du`.`update_time` ELSE '' END < CASE WHEN `t1`.`update_time` IS NOT NULL THEN `t1`.`update_time` ELSE '' END THEN `t1`.`order_status` ELSE `ods_db_dd_sale_order_list_info_du`.`order_status` END AS `order_status`, CASE WHEN CASE WHEN `ods_db_dd_sale_order_list_info_du`.`update_time` IS NOT NULL THEN `ods_db_dd_sale_order_list_info_du`.`update_time` ELSE '' END < CASE WHEN `t1`.`update_time` IS NOT NULL THEN `t1`.`update_time` ELSE '' END THEN `t1`.`biz` ELSE `ods_db_dd_sale_order_list_info_du`.`biz` END AS `biz`, CASE WHEN CASE WHEN `ods_db_dd_sale_order_list_info_du`.`update_time` IS NOT NULL THEN `ods_db_dd_sale_order_list_info_du`.`update_time` ELSE '' END < CASE WHEN `t1`.`update_time` IS NOT NULL THEN `t1`.`update_time` ELSE '' END THEN `t1`.`recommend_end_ship_time` ELSE `ods_db_dd_sale_order_list_info_du`.`recommend_end_ship_time` END AS `recommend_end_ship_time`, CASE WHEN CASE WHEN `ods_db_dd_sale_order_list_info_du`.`update_time` IS NOT NULL THEN `ods_db_dd_sale_order_list_info_du`.`update_time` ELSE '' END < CASE WHEN `t1`.`update_time` IS NOT NULL THEN `t1`.`update_time` ELSE '' END THEN `t1`.`only_platform_cost_amount` ELSE `ods_db_dd_sale_order_list_info_du`.`only_platform_cost_amount` END AS `only_platform_cost_amount`, CASE WHEN CASE WHEN `ods_db_dd_sale_order_list_info_du`.`update_time` IS NOT NULL THEN `ods_db_dd_sale_order_list_info_du`.`update_time` ELSE '' END < CASE WHEN `t1`.`update_time` IS NOT NULL THEN `t1`.`update_time` ELSE '' END THEN `t1`.`order_amount` ELSE `ods_db_dd_sale_order_list_info_du`.`order_amount` END AS `order_amount`, CASE WHEN CASE WHEN `ods_db_dd_sale_order_list_info_du`.`update_time` IS NOT NULL THEN `ods_db_dd_sale_order_list_info_du`.`update_time` ELSE '' END < CASE WHEN `t1`.`update_time` IS NOT NULL THEN `t1`.`update_time` ELSE '' END THEN `t1`.`author_cost_amount` ELSE `ods_db_dd_sale_order_list_info_du`.`author_cost_amount` END AS `author_cost_amount`, CASE WHEN CASE WHEN `ods_db_dd_sale_order_list_info_du`.`update_time` IS NOT NULL THEN `ods_db_dd_sale_order_list_info_du`.`update_time` ELSE '' END < CASE WHEN `t1`.`update_time` IS NOT NULL THEN `t1`.`update_time` ELSE '' END THEN `t1`.`user_coordinate` ELSE `ods_db_dd_sale_order_list_info_du`.`user_coordinate` END AS `user_coordinate`, CASE WHEN CASE WHEN `ods_db_dd_sale_order_list_info_du`.`update_time` IS NOT NULL THEN `ods_db_dd_sale_order_list_info_du`.`update_time` ELSE '' END < CASE WHEN `t1`.`update_time` IS NOT NULL THEN `t1`.`update_time` ELSE '' END THEN `t1`.`order_type` ELSE `ods_db_dd_sale_order_list_info_du`.`order_type` END AS `order_type`, CASE WHEN CASE WHEN `ods_db_dd_sale_order_list_info_du`.`update_time` IS NOT NULL THEN `ods_db_dd_sale_order_list_info_du`.`update_time` ELSE '' END < CASE WHEN `t1`.`update_time` IS NOT NULL THEN `t1`.`update_time` ELSE '' END THEN `t1`.`app_id` ELSE `ods_db_dd_sale_order_list_info_du`.`app_id` END AS `app_id`, CASE WHEN CASE WHEN `ods_db_dd_sale_order_list_info_du`.`update_time` IS NOT NULL THEN `ods_db_dd_sale_order_list_info_du`.`update_time` ELSE '' END < CASE WHEN `t1`.`update_time` IS NOT NULL THEN `t1`.`update_time` ELSE '' END THEN `t1`.`modify_post_amount` ELSE `ods_db_dd_sale_order_list_info_du`.`modify_post_amount` END AS `modify_post_amount`, CASE WHEN CASE WHEN `ods_db_dd_sale_order_list_info_du`.`update_time` IS NOT NULL THEN `ods_db_dd_sale_order_list_info_du`.`update_time` ELSE '' END < CASE WHEN `t1`.`update_time` IS NOT NULL THEN `t1`.`update_time` ELSE '' END THEN `t1`.`promise_detail` ELSE `ods_db_dd_sale_order_list_info_du`.`promise_detail` END AS `promise_detail`, CASE WHEN CASE WHEN `ods_db_dd_sale_order_list_info_du`.`update_time` IS NOT NULL THEN `ods_db_dd_sale_order_list_info_du`.`update_time` ELSE '' END < CASE WHEN `t1`.`update_time` IS NOT NULL THEN `t1`.`update_time` ELSE '' END THEN `t1`.`d_car_shop_biz_data` ELSE `ods_db_dd_sale_order_list_info_du`.`d_car_shop_biz_data` END AS `d_car_shop_biz_data`, CASE WHEN CASE WHEN `ods_db_dd_sale_order_list_info_du`.`update_time` IS NOT NULL THEN `ods_db_dd_sale_order_list_info_du`.`update_time` ELSE '' END < CASE WHEN `t1`.`update_time` IS NOT NULL THEN `t1`.`update_time` ELSE '' END THEN `t1`.`open_address_id` ELSE `ods_db_dd_sale_order_list_info_du`.`open_address_id` END AS `open_address_id`, CASE WHEN CASE WHEN `ods_db_dd_sale_order_list_info_du`.`update_time` IS NOT NULL THEN `ods_db_dd_sale_order_list_info_du`.`update_time` ELSE '' END < CASE WHEN `t1`.`update_time` IS NOT NULL THEN `t1`.`update_time` ELSE '' END THEN `t1`.`create_time` ELSE `ods_db_dd_sale_order_list_info_du`.`create_time` END AS `create_time`, CASE WHEN CASE WHEN `ods_db_dd_sale_order_list_info_du`.`update_time` IS NOT NULL THEN `ods_db_dd_sale_order_list_info_du`.`update_time` ELSE '' END < CASE WHEN `t1`.`update_time` IS NOT NULL THEN `t1`.`update_time` ELSE '' END THEN `t1`.`order_expire_time` ELSE `ods_db_dd_sale_order_list_info_du`.`order_expire_time` END AS `order_expire_time`, CASE WHEN CASE WHEN `ods_db_dd_sale_order_list_info_du`.`update_time` IS NOT NULL THEN `ods_db_dd_sale_order_list_info_du`.`update_time` ELSE '' END < CASE WHEN `t1`.`update_time` IS NOT NULL THEN `t1`.`update_time` ELSE '' END THEN `t1`.`shop_name` ELSE `ods_db_dd_sale_order_list_info_du`.`shop_name` END AS `shop_name`, CASE WHEN CASE WHEN `ods_db_dd_sale_order_list_info_du`.`update_time` IS NOT NULL THEN `ods_db_dd_sale_order_list_info_du`.`update_time` ELSE '' END < CASE WHEN `t1`.`update_time` IS NOT NULL THEN `t1`.`update_time` ELSE '' END THEN `t1`.`buyer_words` ELSE `ods_db_dd_sale_order_list_info_du`.`buyer_words` END AS `buyer_words`, CASE WHEN CASE WHEN `ods_db_dd_sale_order_list_info_du`.`update_time` IS NOT NULL THEN `ods_db_dd_sale_order_list_info_du`.`update_time` ELSE '' END < CASE WHEN `t1`.`update_time` IS NOT NULL THEN `t1`.`update_time` ELSE '' END THEN `t1`.`promotion_amount` ELSE `ods_db_dd_sale_order_list_info_du`.`promotion_amount` END AS `promotion_amount`, CASE WHEN CASE WHEN `ods_db_dd_sale_order_list_info_du`.`update_time` IS NOT NULL THEN `ods_db_dd_sale_order_list_info_du`.`update_time` ELSE '' END < CASE WHEN `t1`.`update_time` IS NOT NULL THEN `t1`.`update_time` ELSE '' END THEN `t1`.`post_promotion_amount` ELSE `ods_db_dd_sale_order_list_info_du`.`post_promotion_amount` END AS `post_promotion_amount`, CASE WHEN CASE WHEN `ods_db_dd_sale_order_list_info_du`.`update_time` IS NOT NULL THEN `ods_db_dd_sale_order_list_info_du`.`update_time` ELSE '' END < CASE WHEN `t1`.`update_time` IS NOT NULL THEN `t1`.`update_time` ELSE '' END THEN `t1`.`promotion_shop_amount` ELSE `ods_db_dd_sale_order_list_info_du`.`promotion_shop_amount` END AS `promotion_shop_amount`, CASE WHEN CASE WHEN `ods_db_dd_sale_order_list_info_du`.`update_time` IS NOT NULL THEN `ods_db_dd_sale_order_list_info_du`.`update_time` ELSE '' END < CASE WHEN `t1`.`update_time` IS NOT NULL THEN `t1`.`update_time` ELSE '' END THEN `t1`.`finish_time` ELSE `ods_db_dd_sale_order_list_info_du`.`finish_time` END AS `finish_time`, CASE WHEN CASE WHEN `ods_db_dd_sale_order_list_info_du`.`update_time` IS NOT NULL THEN `ods_db_dd_sale_order_list_info_du`.`update_time` ELSE '' END < CASE WHEN `t1`.`update_time` IS NOT NULL THEN `t1`.`update_time` ELSE '' END THEN `t1`.`pay_time` ELSE `ods_db_dd_sale_order_list_info_du`.`pay_time` END AS `pay_time`, CASE WHEN CASE WHEN `ods_db_dd_sale_order_list_info_du`.`update_time` IS NOT NULL THEN `ods_db_dd_sale_order_list_info_du`.`update_time` ELSE '' END < CASE WHEN `t1`.`update_time` IS NOT NULL THEN `t1`.`update_time` ELSE '' END THEN `t1`.`user_id_info` ELSE `ods_db_dd_sale_order_list_info_du`.`user_id_info` END AS `user_id_info`, CASE WHEN CASE WHEN `ods_db_dd_sale_order_list_info_du`.`update_time` IS NOT NULL THEN `ods_db_dd_sale_order_list_info_du`.`update_time` ELSE '' END < CASE WHEN `t1`.`update_time` IS NOT NULL THEN `t1`.`update_time` ELSE '' END THEN `t1`.`shop_id` ELSE `ods_db_dd_sale_order_list_info_du`.`shop_id` END AS `shop_id`, CASE WHEN CASE WHEN `ods_db_dd_sale_order_list_info_du`.`update_time` IS NOT NULL THEN `ods_db_dd_sale_order_list_info_du`.`update_time` ELSE '' END < CASE WHEN `t1`.`update_time` IS NOT NULL THEN `t1`.`update_time` ELSE '' END THEN `t1`.`appointment_ship_time` ELSE `ods_db_dd_sale_order_list_info_du`.`appointment_ship_time` END AS `appointment_ship_time`, CASE WHEN CASE WHEN `ods_db_dd_sale_order_list_info_du`.`update_time` IS NOT NULL THEN `ods_db_dd_sale_order_list_info_du`.`update_time` ELSE '' END < CASE WHEN `t1`.`update_time` IS NOT NULL THEN `t1`.`update_time` ELSE '' END THEN `t1`.`total_promotion_amount` ELSE `ods_db_dd_sale_order_list_info_du`.`total_promotion_amount` END AS `total_promotion_amount`, CASE WHEN CASE WHEN `ods_db_dd_sale_order_list_info_du`.`update_time` IS NOT NULL THEN `ods_db_dd_sale_order_list_info_du`.`update_time` ELSE '' END < CASE WHEN `t1`.`update_time` IS NOT NULL THEN `t1`.`update_time` ELSE '' END THEN `t1`.`post_insurance_amount` ELSE `ods_db_dd_sale_order_list_info_du`.`post_insurance_amount` END AS `post_insurance_amount`, CASE WHEN CASE WHEN `ods_db_dd_sale_order_list_info_du`.`update_time` IS NOT NULL THEN `ods_db_dd_sale_order_list_info_du`.`update_time` ELSE '' END < CASE WHEN `t1`.`update_time` IS NOT NULL THEN `t1`.`update_time` ELSE '' END THEN `t1`.`exp_ship_time` ELSE `ods_db_dd_sale_order_list_info_du`.`exp_ship_time` END AS `exp_ship_time`, CASE WHEN CASE WHEN `ods_db_dd_sale_order_list_info_du`.`update_time` IS NOT NULL THEN `ods_db_dd_sale_order_list_info_du`.`update_time` ELSE '' END < CASE WHEN `t1`.`update_time` IS NOT NULL THEN `t1`.`update_time` ELSE '' END THEN `t1`.`address_tag_ui` ELSE `ods_db_dd_sale_order_list_info_du`.`address_tag_ui` END AS `address_tag_ui`, CASE WHEN CASE WHEN `ods_db_dd_sale_order_list_info_du`.`update_time` IS NOT NULL THEN `ods_db_dd_sale_order_list_info_du`.`update_time` ELSE '' END < CASE WHEN `t1`.`update_time` IS NOT NULL THEN `t1`.`update_time` ELSE '' END THEN `t1`.`channel_payment_no` ELSE `ods_db_dd_sale_order_list_info_du`.`channel_payment_no` END AS `channel_payment_no`, CASE WHEN CASE WHEN `ods_db_dd_sale_order_list_info_du`.`update_time` IS NOT NULL THEN `ods_db_dd_sale_order_list_info_du`.`update_time` ELSE '' END < CASE WHEN `t1`.`update_time` IS NOT NULL THEN `t1`.`update_time` ELSE '' END THEN `t1`.`order_status_desc` ELSE `ods_db_dd_sale_order_list_info_du`.`order_status_desc` END AS `order_status_desc`, CASE WHEN CASE WHEN `ods_db_dd_sale_order_list_info_du`.`update_time` IS NOT NULL THEN `ods_db_dd_sale_order_list_info_du`.`update_time` ELSE '' END < CASE WHEN `t1`.`update_time` IS NOT NULL THEN `t1`.`update_time` ELSE '' END THEN `t1`.`latest_receipt_time` ELSE `ods_db_dd_sale_order_list_info_du`.`latest_receipt_time` END AS `latest_receipt_time`, CASE WHEN CASE WHEN `ods_db_dd_sale_order_list_info_du`.`update_time` IS NOT NULL THEN `ods_db_dd_sale_order_list_info_du`.`update_time` ELSE '' END < CASE WHEN `t1`.`update_time` IS NOT NULL THEN `t1`.`update_time` ELSE '' END THEN `t1`.`order_id` ELSE `ods_db_dd_sale_order_list_info_du`.`order_id` END AS `order_id`, CASE WHEN CASE WHEN `ods_db_dd_sale_order_list_info_du`.`update_time` IS NOT NULL THEN `ods_db_dd_sale_order_list_info_du`.`update_time` ELSE '' END < CASE WHEN `t1`.`update_time` IS NOT NULL THEN `t1`.`update_time` ELSE '' END THEN `t1`.`serial_number_list` ELSE `ods_db_dd_sale_order_list_info_du`.`serial_number_list` END AS `serial_number_list`, CASE WHEN CASE WHEN `ods_db_dd_sale_order_list_info_du`.`update_time` IS NOT NULL THEN `ods_db_dd_sale_order_list_info_du`.`update_time` ELSE '' END < CASE WHEN `t1`.`update_time` IS NOT NULL THEN `t1`.`update_time` ELSE '' END THEN `t1`.`order_operate_record_list` ELSE `ods_db_dd_sale_order_list_info_du`.`order_operate_record_list` END AS `order_operate_record_list`, CASE WHEN CASE WHEN `ods_db_dd_sale_order_list_info_du`.`update_time` IS NOT NULL THEN `ods_db_dd_sale_order_list_info_du`.`update_time` ELSE '' END < CASE WHEN `t1`.`update_time` IS NOT NULL THEN `t1`.`update_time` ELSE '' END THEN `t1`.`order_phase_list` ELSE `ods_db_dd_sale_order_list_info_du`.`order_phase_list` END AS `order_phase_list`, CASE WHEN CASE WHEN `ods_db_dd_sale_order_list_info_du`.`update_time` IS NOT NULL THEN `ods_db_dd_sale_order_list_info_du`.`update_time` ELSE '' END < CASE WHEN `t1`.`update_time` IS NOT NULL THEN `t1`.`update_time` ELSE '' END THEN `t1`.`sub_b_type` ELSE `ods_db_dd_sale_order_list_info_du`.`sub_b_type` END AS `sub_b_type`, CASE WHEN CASE WHEN `ods_db_dd_sale_order_list_info_du`.`update_time` IS NOT NULL THEN `ods_db_dd_sale_order_list_info_du`.`update_time` ELSE '' END < CASE WHEN `t1`.`update_time` IS NOT NULL THEN `t1`.`update_time` ELSE '' END THEN `t1`.`ship_time` ELSE `ods_db_dd_sale_order_list_info_du`.`ship_time` END AS `ship_time`, CASE WHEN CASE WHEN `ods_db_dd_sale_order_list_info_du`.`update_time` IS NOT NULL THEN `ods_db_dd_sale_order_list_info_du`.`update_time` ELSE '' END < CASE WHEN `t1`.`update_time` IS NOT NULL THEN `t1`.`update_time` ELSE '' END THEN `t1`.`promise_info` ELSE `ods_db_dd_sale_order_list_info_du`.`promise_info` END AS `promise_info`, CASE WHEN CASE WHEN `ods_db_dd_sale_order_list_info_du`.`update_time` IS NOT NULL THEN `ods_db_dd_sale_order_list_info_du`.`update_time` ELSE '' END < CASE WHEN `t1`.`update_time` IS NOT NULL THEN `t1`.`update_time` ELSE '' END THEN `t1`.`user_nick_name` ELSE `ods_db_dd_sale_order_list_info_du`.`user_nick_name` END AS `user_nick_name`, CASE WHEN CASE WHEN `ods_db_dd_sale_order_list_info_du`.`update_time` IS NOT NULL THEN `ods_db_dd_sale_order_list_info_du`.`update_time` ELSE '' END < CASE WHEN `t1`.`update_time` IS NOT NULL THEN `t1`.`update_time` ELSE '' END THEN `t1`.`shop_period_purchase_info` ELSE `ods_db_dd_sale_order_list_info_du`.`shop_period_purchase_info` END AS `shop_period_purchase_info`, CASE WHEN CASE WHEN `ods_db_dd_sale_order_list_info_du`.`update_time` IS NOT NULL THEN `ods_db_dd_sale_order_list_info_du`.`update_time` ELSE '' END < CASE WHEN `t1`.`update_time` IS NOT NULL THEN `t1`.`update_time` ELSE '' END THEN `t1`.`post_origin_amount` ELSE `ods_db_dd_sale_order_list_info_du`.`post_origin_amount` END AS `post_origin_amount`, CASE WHEN CASE WHEN `ods_db_dd_sale_order_list_info_du`.`update_time` IS NOT NULL THEN `ods_db_dd_sale_order_list_info_du`.`update_time` ELSE '' END < CASE WHEN `t1`.`update_time` IS NOT NULL THEN `t1`.`update_time` ELSE '' END THEN `t1`.`recommend_start_ship_time` ELSE `ods_db_dd_sale_order_list_info_du`.`recommend_start_ship_time` END AS `recommend_start_ship_time`, CASE WHEN CASE WHEN `ods_db_dd_sale_order_list_info_du`.`update_time` IS NOT NULL THEN `ods_db_dd_sale_order_list_info_du`.`update_time` ELSE '' END < CASE WHEN `t1`.`update_time` IS NOT NULL THEN `t1`.`update_time` ELSE '' END THEN `t1`.`promotion_redpack_talent_amount` ELSE `ods_db_dd_sale_order_list_info_du`.`promotion_redpack_talent_amount` END AS `promotion_redpack_talent_amount`, CASE WHEN CASE WHEN `ods_db_dd_sale_order_list_info_du`.`update_time` IS NOT NULL THEN `ods_db_dd_sale_order_list_info_du`.`update_time` ELSE '' END < CASE WHEN `t1`.`update_time` IS NOT NULL THEN `t1`.`update_time` ELSE '' END THEN `t1`.`update_time` ELSE `ods_db_dd_sale_order_list_info_du`.`update_time` END AS `update_time`, CASE WHEN CASE WHEN `ods_db_dd_sale_order_list_info_du`.`update_time` IS NOT NULL THEN `ods_db_dd_sale_order_list_info_du`.`update_time` ELSE '' END < CASE WHEN `t1`.`update_time` IS NOT NULL THEN `t1`.`update_time` ELSE '' END THEN `t1`.`seller_remark_stars` ELSE `ods_db_dd_sale_order_list_info_du`.`seller_remark_stars` END AS `seller_remark_stars`, CASE WHEN CASE WHEN `ods_db_dd_sale_order_list_info_du`.`update_time` IS NOT NULL THEN `ods_db_dd_sale_order_list_info_du`.`update_time` ELSE '' END < CASE WHEN `t1`.`update_time` IS NOT NULL THEN `t1`.`update_time` ELSE '' END THEN `t1`.`earliest_receipt_time` ELSE `ods_db_dd_sale_order_list_info_du`.`earliest_receipt_time` END AS `earliest_receipt_time`, CASE WHEN CASE WHEN `ods_db_dd_sale_order_list_info_du`.`update_time` IS NOT NULL THEN `ods_db_dd_sale_order_list_info_du`.`update_time` ELSE '' END < CASE WHEN `t1`.`update_time` IS NOT NULL THEN `t1`.`update_time` ELSE '' END THEN `t1`.`promotion_platform_amount` ELSE `ods_db_dd_sale_order_list_info_du`.`promotion_platform_amount` END AS `promotion_platform_amount`, CASE WHEN CASE WHEN `ods_db_dd_sale_order_list_info_du`.`update_time` IS NOT NULL THEN `ods_db_dd_sale_order_list_info_du`.`update_time` ELSE '' END < CASE WHEN `t1`.`update_time` IS NOT NULL THEN `t1`.`update_time` ELSE '' END THEN `t1`.`sku_order_list` ELSE `ods_db_dd_sale_order_list_info_du`.`sku_order_list` END AS `sku_order_list`, CASE WHEN CASE WHEN `ods_db_dd_sale_order_list_info_du`.`update_time` IS NOT NULL THEN `ods_db_dd_sale_order_list_info_du`.`update_time` ELSE '' END < CASE WHEN `t1`.`update_time` IS NOT NULL THEN `t1`.`update_time` ELSE '' END THEN `t1`.`doudian_open_id` ELSE `ods_db_dd_sale_order_list_info_du`.`doudian_open_id` END AS `doudian_open_id`, CASE WHEN CASE WHEN `ods_db_dd_sale_order_list_info_du`.`update_time` IS NOT NULL THEN `ods_db_dd_sale_order_list_info_du`.`update_time` ELSE '' END < CASE WHEN `t1`.`update_time` IS NOT NULL THEN `t1`.`update_time` ELSE '' END THEN `t1`.`user_icon` ELSE `ods_db_dd_sale_order_list_info_du`.`user_icon` END AS `user_icon`, CASE WHEN CASE WHEN `ods_db_dd_sale_order_list_info_du`.`update_time` IS NOT NULL THEN `ods_db_dd_sale_order_list_info_du`.`update_time` ELSE '' END < CASE WHEN `t1`.`update_time` IS NOT NULL THEN `t1`.`update_time` ELSE '' END THEN `t1`.`pay_type` ELSE `ods_db_dd_sale_order_list_info_du`.`pay_type` END AS `pay_type`, CASE WHEN CASE WHEN `ods_db_dd_sale_order_list_info_du`.`update_time` IS NOT NULL THEN `ods_db_dd_sale_order_list_info_du`.`update_time` ELSE '' END < CASE WHEN `t1`.`update_time` IS NOT NULL THEN `t1`.`update_time` ELSE '' END THEN `t1`.`promotion_talent_amount` ELSE `ods_db_dd_sale_order_list_info_du`.`promotion_talent_amount` END AS `promotion_talent_amount`, CASE WHEN CASE WHEN `ods_db_dd_sale_order_list_info_du`.`update_time` IS NOT NULL THEN `ods_db_dd_sale_order_list_info_du`.`update_time` ELSE '' END < CASE WHEN `t1`.`update_time` IS NOT NULL THEN `t1`.`update_time` ELSE '' END THEN `t1`.`b_type` ELSE `ods_db_dd_sale_order_list_info_du`.`b_type` END AS `b_type`, CASE WHEN CASE WHEN `ods_db_dd_sale_order_list_info_du`.`update_time` IS NOT NULL THEN `ods_db_dd_sale_order_list_info_du`.`update_time` ELSE '' END < CASE WHEN `t1`.`update_time` IS NOT NULL THEN `t1`.`update_time` ELSE '' END THEN `t1`.`platform_cost_amount` ELSE `ods_db_dd_sale_order_list_info_du`.`platform_cost_amount` END AS `platform_cost_amount`, CASE WHEN CASE WHEN `ods_db_dd_sale_order_list_info_du`.`update_time` IS NOT NULL THEN `ods_db_dd_sale_order_list_info_du`.`update_time` ELSE '' END < CASE WHEN `t1`.`update_time` IS NOT NULL THEN `t1`.`update_time` ELSE '' END THEN `t1`.`promotion_redpack_platform_amount` ELSE `ods_db_dd_sale_order_list_info_du`.`promotion_redpack_platform_amount` END AS `promotion_redpack_platform_amount`, CASE WHEN CASE WHEN `ods_db_dd_sale_order_list_info_du`.`update_time` IS NOT NULL THEN `ods_db_dd_sale_order_list_info_du`.`update_time` ELSE '' END < CASE WHEN `t1`.`update_time` IS NOT NULL THEN `t1`.`update_time` ELSE '' END THEN `t1`.`encrypt_post_tel` ELSE `ods_db_dd_sale_order_list_info_du`.`encrypt_post_tel` END AS `encrypt_post_tel`, CASE WHEN CASE WHEN `ods_db_dd_sale_order_list_info_du`.`update_time` IS NOT NULL THEN `ods_db_dd_sale_order_list_info_du`.`update_time` ELSE '' END < CASE WHEN `t1`.`update_time` IS NOT NULL THEN `t1`.`update_time` ELSE '' END THEN `t1`.`modify_amount` ELSE `ods_db_dd_sale_order_list_info_du`.`modify_amount` END AS `modify_amount`, CASE WHEN CASE WHEN `ods_db_dd_sale_order_list_info_du`.`update_time` IS NOT NULL THEN `ods_db_dd_sale_order_list_info_du`.`update_time` ELSE '' END < CASE WHEN `t1`.`update_time` IS NOT NULL THEN `t1`.`update_time` ELSE '' END THEN `t1`.`consolidate_info` ELSE `ods_db_dd_sale_order_list_info_du`.`consolidate_info` END AS `consolidate_info`, CASE WHEN CASE WHEN `ods_db_dd_sale_order_list_info_du`.`update_time` IS NOT NULL THEN `ods_db_dd_sale_order_list_info_du`.`update_time` ELSE '' END < CASE WHEN `t1`.`update_time` IS NOT NULL THEN `t1`.`update_time` ELSE '' END THEN `t1`.`b_type_desc` ELSE `ods_db_dd_sale_order_list_info_du`.`b_type_desc` END AS `b_type_desc`, CASE WHEN CASE WHEN `ods_db_dd_sale_order_list_info_du`.`update_time` IS NOT NULL THEN `ods_db_dd_sale_order_list_info_du`.`update_time` ELSE '' END < CASE WHEN `t1`.`update_time` IS NOT NULL THEN `t1`.`update_time` ELSE '' END THEN `t1`.`promotion_detail` ELSE `ods_db_dd_sale_order_list_info_du`.`promotion_detail` END AS `promotion_detail`, CASE WHEN CASE WHEN `ods_db_dd_sale_order_list_info_du`.`update_time` IS NOT NULL THEN `ods_db_dd_sale_order_list_info_du`.`update_time` ELSE '' END < CASE WHEN `t1`.`update_time` IS NOT NULL THEN `t1`.`update_time` ELSE '' END THEN `t1`.`early_arrival` ELSE `ods_db_dd_sale_order_list_info_du`.`early_arrival` END AS `early_arrival`, CASE WHEN CASE WHEN `ods_db_dd_sale_order_list_info_du`.`update_time` IS NOT NULL THEN `ods_db_dd_sale_order_list_info_du`.`update_time` ELSE '' END < CASE WHEN `t1`.`update_time` IS NOT NULL THEN `t1`.`update_time` ELSE '' END THEN `t1`.`sub_b_type_desc` ELSE `ods_db_dd_sale_order_list_info_du`.`sub_b_type_desc` END AS `sub_b_type_desc`, CASE WHEN CASE WHEN `ods_db_dd_sale_order_list_info_du`.`update_time` IS NOT NULL THEN `ods_db_dd_sale_order_list_info_du`.`update_time` ELSE '' END < CASE WHEN `t1`.`update_time` IS NOT NULL THEN `t1`.`update_time` ELSE '' END THEN `t1`.`pay_amount` ELSE `ods_db_dd_sale_order_list_info_du`.`pay_amount` END AS `pay_amount`, CASE WHEN CASE WHEN `ods_db_dd_sale_order_list_info_du`.`update_time` IS NOT NULL THEN `ods_db_dd_sale_order_list_info_du`.`update_time` ELSE '' END < CASE WHEN `t1`.`update_time` IS NOT NULL THEN `t1`.`update_time` ELSE '' END THEN `t1`.`order_level` ELSE `ods_db_dd_sale_order_list_info_du`.`order_level` END AS `order_level`, CASE WHEN CASE WHEN `ods_db_dd_sale_order_list_info_du`.`update_time` IS NOT NULL THEN `ods_db_dd_sale_order_list_info_du`.`update_time` ELSE '' END < CASE WHEN `t1`.`update_time` IS NOT NULL THEN `t1`.`update_time` ELSE '' END THEN `t1`.`tax_amount_not_come_out` ELSE `ods_db_dd_sale_order_list_info_du`.`tax_amount_not_come_out` END AS `tax_amount_not_come_out`, CASE WHEN CASE WHEN `ods_db_dd_sale_order_list_info_du`.`update_time` IS NOT NULL THEN `ods_db_dd_sale_order_list_info_du`.`update_time` ELSE '' END < CASE WHEN `t1`.`update_time` IS NOT NULL THEN `t1`.`update_time` ELSE '' END THEN `t1`.`post_addr` ELSE `ods_db_dd_sale_order_list_info_du`.`post_addr` END AS `post_addr`, CASE WHEN CASE WHEN `ods_db_dd_sale_order_list_info_du`.`update_time` IS NOT NULL THEN `ods_db_dd_sale_order_list_info_du`.`update_time` ELSE '' END < CASE WHEN `t1`.`update_time` IS NOT NULL THEN `t1`.`update_time` ELSE '' END THEN `t1`.`logistics_info` ELSE `ods_db_dd_sale_order_list_info_du`.`logistics_info` END AS `logistics_info`, CASE WHEN CASE WHEN `ods_db_dd_sale_order_list_info_du`.`update_time` IS NOT NULL THEN `ods_db_dd_sale_order_list_info_du`.`update_time` ELSE '' END < CASE WHEN `t1`.`update_time` IS NOT NULL THEN `t1`.`update_time` ELSE '' END THEN `t1`.`main_status_desc` ELSE `ods_db_dd_sale_order_list_info_du`.`main_status_desc` END AS `main_status_desc`, CASE WHEN CASE WHEN `ods_db_dd_sale_order_list_info_du`.`update_time` IS NOT NULL THEN `ods_db_dd_sale_order_list_info_du`.`update_time` ELSE '' END < CASE WHEN `t1`.`update_time` IS NOT NULL THEN `t1`.`update_time` ELSE '' END THEN `t1`.`target_arrival_time` ELSE `ods_db_dd_sale_order_list_info_du`.`target_arrival_time` END AS `target_arrival_time`, CASE WHEN CASE WHEN `ods_db_dd_sale_order_list_info_du`.`update_time` IS NOT NULL THEN `ods_db_dd_sale_order_list_info_du`.`update_time` ELSE '' END < CASE WHEN `t1`.`update_time` IS NOT NULL THEN `t1`.`update_time` ELSE '' END THEN `t1`.`cancel_reason` ELSE `ods_db_dd_sale_order_list_info_du`.`cancel_reason` END AS `cancel_reason`, CASE WHEN CASE WHEN `ods_db_dd_sale_order_list_info_du`.`update_time` IS NOT NULL THEN `ods_db_dd_sale_order_list_info_du`.`update_time` ELSE '' END < CASE WHEN `t1`.`update_time` IS NOT NULL THEN `t1`.`update_time` ELSE '' END THEN `t1`.`aweme_id` ELSE `ods_db_dd_sale_order_list_info_du`.`aweme_id` END AS `aweme_id`, CASE WHEN CASE WHEN `ods_db_dd_sale_order_list_info_du`.`update_time` IS NOT NULL THEN `ods_db_dd_sale_order_list_info_du`.`update_time` ELSE '' END < CASE WHEN `t1`.`update_time` IS NOT NULL THEN `t1`.`update_time` ELSE '' END THEN `t1`.`order_type_desc` ELSE `ods_db_dd_sale_order_list_info_du`.`order_type_desc` END AS `order_type_desc`, CASE WHEN CASE WHEN `ods_db_dd_sale_order_list_info_du`.`update_time` IS NOT NULL THEN `ods_db_dd_sale_order_list_info_du`.`update_time` ELSE '' END < CASE WHEN `t1`.`update_time` IS NOT NULL THEN `t1`.`update_time` ELSE '' END THEN `t1`.`encrypt_post_receiver` ELSE `ods_db_dd_sale_order_list_info_du`.`encrypt_post_receiver` END AS `encrypt_post_receiver`, CASE WHEN CASE WHEN `ods_db_dd_sale_order_list_info_du`.`update_time` IS NOT NULL THEN `ods_db_dd_sale_order_list_info_du`.`update_time` ELSE '' END < CASE WHEN `t1`.`update_time` IS NOT NULL THEN `t1`.`update_time` ELSE '' END THEN `t1`.`seller_words` ELSE `ods_db_dd_sale_order_list_info_du`.`seller_words` END AS `seller_words`, CASE WHEN CASE WHEN `ods_db_dd_sale_order_list_info_du`.`update_time` IS NOT NULL THEN `ods_db_dd_sale_order_list_info_du`.`update_time` ELSE '' END < CASE WHEN `t1`.`update_time` IS NOT NULL THEN `t1`.`update_time` ELSE '' END THEN `t1`.`receipt_date` ELSE `ods_db_dd_sale_order_list_info_du`.`receipt_date` END AS `receipt_date`, CASE WHEN CASE WHEN `ods_db_dd_sale_order_list_info_du`.`update_time` IS NOT NULL THEN `ods_db_dd_sale_order_list_info_du`.`update_time` ELSE '' END < CASE WHEN `t1`.`update_time` IS NOT NULL THEN `t1`.`update_time` ELSE '' END THEN `t1`.`trade_type_desc` ELSE `ods_db_dd_sale_order_list_info_du`.`trade_type_desc` END AS `trade_type_desc`, CASE WHEN CASE WHEN `ods_db_dd_sale_order_list_info_du`.`update_time` IS NOT NULL THEN `ods_db_dd_sale_order_list_info_du`.`update_time` ELSE '' END < CASE WHEN `t1`.`update_time` IS NOT NULL THEN `t1`.`update_time` ELSE '' END THEN `t1`.`trade_type` ELSE `ods_db_dd_sale_order_list_info_du`.`trade_type` END AS `trade_type`, CASE WHEN CASE WHEN `ods_db_dd_sale_order_list_info_du`.`update_time` IS NOT NULL THEN `ods_db_dd_sale_order_list_info_du`.`update_time` ELSE '' END < CASE WHEN `t1`.`update_time` IS NOT NULL THEN `t1`.`update_time` ELSE '' END THEN `t1`.`promotion_redpack_amount` ELSE `ods_db_dd_sale_order_list_info_du`.`promotion_redpack_amount` END AS `promotion_redpack_amount`, CASE WHEN CASE WHEN `ods_db_dd_sale_order_list_info_du`.`update_time` IS NOT NULL THEN `ods_db_dd_sale_order_list_info_du`.`update_time` ELSE '' END < CASE WHEN `t1`.`update_time` IS NOT NULL THEN `t1`.`update_time` ELSE '' END THEN `t1`.`promotion_pay_amount` ELSE `ods_db_dd_sale_order_list_info_du`.`promotion_pay_amount` END AS `promotion_pay_amount`, CASE WHEN CASE WHEN `ods_db_dd_sale_order_list_info_du`.`update_time` IS NOT NULL THEN `ods_db_dd_sale_order_list_info_du`.`update_time` ELSE '' END < CASE WHEN `t1`.`update_time` IS NOT NULL THEN `t1`.`update_time` ELSE '' END THEN `t1`.`main_status` ELSE `ods_db_dd_sale_order_list_info_du`.`main_status` END AS `main_status`, CASE WHEN CASE WHEN `ods_db_dd_sale_order_list_info_du`.`update_time` IS NOT NULL THEN `ods_db_dd_sale_order_list_info_du`.`update_time` ELSE '' END < CASE WHEN `t1`.`update_time` IS NOT NULL THEN `t1`.`update_time` ELSE '' END THEN `t1`.`mask_post_tel` ELSE `ods_db_dd_sale_order_list_info_du`.`mask_post_tel` END AS `mask_post_tel`, CASE WHEN CASE WHEN `ods_db_dd_sale_order_list_info_du`.`update_time` IS NOT NULL THEN `ods_db_dd_sale_order_list_info_du`.`update_time` ELSE '' END < CASE WHEN `t1`.`update_time` IS NOT NULL THEN `t1`.`update_time` ELSE '' END THEN `t1`.`user_tag_ui` ELSE `ods_db_dd_sale_order_list_info_du`.`user_tag_ui` END AS `user_tag_ui`, CASE WHEN CASE WHEN `ods_db_dd_sale_order_list_info_du`.`update_time` IS NOT NULL THEN `ods_db_dd_sale_order_list_info_du`.`update_time` ELSE '' END < CASE WHEN `t1`.`update_time` IS NOT NULL THEN `t1`.`update_time` ELSE '' END THEN `t1`.`origin_data` ELSE `ods_db_dd_sale_order_list_info_du`.`origin_data` END AS `origin_data`, CASE WHEN CASE WHEN `ods_db_dd_sale_order_list_info_du`.`update_time` IS NOT NULL THEN `ods_db_dd_sale_order_list_info_du`.`update_time` ELSE '' END < CASE WHEN `t1`.`update_time` IS NOT NULL THEN `t1`.`update_time` ELSE '' END THEN `t1`.`yuce_cube_shop_id` ELSE `ods_db_dd_sale_order_list_info_du`.`yuce_cube_shop_id` END AS `yuce_cube_shop_id`, CASE WHEN CASE WHEN `ods_db_dd_sale_order_list_info_du`.`update_time` IS NOT NULL THEN `ods_db_dd_sale_order_list_info_du`.`update_time` ELSE '' END < CASE WHEN `t1`.`update_time` IS NOT NULL THEN `t1`.`update_time` ELSE '' END THEN `t1`.`yuce_tenant_id` ELSE `ods_db_dd_sale_order_list_info_du`.`yuce_tenant_id` END AS `yuce_tenant_id`, CASE WHEN CASE WHEN `ods_db_dd_sale_order_list_info_du`.`update_time` IS NOT NULL THEN `ods_db_dd_sale_order_list_info_du`.`update_time` ELSE '' END < CASE WHEN `t1`.`update_time` IS NOT NULL THEN `t1`.`update_time` ELSE '' END THEN `t1`.`yuce_task_instance_id` ELSE `ods_db_dd_sale_order_list_info_du`.`yuce_task_instance_id` END AS `yuce_task_instance_id`, CASE WHEN CASE WHEN `ods_db_dd_sale_order_list_info_du`.`update_time` IS NOT NULL THEN `ods_db_dd_sale_order_list_info_du`.`update_time` ELSE '' END < CASE WHEN `t1`.`update_time` IS NOT NULL THEN `t1`.`update_time` ELSE '' END THEN `t1`.`yuce_data_create_time` ELSE `ods_db_dd_sale_order_list_info_du`.`yuce_data_create_time` END AS `yuce_data_create_time`, CASE WHEN CASE WHEN `ods_db_dd_sale_order_list_info_du`.`update_time` IS NOT NULL THEN `ods_db_dd_sale_order_list_info_du`.`update_time` ELSE '' END < CASE WHEN `t1`.`update_time` IS NOT NULL THEN `t1`.`update_time` ELSE '' END THEN `t1`.`dt` WHEN SUBSTRING(CAST(CASE WHEN CAST(`ods_db_dd_sale_order_list_info_du`.`pay_time` AS DECIMAL(38, 8)) > 99999999999 THEN CAST(FROM_UNIXTIME(CAST(`ods_db_dd_sale_order_list_info_du`.`pay_time` AS DECIMAL(38, 8)) / 1000) AS DATETIME) WHEN CAST(`ods_db_dd_sale_order_list_info_du`.`pay_time` AS DECIMAL(38, 8)) < 30000000 THEN str_to_date(CAST(`ods_db_dd_sale_order_list_info_du`.`pay_time` AS DECIMAL(38, 8)), '%Y%m%d') ELSE CAST(FROM_UNIXTIME(CAST(`ods_db_dd_sale_order_list_info_du`.`pay_time` AS DECIMAL(38, 8))) AS DATETIME) END AS VARCHAR), 1, 10) IS NOT NULL THEN SUBSTRING(CAST(CASE WHEN CAST(`ods_db_dd_sale_order_list_info_du`.`pay_time` AS DECIMAL(38, 8)) > 99999999999 THEN CAST(FROM_UNIXTIME(CAST(`ods_db_dd_sale_order_list_info_du`.`pay_time` AS DECIMAL(38, 8)) / 1000) AS DATETIME) WHEN CAST(`ods_db_dd_sale_order_list_info_du`.`pay_time` AS DECIMAL(38, 8)) < 30000000 THEN str_to_date(CAST(`ods_db_dd_sale_order_list_info_du`.`pay_time` AS DECIMAL(38, 8)), '%Y%m%d') ELSE CAST(FROM_UNIXTIME(CAST(`ods_db_dd_sale_order_list_info_du`.`pay_time` AS DECIMAL(38, 8))) AS DATETIME) END AS VARCHAR), 1, 10) ELSE '9999-12-31' END AS `dt` FROM ((SELECT `tax_amount` AS `tax_amount`, `post_amount` AS `post_amount`, `open_id` AS `open_id`, `order_tag` AS `order_tag`, `biz_desc` AS `biz_desc`, `mask_post_receiver` AS `mask_post_receiver`, `shop_order_tag_ui` AS `shop_order_tag_ui`, `shop_cost_amount` AS `shop_cost_amount`, `supermarket_order_serial_no` AS `supermarket_order_serial_no`, `mask_post_addr` AS `mask_post_addr`, `order_status` AS `order_status`, `biz` AS `biz`, `only_platform_cost_amount` AS `only_platform_cost_amount`, `recommend_end_ship_time` AS `recommend_end_ship_time`, `order_amount` AS `order_amount`, `author_cost_amount` AS `author_cost_amount`, `user_coordinate` AS `user_coordinate`, `order_type` AS `order_type`, `app_id` AS `app_id`, `modify_post_amount` AS `modify_post_amount`, `promise_detail` AS `promise_detail`, `d_car_shop_biz_data` AS `d_car_shop_biz_data`, `create_time` AS `create_time`, `open_address_id` AS `open_address_id`, `order_expire_time` AS `order_expire_time`, `shop_name` AS `shop_name`, `promotion_amount` AS `promotion_amount`, `promotion_shop_amount` AS `promotion_shop_amount`, `buyer_words` AS `buyer_words`, `post_promotion_amount` AS `post_promotion_amount`, `finish_time` AS `finish_time`, `pay_time` AS `pay_time`, `user_id_info` AS `user_id_info`, `shop_id` AS `shop_id`, `appointment_ship_time` AS `appointment_ship_time`, `exp_ship_time` AS `exp_ship_time`, `total_promotion_amount` AS `total_promotion_amount`, `post_insurance_amount` AS `post_insurance_amount`, `address_tag_ui` AS `address_tag_ui`, `channel_payment_no` AS `channel_payment_no`, `order_status_desc` AS `order_status_desc`, `order_id` AS `order_id`, `serial_number_list` AS `serial_number_list`, `latest_receipt_time` AS `latest_receipt_time`, `order_operate_record_list` AS `order_operate_record_list`, `sub_b_type` AS `sub_b_type`, `order_phase_list` AS `order_phase_list`, `ship_time` AS `ship_time`, `promise_info` AS `promise_info`, `user_nick_name` AS `user_nick_name`, `shop_period_purchase_info` AS `shop_period_purchase_info`, `recommend_start_ship_time` AS `recommend_start_ship_time`, `post_origin_amount` AS `post_origin_amount`, `promotion_redpack_talent_amount` AS `promotion_redpack_talent_amount`, `update_time` AS `update_time`, `seller_remark_stars` AS `seller_remark_stars`, `earliest_receipt_time` AS `earliest_receipt_time`, `promotion_platform_amount` AS `promotion_platform_amount`, `sku_order_list` AS `sku_order_list`, `doudian_open_id` AS `doudian_open_id`, `user_icon` AS `user_icon`, `pay_type` AS `pay_type`, `promotion_talent_amount` AS `promotion_talent_amount`, `b_type` AS `b_type`, `platform_cost_amount` AS `platform_cost_amount`, `promotion_redpack_platform_amount` AS `promotion_redpack_platform_amount`, `encrypt_post_tel` AS `encrypt_post_tel`, `consolidate_info` AS `consolidate_info`, `modify_amount` AS `modify_amount`, `b_type_desc` AS `b_type_desc`, `promotion_detail` AS `promotion_detail`, `early_arrival` AS `early_arrival`, `sub_b_type_desc` AS `sub_b_type_desc`, `order_level` AS `order_level`, `pay_amount` AS `pay_amount`, `tax_amount_not_come_out` AS `tax_amount_not_come_out`, `post_addr` AS `post_addr`, `logistics_info` AS `logistics_info`, `main_status_desc` AS `main_status_desc`, `target_arrival_time` AS `target_arrival_time`, `cancel_reason` AS `cancel_reason`, `aweme_id` AS `aweme_id`, `order_type_desc` AS `order_type_desc`, `encrypt_post_receiver` AS `encrypt_post_receiver`, `seller_words` AS `seller_words`, `trade_type_desc` AS `trade_type_desc`, `receipt_date` AS `receipt_date`, `trade_type` AS `trade_type`, `promotion_redpack_amount` AS `promotion_redpack_amount`, `promotion_pay_amount` AS `promotion_pay_amount`, `main_status` AS `main_status`, `mask_post_tel` AS `mask_post_tel`, `user_tag_ui` AS `user_tag_ui`, `origin_data` AS `origin_data`, `yuce_cube_shop_id` AS `yuce_cube_shop_id`, `yuce_tenant_id` AS `yuce_tenant_id`, `yuce_task_instance_id` AS `yuce_task_instance_id`, `yuce_data_create_time` AS `yuce_data_create_time`, `$f102`, `$f103`, `$f104` FROM (SELECT `tax_amount`, `post_amount`, `open_id`, `order_tag`, `biz_desc`, `mask_post_receiver`, `shop_order_tag_ui`, `shop_cost_amount`, `supermarket_order_serial_no`, `mask_post_addr`, `order_status`, `biz`, `only_platform_cost_amount`, `recommend_end_ship_time`, `order_amount`, `author_cost_amount`, `user_coordinate`, `order_type`, `app_id`, `modify_post_amount`, `promise_detail`, `d_car_shop_biz_data`, `create_time`, `open_address_id`, `order_expire_time`, `shop_name`, `promotion_amount`, `promotion_shop_amount`, `buyer_words`, `post_promotion_amount`, `finish_time`, `pay_time`, `user_id_info`, `shop_id`, `appointment_ship_time`, `exp_ship_time`, `total_promotion_amount`, `post_insurance_amount`, `address_tag_ui`, `channel_payment_no`, `order_status_desc`, `order_id`, `serial_number_list`, `latest_receipt_time`, `order_operate_record_list`, `sub_b_type`, `order_phase_list`, `ship_time`, `promise_info`, `user_nick_name`, `shop_period_purchase_info`, `recommend_start_ship_time`, `post_origin_amount`, `promotion_redpack_talent_amount`, `update_time`, `seller_remark_stars`, `earliest_receipt_time`, `promotion_platform_amount`, `sku_order_list`, `doudian_open_id`, `user_icon`, `pay_type`, `promotion_talent_amount`, `b_type`, `platform_cost_amount`, `promotion_redpack_platform_amount`, `encrypt_post_tel`, `consolidate_info`, `modify_amount`, `b_type_desc`, `promotion_detail`, `early_arrival`, `sub_b_type_desc`, `order_level`, `pay_amount`, `tax_amount_not_come_out`, `post_addr`, `logistics_info`, `main_status_desc`, `target_arrival_time`, `cancel_reason`, `aweme_id`, `order_type_desc`, `encrypt_post_receiver`, `seller_words`, `trade_type_desc`, `receipt_date`, `trade_type`, `promotion_redpack_amount`, `promotion_pay_amount`, `main_status`, `mask_post_tel`, `user_tag_ui`, `origin_data`, `yuce_cube_shop_id`, `yuce_tenant_id`, `yuce_task_instance_id`, `yuce_data_create_time`, CASE WHEN `order_id` IS NOT NULL THEN `order_id` ELSE 'yuce@#$123456qwer' END AS `$f102`, CASE WHEN `yuce_cube_shop_id` IS NOT NULL THEN `yuce_cube_shop_id` ELSE 'yuce@#$123456qwer' END AS `$f103`, CASE WHEN `yuce_tenant_id` IS NOT NULL THEN `yuce_tenant_id` ELSE 'yuce@#$123456qwer' END AS `$f104` FROM (SELECT `tax_amount`, `post_amount`, `open_id`, `order_tag`, `biz_desc`, `mask_post_receiver`, `shop_order_tag_ui`, `shop_cost_amount`, `supermarket_order_serial_no`, `mask_post_addr`, `order_status`, `biz`, `only_platform_cost_amount`, `recommend_end_ship_time`, `order_amount`, `author_cost_amount`, `user_coordinate`, `order_type`, `app_id`, `modify_post_amount`, `promise_detail`, `d_car_shop_biz_data`, `create_time`, `open_address_id`, `order_expire_time`, `shop_name`, `promotion_amount`, `promotion_shop_amount`, `buyer_words`, `post_promotion_amount`, `finish_time`, `pay_time`, `user_id_info`, `shop_id`, `appointment_ship_time`, `exp_ship_time`, `total_promotion_amount`, `post_insurance_amount`, `address_tag_ui`, `channel_payment_no`, `order_status_desc`, `order_id`, `serial_number_list`, `latest_receipt_time`, `order_operate_record_list`, `sub_b_type`, `order_phase_list`, `ship_time`, `promise_info`, `user_nick_name`, `shop_period_purchase_info`, `recommend_start_ship_time`, `post_origin_amount`, `promotion_redpack_talent_amount`, `update_time`, `seller_remark_stars`, `earliest_receipt_time`, `promotion_platform_amount`, `sku_order_list`, `doudian_open_id`, `user_icon`, `pay_type`, `promotion_talent_amount`, `b_type`, `platform_cost_amount`, `promotion_redpack_platform_amount`, `encrypt_post_tel`, `consolidate_info`, `modify_amount`, `b_type_desc`, `promotion_detail`, `early_arrival`, `sub_b_type_desc`, `order_level`, `pay_amount`, `tax_amount_not_come_out`, `post_addr`, `logistics_info`, `main_status_desc`, `target_arrival_time`, `cancel_reason`, `aweme_id`, `order_type_desc`, `encrypt_post_receiver`, `seller_words`, `trade_type_desc`, `receipt_date`, `trade_type`, `promotion_redpack_amount`, `promotion_pay_amount`, `main_status`, `mask_post_tel`, `user_tag_ui`, `origin_data`, `yuce_cube_shop_id`, `yuce_tenant_id`, `yuce_task_instance_id`, `yuce_data_create_time`, `$101`, ROW_NUMBER() OVER (PARTITION BY `order_id`, `yuce_cube_shop_id`, `yuce_tenant_id` ORDER BY `$101` IS NULL DESC, `$101` DESC) AS `w0$o0` FROM (SELECT `tax_amount` AS `tax_amount`, `post_amount` AS `post_amount`, `open_id` AS `open_id`, `order_tag` AS `order_tag`, `biz_desc` AS `biz_desc`, `mask_post_receiver` AS `mask_post_receiver`, `shop_order_tag_ui` AS `shop_order_tag_ui`, `shop_cost_amount` AS `shop_cost_amount`, `supermarket_order_serial_no` AS `supermarket_order_serial_no`, `mask_post_addr` AS `mask_post_addr`, `order_status` AS `order_status`, `biz` AS `biz`, `only_platform_cost_amount` AS `only_platform_cost_amount`, `recommend_end_ship_time` AS `recommend_end_ship_time`, `order_amount` AS `order_amount`, `author_cost_amount` AS `author_cost_amount`, `user_coordinate` AS `user_coordinate`, `order_type` AS `order_type`, `app_id` AS `app_id`, `modify_post_amount` AS `modify_post_amount`, `promise_detail` AS `promise_detail`, `d_car_shop_biz_data` AS `d_car_shop_biz_data`, `create_time` AS `create_time`, `open_address_id` AS `open_address_id`, `order_expire_time` AS `order_expire_time`, `shop_name` AS `shop_name`, `promotion_amount` AS `promotion_amount`, `promotion_shop_amount` AS `promotion_shop_amount`, `buyer_words` AS `buyer_words`, `post_promotion_amount` AS `post_promotion_amount`, `finish_time` AS `finish_time`, `pay_time` AS `pay_time`, `user_id_info` AS `user_id_info`, `shop_id` AS `shop_id`, `appointment_ship_time` AS `appointment_ship_time`, `exp_ship_time` AS `exp_ship_time`, `total_promotion_amount` AS `total_promotion_amount`, `post_insurance_amount` AS `post_insurance_amount`, `address_tag_ui` AS `address_tag_ui`, `channel_payment_no` AS `channel_payment_no`, `order_status_desc` AS `order_status_desc`, `order_id` AS `order_id`, `serial_number_list` AS `serial_number_list`, `latest_receipt_time` AS `latest_receipt_time`, `order_operate_record_list` AS `order_operate_record_list`, `sub_b_type` AS `sub_b_type`, `order_phase_list` AS `order_phase_list`, `ship_time` AS `ship_time`, `promise_info` AS `promise_info`, `user_nick_name` AS `user_nick_name`, `shop_period_purchase_info` AS `shop_period_purchase_info`, `recommend_start_ship_time` AS `recommend_start_ship_time`, `post_origin_amount` AS `post_origin_amount`, `promotion_redpack_talent_amount` AS `promotion_redpack_talent_amount`, `update_time` AS `update_time`, `seller_remark_stars` AS `seller_remark_stars`, `earliest_receipt_time` AS `earliest_receipt_time`, `promotion_platform_amount` AS `promotion_platform_amount`, `sku_order_list` AS `sku_order_list`, `doudian_open_id` AS `doudian_open_id`, `user_icon` AS `user_icon`, `pay_type` AS `pay_type`, `promotion_talent_amount` AS `promotion_talent_amount`, `b_type` AS `b_type`, `platform_cost_amount` AS `platform_cost_amount`, `promotion_redpack_platform_amount` AS `promotion_redpack_platform_amount`, `encrypt_post_tel` AS `encrypt_post_tel`, `consolidate_info` AS `consolidate_info`, `modify_amount` AS `modify_amount`, `b_type_desc` AS `b_type_desc`, `promotion_detail` AS `promotion_detail`, `early_arrival` AS `early_arrival`, `sub_b_type_desc` AS `sub_b_type_desc`, `order_level` AS `order_level`, `pay_amount` AS `pay_amount`, `tax_amount_not_come_out` AS `tax_amount_not_come_out`, `post_addr` AS `post_addr`, `logistics_info` AS `logistics_info`, `main_status_desc` AS `main_status_desc`, `target_arrival_time` AS `target_arrival_time`, `cancel_reason` AS `cancel_reason`, `aweme_id` AS `aweme_id`, `order_type_desc` AS `order_type_desc`, `encrypt_post_receiver` AS `encrypt_post_receiver`, `seller_words` AS `seller_words`, `trade_type_desc` AS `trade_type_desc`, `receipt_date` AS `receipt_date`, `trade_type` AS `trade_type`, `promotion_redpack_amount` AS `promotion_redpack_amount`, `promotion_pay_amount` AS `promotion_pay_amount`, `main_status` AS `main_status`, `mask_post_tel` AS `mask_post_tel`, `user_tag_ui` AS `user_tag_ui`, `origin_data` AS `origin_data`, `yuce_cube_shop_id` AS `yuce_cube_shop_id`, `yuce_tenant_id` AS `yuce_tenant_id`, `yuce_task_instance_id` AS `yuce_task_instance_id`, `yuce_data_create_time` AS `yuce_data_create_time`, `$101` FROM (SELECT `ods_db_dd_sale_order_list_info_du`.`tax_amount`, `ods_db_dd_sale_order_list_info_du`.`post_amount`, `ods_db_dd_sale_order_list_info_du`.`open_id`, `ods_db_dd_sale_order_list_info_du`.`order_tag`, `ods_db_dd_sale_order_list_info_du`.`biz_desc`, `ods_db_dd_sale_order_list_info_du`.`mask_post_receiver`, `ods_db_dd_sale_order_list_info_du`.`shop_order_tag_ui`, `ods_db_dd_sale_order_list_info_du`.`shop_cost_amount`, `ods_db_dd_sale_order_list_info_du`.`supermarket_order_serial_no`, `ods_db_dd_sale_order_list_info_du`.`mask_post_addr`, `ods_db_dd_sale_order_list_info_du`.`order_status`, `ods_db_dd_sale_order_list_info_du`.`biz`, `ods_db_dd_sale_order_list_info_du`.`only_platform_cost_amount`, `ods_db_dd_sale_order_list_info_du`.`recommend_end_ship_time`, `ods_db_dd_sale_order_list_info_du`.`order_amount`, `ods_db_dd_sale_order_list_info_du`.`author_cost_amount`, `ods_db_dd_sale_order_list_info_du`.`user_coordinate`, `ods_db_dd_sale_order_list_info_du`.`order_type`, `ods_db_dd_sale_order_list_info_du`.`app_id`, `ods_db_dd_sale_order_list_info_du`.`modify_post_amount`, `ods_db_dd_sale_order_list_info_du`.`promise_detail`, `ods_db_dd_sale_order_list_info_du`.`d_car_shop_biz_data`, `ods_db_dd_sale_order_list_info_du`.`create_time`, `ods_db_dd_sale_order_list_info_du`.`open_address_id`, `ods_db_dd_sale_order_list_info_du`.`order_expire_time`, `ods_db_dd_sale_order_list_info_du`.`shop_name`, `ods_db_dd_sale_order_list_info_du`.`promotion_amount`, `ods_db_dd_sale_order_list_info_du`.`promotion_shop_amount`, `ods_db_dd_sale_order_list_info_du`.`buyer_words`, `ods_db_dd_sale_order_list_info_du`.`post_promotion_amount`, `ods_db_dd_sale_order_list_info_du`.`finish_time`, `ods_db_dd_sale_order_list_info_du`.`pay_time`, `ods_db_dd_sale_order_list_info_du`.`user_id_info`, `ods_db_dd_sale_order_list_info_du`.`shop_id`, `ods_db_dd_sale_order_list_info_du`.`appointment_ship_time`, `ods_db_dd_sale_order_list_info_du`.`exp_ship_time`, `ods_db_dd_sale_order_list_info_du`.`total_promotion_amount`, `ods_db_dd_sale_order_list_info_du`.`post_insurance_amount`, `ods_db_dd_sale_order_list_info_du`.`address_tag_ui`, `ods_db_dd_sale_order_list_info_du`.`channel_payment_no`, `ods_db_dd_sale_order_list_info_du`.`order_status_desc`, `ods_db_dd_sale_order_list_info_du`.`order_id`, `ods_db_dd_sale_order_list_info_du`.`serial_number_list`, `ods_db_dd_sale_order_list_info_du`.`latest_receipt_time`, `ods_db_dd_sale_order_list_info_du`.`order_operate_record_list`, `ods_db_dd_sale_order_list_info_du`.`sub_b_type`, `ods_db_dd_sale_order_list_info_du`.`order_phase_list`, `ods_db_dd_sale_order_list_info_du`.`ship_time`, `ods_db_dd_sale_order_list_info_du`.`promise_info`, `ods_db_dd_sale_order_list_info_du`.`user_nick_name`, `ods_db_dd_sale_order_list_info_du`.`shop_period_purchase_info`, `ods_db_dd_sale_order_list_info_du`.`recommend_start_ship_time`, `ods_db_dd_sale_order_list_info_du`.`post_origin_amount`, `ods_db_dd_sale_order_list_info_du`.`promotion_redpack_talent_amount`, `ods_db_dd_sale_order_list_info_du`.`update_time`, `ods_db_dd_sale_order_list_info_du`.`seller_remark_stars`, `ods_db_dd_sale_order_list_info_du`.`earliest_receipt_time`, `ods_db_dd_sale_order_list_info_du`.`promotion_platform_amount`, `ods_db_dd_sale_order_list_info_du`.`sku_order_list`, `ods_db_dd_sale_order_list_info_du`.`doudian_open_id`, `ods_db_dd_sale_order_list_info_du`.`user_icon`, `ods_db_dd_sale_order_list_info_du`.`pay_type`, `ods_db_dd_sale_order_list_info_du`.`promotion_talent_amount`, `ods_db_dd_sale_order_list_info_du`.`b_type`, `ods_db_dd_sale_order_list_info_du`.`platform_cost_amount`, `ods_db_dd_sale_order_list_info_du`.`promotion_redpack_platform_amount`, `ods_db_dd_sale_order_list_info_du`.`encrypt_post_tel`, `ods_db_dd_sale_order_list_info_du`.`consolidate_info`, `ods_db_dd_sale_order_list_info_du`.`modify_amount`, `ods_db_dd_sale_order_list_info_du`.`b_type_desc`, `ods_db_dd_sale_order_list_info_du`.`promotion_detail`, `ods_db_dd_sale_order_list_info_du`.`early_arrival`, `ods_db_dd_sale_order_list_info_du`.`sub_b_type_desc`, `ods_db_dd_sale_order_list_info_du`.`order_level`, `ods_db_dd_sale_order_list_info_du`.`pay_amount`, `ods_db_dd_sale_order_list_info_du`.`tax_amount_not_come_out`, `ods_db_dd_sale_order_list_info_du`.`post_addr`, `ods_db_dd_sale_order_list_info_du`.`logistics_info`, `ods_db_dd_sale_order_list_info_du`.`main_status_desc`, `ods_db_dd_sale_order_list_info_du`.`target_arrival_time`, `ods_db_dd_sale_order_list_info_du`.`cancel_reason`, `ods_db_dd_sale_order_list_info_du`.`aweme_id`, `ods_db_dd_sale_order_list_info_du`.`order_type_desc`, `ods_db_dd_sale_order_list_info_du`.`encrypt_post_receiver`, `ods_db_dd_sale_order_list_info_du`.`seller_words`, `ods_db_dd_sale_order_list_info_du`.`trade_type_desc`, `ods_db_dd_sale_order_list_info_du`.`receipt_date`, `ods_db_dd_sale_order_list_info_du`.`trade_type`, `ods_db_dd_sale_order_list_info_du`.`promotion_redpack_amount`, `ods_db_dd_sale_order_list_info_du`.`promotion_pay_amount`, `ods_db_dd_sale_order_list_info_du`.`main_status`, `ods_db_dd_sale_order_list_info_du`.`mask_post_tel`, `ods_db_dd_sale_order_list_info_du`.`user_tag_ui`, `ods_db_dd_sale_order_list_info_du`.`origin_data`, `ods_db_dd_sale_order_list_info_du`.`yuce_cube_shop_id`, `ods_db_dd_sale_order_list_info_du`.`yuce_tenant_id`, `ods_db_dd_sale_order_list_info_du`.`yuce_task_instance_id`, `ods_db_dd_sale_order_list_info_du`.`yuce_data_create_time`, CASE WHEN CAST(`ods_db_dd_sale_order_list_info_du`.`update_time` AS DECIMAL(38, 8)) > 99999999999 THEN CAST(FROM_UNIXTIME(CAST(`ods_db_dd_sale_order_list_info_du`.`update_time` AS DECIMAL(38, 8)) / 1000) AS DATETIME) WHEN CAST(`ods_db_dd_sale_order_list_info_du`.`update_time` AS DECIMAL(38, 8)) < 30000000 THEN str_to_date(CAST(`ods_db_dd_sale_order_list_info_du`.`update_time` AS DECIMAL(38, 8)), '%Y%m%d') ELSE CAST(FROM_UNIXTIME(CAST(`ods_db_dd_sale_order_list_info_du`.`update_time` AS DECIMAL(38, 8))) AS DATETIME) END AS `$101` FROM `lake`.`saas_datalake`.`ods_db_dd_sale_order_list_info_du` WHERE SUBSTRING(`ods_db_dd_sale_order_list_info_du`.`dt`, 1, 10) >= '2025-09-25' AND SUBSTRING(`ods_db_dd_sale_order_list_info_du`.`dt`, 1, 10) <= '2025-09-26' AND `ods_db_dd_sale_order_list_info_du`.`yuce_tenant_id` = 'hzktppglyxgs_283476') AS `ods_db_dd_sale_order_list_info_du`) AS `ods_db_dd_sale_order_list_info_du`) AS `ods_db_dd_sale_order_list_info_du` WHERE `w0$o0` = 1) AS `ods_db_dd_sale_order_list_info_du`) AS `ods_db_dd_sale_order_list_info_du` FULL JOIN (SELECT `tax_amount` AS `tax_amount`, `post_amount` AS `post_amount`, `open_id` AS `open_id`, `order_tag` AS `order_tag`, `biz_desc` AS `biz_desc`, `mask_post_receiver` AS `mask_post_receiver`, `shop_order_tag_ui` AS `shop_order_tag_ui`, `shop_cost_amount` AS `shop_cost_amount`, `supermarket_order_serial_no` AS `supermarket_order_serial_no`, `mask_post_addr` AS `mask_post_addr`, `order_status` AS `order_status`, `biz` AS `biz`, `recommend_end_ship_time` AS `recommend_end_ship_time`, `only_platform_cost_amount` AS `only_platform_cost_amount`, `order_amount` AS `order_amount`, `author_cost_amount` AS `author_cost_amount`, `user_coordinate` AS `user_coordinate`, `order_type` AS `order_type`, `app_id` AS `app_id`, `modify_post_amount` AS `modify_post_amount`, `promise_detail` AS `promise_detail`, `d_car_shop_biz_data` AS `d_car_shop_biz_data`, `open_address_id` AS `open_address_id`, `create_time` AS `create_time`, `order_expire_time` AS `order_expire_time`, `shop_name` AS `shop_name`, `buyer_words` AS `buyer_words`, `promotion_amount` AS `promotion_amount`, `post_promotion_amount` AS `post_promotion_amount`, `promotion_shop_amount` AS `promotion_shop_amount`, `finish_time` AS `finish_time`, `pay_time` AS `pay_time`, `user_id_info` AS `user_id_info`, `shop_id` AS `shop_id`, `appointment_ship_time` AS `appointment_ship_time`, `total_promotion_amount` AS `total_promotion_amount`, `post_insurance_amount` AS `post_insurance_amount`, `exp_ship_time` AS `exp_ship_time`, `address_tag_ui` AS `address_tag_ui`, `channel_payment_no` AS `channel_payment_no`, `order_status_desc` AS `order_status_desc`, `latest_receipt_time` AS `latest_receipt_time`, `order_id` AS `order_id`, `serial_number_list` AS `serial_number_list`, `order_operate_record_list` AS `order_operate_record_list`, `order_phase_list` AS `order_phase_list`, `sub_b_type` AS `sub_b_type`, `ship_time` AS `ship_time`, `promise_info` AS `promise_info`, `user_nick_name` AS `user_nick_name`, `shop_period_purchase_info` AS `shop_period_purchase_info`, `post_origin_amount` AS `post_origin_amount`, `recommend_start_ship_time` AS `recommend_start_ship_time`, `promotion_redpack_talent_amount` AS `promotion_redpack_talent_amount`, `update_time` AS `update_time`, `seller_remark_stars` AS `seller_remark_stars`, `earliest_receipt_time` AS `earliest_receipt_time`, `promotion_platform_amount` AS `promotion_platform_amount`, `sku_order_list` AS `sku_order_list`, `doudian_open_id` AS `doudian_open_id`, `user_icon` AS `user_icon`, `pay_type` AS `pay_type`, `promotion_talent_amount` AS `promotion_talent_amount`, `b_type` AS `b_type`, `platform_cost_amount` AS `platform_cost_amount`, `promotion_redpack_platform_amount` AS `promotion_redpack_platform_amount`, `encrypt_post_tel` AS `encrypt_post_tel`, `modify_amount` AS `modify_amount`, `consolidate_info` AS `consolidate_info`, `b_type_desc` AS `b_type_desc`, `promotion_detail` AS `promotion_detail`, `early_arrival` AS `early_arrival`, `sub_b_type_desc` AS `sub_b_type_desc`, `pay_amount` AS `pay_amount`, `order_level` AS `order_level`, `tax_amount_not_come_out` AS `tax_amount_not_come_out`, `post_addr` AS `post_addr`, `logistics_info` AS `logistics_info`, `main_status_desc` AS `main_status_desc`, `target_arrival_time` AS `target_arrival_time`, `cancel_reason` AS `cancel_reason`, `aweme_id` AS `aweme_id`, `order_type_desc` AS `order_type_desc`, `encrypt_post_receiver` AS `encrypt_post_receiver`, `seller_words` AS `seller_words`, `receipt_date` AS `receipt_date`, `trade_type_desc` AS `trade_type_desc`, `trade_type` AS `trade_type`, `promotion_redpack_amount` AS `promotion_redpack_amount`, `promotion_pay_amount` AS `promotion_pay_amount`, `main_status` AS `main_status`, `mask_post_tel` AS `mask_post_tel`, `user_tag_ui` AS `user_tag_ui`, `dt` AS `dt`, `origin_data` AS `origin_data`, `yuce_cube_shop_id` AS `yuce_cube_shop_id`, `yuce_task_instance_id` AS `yuce_task_instance_id`, `yuce_data_create_time` AS `yuce_data_create_time`, `yuce_tenant_id` AS `yuce_tenant_id`, `$f101`, `$f102`, `$f103` FROM (SELECT `ods_db_dd_sale_order_list_info_f`.`tax_amount`, `ods_db_dd_sale_order_list_info_f`.`post_amount`, `ods_db_dd_sale_order_list_info_f`.`open_id`, `ods_db_dd_sale_order_list_info_f`.`order_tag`, `ods_db_dd_sale_order_list_info_f`.`biz_desc`, `ods_db_dd_sale_order_list_info_f`.`mask_post_receiver`, `ods_db_dd_sale_order_list_info_f`.`shop_order_tag_ui`, `ods_db_dd_sale_order_list_info_f`.`shop_cost_amount`, `ods_db_dd_sale_order_list_info_f`.`supermarket_order_serial_no`, `ods_db_dd_sale_order_list_info_f`.`mask_post_addr`, `ods_db_dd_sale_order_list_info_f`.`order_status`, `ods_db_dd_sale_order_list_info_f`.`biz`, `ods_db_dd_sale_order_list_info_f`.`recommend_end_ship_time`, `ods_db_dd_sale_order_list_info_f`.`only_platform_cost_amount`, `ods_db_dd_sale_order_list_info_f`.`order_amount`, `ods_db_dd_sale_order_list_info_f`.`author_cost_amount`, `ods_db_dd_sale_order_list_info_f`.`user_coordinate`, `ods_db_dd_sale_order_list_info_f`.`order_type`, `ods_db_dd_sale_order_list_info_f`.`app_id`, `ods_db_dd_sale_order_list_info_f`.`modify_post_amount`, `ods_db_dd_sale_order_list_info_f`.`promise_detail`, `ods_db_dd_sale_order_list_info_f`.`d_car_shop_biz_data`, `ods_db_dd_sale_order_list_info_f`.`open_address_id`, `ods_db_dd_sale_order_list_info_f`.`create_time`, `ods_db_dd_sale_order_list_info_f`.`order_expire_time`, `ods_db_dd_sale_order_list_info_f`.`shop_name`, `ods_db_dd_sale_order_list_info_f`.`buyer_words`, `ods_db_dd_sale_order_list_info_f`.`promotion_amount`, `ods_db_dd_sale_order_list_info_f`.`post_promotion_amount`, `ods_db_dd_sale_order_list_info_f`.`promotion_shop_amount`, `ods_db_dd_sale_order_list_info_f`.`finish_time`, `ods_db_dd_sale_order_list_info_f`.`pay_time`, `ods_db_dd_sale_order_list_info_f`.`user_id_info`, `ods_db_dd_sale_order_list_info_f`.`shop_id`, `ods_db_dd_sale_order_list_info_f`.`appointment_ship_time`, `ods_db_dd_sale_order_list_info_f`.`total_promotion_amount`, `ods_db_dd_sale_order_list_info_f`.`post_insurance_amount`, `ods_db_dd_sale_order_list_info_f`.`exp_ship_time`, `ods_db_dd_sale_order_list_info_f`.`address_tag_ui`, `ods_db_dd_sale_order_list_info_f`.`channel_payment_no`, `ods_db_dd_sale_order_list_info_f`.`order_status_desc`, `ods_db_dd_sale_order_list_info_f`.`latest_receipt_time`, `ods_db_dd_sale_order_list_info_f`.`order_id`, `ods_db_dd_sale_order_list_info_f`.`serial_number_list`, `ods_db_dd_sale_order_list_info_f`.`order_operate_record_list`, `ods_db_dd_sale_order_list_info_f`.`order_phase_list`, `ods_db_dd_sale_order_list_info_f`.`sub_b_type`, `ods_db_dd_sale_order_list_info_f`.`ship_time`, `ods_db_dd_sale_order_list_info_f`.`promise_info`, `ods_db_dd_sale_order_list_info_f`.`user_nick_name`, `ods_db_dd_sale_order_list_info_f`.`shop_period_purchase_info`, `ods_db_dd_sale_order_list_info_f`.`post_origin_amount`, `ods_db_dd_sale_order_list_info_f`.`recommend_start_ship_time`, `ods_db_dd_sale_order_list_info_f`.`promotion_redpack_talent_amount`, `ods_db_dd_sale_order_list_info_f`.`update_time`, `ods_db_dd_sale_order_list_info_f`.`seller_remark_stars`, `ods_db_dd_sale_order_list_info_f`.`earliest_receipt_time`, `ods_db_dd_sale_order_list_info_f`.`promotion_platform_amount`, `ods_db_dd_sale_order_list_info_f`.`sku_order_list`, `ods_db_dd_sale_order_list_info_f`.`doudian_open_id`, `ods_db_dd_sale_order_list_info_f`.`user_icon`, `ods_db_dd_sale_order_list_info_f`.`pay_type`, `ods_db_dd_sale_order_list_info_f`.`promotion_talent_amount`, `ods_db_dd_sale_order_list_info_f`.`b_type`, `ods_db_dd_sale_order_list_info_f`.`platform_cost_amount`, `ods_db_dd_sale_order_list_info_f`.`promotion_redpack_platform_amount`, `ods_db_dd_sale_order_list_info_f`.`encrypt_post_tel`, `ods_db_dd_sale_order_list_info_f`.`modify_amount`, `ods_db_dd_sale_order_list_info_f`.`consolidate_info`, `ods_db_dd_sale_order_list_info_f`.`b_type_desc`, `ods_db_dd_sale_order_list_info_f`.`promotion_detail`, `ods_db_dd_sale_order_list_info_f`.`early_arrival`, `ods_db_dd_sale_order_list_info_f`.`sub_b_type_desc`, `ods_db_dd_sale_order_list_info_f`.`pay_amount`, `ods_db_dd_sale_order_list_info_f`.`order_level`, `ods_db_dd_sale_order_list_info_f`.`tax_amount_not_come_out`, `ods_db_dd_sale_order_list_info_f`.`post_addr`, `ods_db_dd_sale_order_list_info_f`.`logistics_info`, `ods_db_dd_sale_order_list_info_f`.`main_status_desc`, `ods_db_dd_sale_order_list_info_f`.`target_arrival_time`, `ods_db_dd_sale_order_list_info_f`.`cancel_reason`, `ods_db_dd_sale_order_list_info_f`.`aweme_id`, `ods_db_dd_sale_order_list_info_f`.`order_type_desc`, `ods_db_dd_sale_order_list_info_f`.`encrypt_post_receiver`, `ods_db_dd_sale_order_list_info_f`.`seller_words`, `ods_db_dd_sale_order_list_info_f`.`receipt_date`, `ods_db_dd_sale_order_list_info_f`.`trade_type_desc`, `ods_db_dd_sale_order_list_info_f`.`trade_type`, `ods_db_dd_sale_order_list_info_f`.`promotion_redpack_amount`, `ods_db_dd_sale_order_list_info_f`.`promotion_pay_amount`, `ods_db_dd_sale_order_list_info_f`.`main_status`, `ods_db_dd_sale_order_list_info_f`.`mask_post_tel`, `ods_db_dd_sale_order_list_info_f`.`user_tag_ui`, `ods_db_dd_sale_order_list_info_f`.`dt`, `ods_db_dd_sale_order_list_info_f`.`origin_data`, `ods_db_dd_sale_order_list_info_f`.`yuce_cube_shop_id`, `ods_db_dd_sale_order_list_info_f`.`yuce_task_instance_id`, `ods_db_dd_sale_order_list_info_f`.`yuce_data_create_time`, `ods_db_dd_sale_order_list_info_f`.`yuce_tenant_id`, CASE WHEN `ods_db_dd_sale_order_list_info_f`.`order_id` IS NOT NULL THEN `ods_db_dd_sale_order_list_info_f`.`order_id` ELSE 'yuce@#$123456qwer' END AS `$f101`, CASE WHEN `ods_db_dd_sale_order_list_info_f`.`yuce_cube_shop_id` IS NOT NULL THEN `ods_db_dd_sale_order_list_info_f`.`yuce_cube_shop_id` ELSE 'yuce@#$123456qwer' END AS `$f102`, CASE WHEN `ods_db_dd_sale_order_list_info_f`.`yuce_tenant_id` IS NOT NULL THEN `ods_db_dd_sale_order_list_info_f`.`yuce_tenant_id` ELSE 'yuce@#$123456qwer' END AS `$f103` FROM ((SELECT `ods_db_dd_sale_order_list_info_f`.`tax_amount`, `ods_db_dd_sale_order_list_info_f`.`post_amount`, `ods_db_dd_sale_order_list_info_f`.`open_id`, `ods_db_dd_sale_order_list_info_f`.`order_tag`, `ods_db_dd_sale_order_list_info_f`.`biz_desc`, `ods_db_dd_sale_order_list_info_f`.`mask_post_receiver`, `ods_db_dd_sale_order_list_info_f`.`shop_order_tag_ui`, `ods_db_dd_sale_order_list_info_f`.`shop_cost_amount`, `ods_db_dd_sale_order_list_info_f`.`supermarket_order_serial_no`, `ods_db_dd_sale_order_list_info_f`.`mask_post_addr`, `ods_db_dd_sale_order_list_info_f`.`order_status`, `ods_db_dd_sale_order_list_info_f`.`biz`, `ods_db_dd_sale_order_list_info_f`.`recommend_end_ship_time`, `ods_db_dd_sale_order_list_info_f`.`only_platform_cost_amount`, `ods_db_dd_sale_order_list_info_f`.`order_amount`, `ods_db_dd_sale_order_list_info_f`.`author_cost_amount`, `ods_db_dd_sale_order_list_info_f`.`user_coordinate`, `ods_db_dd_sale_order_list_info_f`.`order_type`, `ods_db_dd_sale_order_list_info_f`.`app_id`, `ods_db_dd_sale_order_list_info_f`.`modify_post_amount`, `ods_db_dd_sale_order_list_info_f`.`promise_detail`, `ods_db_dd_sale_order_list_info_f`.`d_car_shop_biz_data`, `ods_db_dd_sale_order_list_info_f`.`open_address_id`, `ods_db_dd_sale_order_list_info_f`.`create_time`, `ods_db_dd_sale_order_list_info_f`.`order_expire_time`, `ods_db_dd_sale_order_list_info_f`.`shop_name`, `ods_db_dd_sale_order_list_info_f`.`buyer_words`, `ods_db_dd_sale_order_list_info_f`.`promotion_amount`, `ods_db_dd_sale_order_list_info_f`.`post_promotion_amount`, `ods_db_dd_sale_order_list_info_f`.`promotion_shop_amount`, `ods_db_dd_sale_order_list_info_f`.`finish_time`, `ods_db_dd_sale_order_list_info_f`.`pay_time`, `ods_db_dd_sale_order_list_info_f`.`user_id_info`, `ods_db_dd_sale_order_list_info_f`.`shop_id`, `ods_db_dd_sale_order_list_info_f`.`appointment_ship_time`, `ods_db_dd_sale_order_list_info_f`.`total_promotion_amount`, `ods_db_dd_sale_order_list_info_f`.`post_insurance_amount`, `ods_db_dd_sale_order_list_info_f`.`exp_ship_time`, `ods_db_dd_sale_order_list_info_f`.`address_tag_ui`, `ods_db_dd_sale_order_list_info_f`.`channel_payment_no`, `ods_db_dd_sale_order_list_info_f`.`order_status_desc`, `ods_db_dd_sale_order_list_info_f`.`latest_receipt_time`, `ods_db_dd_sale_order_list_info_f`.`order_id`, `ods_db_dd_sale_order_list_info_f`.`serial_number_list`, `ods_db_dd_sale_order_list_info_f`.`order_operate_record_list`, `ods_db_dd_sale_order_list_info_f`.`order_phase_list`, `ods_db_dd_sale_order_list_info_f`.`sub_b_type`, `ods_db_dd_sale_order_list_info_f`.`ship_time`, `ods_db_dd_sale_order_list_info_f`.`promise_info`, `ods_db_dd_sale_order_list_info_f`.`user_nick_name`, `ods_db_dd_sale_order_list_info_f`.`shop_period_purchase_info`, `ods_db_dd_sale_order_list_info_f`.`post_origin_amount`, `ods_db_dd_sale_order_list_info_f`.`recommend_start_ship_time`, `ods_db_dd_sale_order_list_info_f`.`promotion_redpack_talent_amount`, `ods_db_dd_sale_order_list_info_f`.`update_time`, `ods_db_dd_sale_order_list_info_f`.`seller_remark_stars`, `ods_db_dd_sale_order_list_info_f`.`earliest_receipt_time`, `ods_db_dd_sale_order_list_info_f`.`promotion_platform_amount`, `ods_db_dd_sale_order_list_info_f`.`sku_order_list`, `ods_db_dd_sale_order_list_info_f`.`doudian_open_id`, `ods_db_dd_sale_order_list_info_f`.`user_icon`, `ods_db_dd_sale_order_list_info_f`.`pay_type`, `ods_db_dd_sale_order_list_info_f`.`promotion_talent_amount`, `ods_db_dd_sale_order_list_info_f`.`b_type`, `ods_db_dd_sale_order_list_info_f`.`platform_cost_amount`, `ods_db_dd_sale_order_list_info_f`.`promotion_redpack_platform_amount`, `ods_db_dd_sale_order_list_info_f`.`encrypt_post_tel`, `ods_db_dd_sale_order_list_info_f`.`modify_amount`, `ods_db_dd_sale_order_list_info_f`.`consolidate_info`, `ods_db_dd_sale_order_list_info_f`.`b_type_desc`, `ods_db_dd_sale_order_list_info_f`.`promotion_detail`, `ods_db_dd_sale_order_list_info_f`.`early_arrival`, `ods_db_dd_sale_order_list_info_f`.`sub_b_type_desc`, `ods_db_dd_sale_order_list_info_f`.`pay_amount`, `ods_db_dd_sale_order_list_info_f`.`order_level`, `ods_db_dd_sale_order_list_info_f`.`tax_amount_not_come_out`, `ods_db_dd_sale_order_list_info_f`.`post_addr`, `ods_db_dd_sale_order_list_info_f`.`logistics_info`, `ods_db_dd_sale_order_list_info_f`.`main_status_desc`, `ods_db_dd_sale_order_list_info_f`.`target_arrival_time`, `ods_db_dd_sale_order_list_info_f`.`cancel_reason`, `ods_db_dd_sale_order_list_info_f`.`aweme_id`, `ods_db_dd_sale_order_list_info_f`.`order_type_desc`, `ods_db_dd_sale_order_list_info_f`.`encrypt_post_receiver`, `ods_db_dd_sale_order_list_info_f`.`seller_words`, `ods_db_dd_sale_order_list_info_f`.`receipt_date`, `ods_db_dd_sale_order_list_info_f`.`trade_type_desc`, `ods_db_dd_sale_order_list_info_f`.`trade_type`, `ods_db_dd_sale_order_list_info_f`.`promotion_redpack_amount`, `ods_db_dd_sale_order_list_info_f`.`promotion_pay_amount`, `ods_db_dd_sale_order_list_info_f`.`main_status`, `ods_db_dd_sale_order_list_info_f`.`mask_post_tel`, `ods_db_dd_sale_order_list_info_f`.`user_tag_ui`, `ods_db_dd_sale_order_list_info_f`.`dt`, `ods_db_dd_sale_order_list_info_f`.`origin_data`, `ods_db_dd_sale_order_list_info_f`.`yuce_cube_shop_id`, `ods_db_dd_sale_order_list_info_f`.`yuce_task_instance_id`, `ods_db_dd_sale_order_list_info_f`.`yuce_data_create_time`, `ods_db_dd_sale_order_list_info_f`.`yuce_tenant_id` FROM `lake`.`saas_datalake`.`ods_db_dd_sale_order_list_info_f` WHERE `ods_db_dd_sale_order_list_info_f`.`yuce_tenant_id` = 'hzktppglyxgs_283476') AS `ods_db_dd_sale_order_list_info_f` INNER JOIN (SELECT `ods_db_dd_sale_order_list_info_du`.`yuce_tenant_id` FROM `lake`.`saas_datalake`.`ods_db_dd_sale_order_list_info_du` WHERE SUBSTRING(`ods_db_dd_sale_order_list_info_du`.`dt`, 1, 10) >= '2025-09-25' AND SUBSTRING(`ods_db_dd_sale_order_list_info_du`.`dt`, 1, 10) <= '2025-09-26' AND `ods_db_dd_sale_order_list_info_du`.`yuce_tenant_id` = 'hzktppglyxgs_283476' GROUP BY `ods_db_dd_sale_order_list_info_du`.`yuce_tenant_id`) AS `ods_db_dd_sale_order_list_info_du0` ON `ods_db_dd_sale_order_list_info_f`.`yuce_tenant_id` = `ods_db_dd_sale_order_list_info_du0`.`yuce_tenant_id`)) AS `t0`) AS `t1` ON ((`ods_db_dd_sale_order_list_info_du`.`$f102` = `t1`.`$f101` AND `ods_db_dd_sale_order_list_info_du`.`$f103` = `t1`.`$f102`) AND `ods_db_dd_sale_order_list_info_du`.`$f104` = `t1`.`$f103`))) AS `t3`)|Digest=|Warehouse=default_warehouse|IsForwardToLeader=true|QueryFEAllocatedMemory=69697736
2025-09-25 03:16:01.473+08:00 [query] |Timestamp=1758741315418|Client=172.17.9.113:22524|User=fabric|AuthorizedUser='fabric'@'%'|ResourceGroup=load_resource_group|Catalog=lake|Db=saas_datalake|State=ERR|ErrorCode=|Time=46055|ScanBytes=0|ScanRows=0|ReturnRows=0|StmtId=366288|QueryId=cd13ec54-997a-11f0-a27e-0242f591ea1f|IsQuery=false|feIp=saas-node14|Stmt=/*"sqlid" = '1758741314631-qydj',"tasktype" = 'etlDevelopTask',"set_var.phased_scheduler_max_concurrency" = '1',"objtype" = 'TASK',"set_var.enable_phased_scheduler" = 'true',"exectype" = 'UPDATE',"fabric-jobId" = '172bbcbd-603d-c3fc-2352-82b8f93c0500',"set_var.pipeline_dop" = '1',"set_var.connector_scan_use_query_mem_ratio" = '0.1',"instanceid" = '4OeMKX1agQ-OTM2NW',"objid" = '4OeMKX1agQ',"logid" = 'pe6RBXkRup'*/ INSERT /*+ SET_VAR("enable_phased_scheduler"= 'true', "phased_scheduler_max_concurrency"= '1', "pipeline_dop"= '1', "connector_scan_use_query_mem_ratio"= '0.1') */ OVERWRITE `lake`.`saas_datalake`.`ods_db_dd_sale_order_list_info_f` (`tax_amount`, `post_amount`, `open_id`, `order_tag`, `biz_desc`, `mask_post_receiver`, `shop_order_tag_ui`, `shop_cost_amount`, `supermarket_order_serial_no`, `mask_post_addr`, `order_status`, `biz`, `recommend_end_ship_time`, `only_platform_cost_amount`, `order_amount`, `author_cost_amount`, `user_coordinate`, `order_type`, `app_id`, `modify_post_amount`, `promise_detail`, `d_car_shop_biz_data`, `open_address_id`, `create_time`, `order_expire_time`, `shop_name`, `buyer_words`, `promotion_amount`, `post_promotion_amount`, `promotion_shop_amount`, `finish_time`, `pay_time`, `user_id_info`, `shop_id`, `appointment_ship_time`, `total_promotion_amount`, `post_insurance_amount`, `exp_ship_time`, `address_tag_ui`, `channel_payment_no`, `order_status_desc`, `latest_receipt_time`, `order_id`, `serial_number_list`, `order_operate_record_list`, `order_phase_list`, `sub_b_type`, `ship_time`, `promise_info`, `user_nick_name`, `shop_period_purchase_info`, `post_origin_amount`, `recommend_start_ship_time`, `promotion_redpack_talent_amount`, `update_time`, `seller_remark_stars`, `earliest_receipt_time`, `promotion_platform_amount`, `sku_order_list`, `doudian_open_id`, `user_icon`, `pay_type`, `promotion_talent_amount`, `b_type`, `platform_cost_amount`, `promotion_redpack_platform_amount`, `encrypt_post_tel`, `modify_amount`, `consolidate_info`, `b_type_desc`, `promotion_detail`, `early_arrival`, `sub_b_type_desc`, `pay_amount`, `order_level`, `tax_amount_not_come_out`, `post_addr`, `logistics_info`, `main_status_desc`, `target_arrival_time`, `cancel_reason`, `aweme_id`, `order_type_desc`, `encrypt_post_receiver`, `seller_words`, `receipt_date`, `trade_type_desc`, `trade_type`, `promotion_redpack_amount`, `promotion_pay_amount`, `main_status`, `mask_post_tel`, `user_tag_ui`, `origin_data`, `yuce_cube_shop_id`, `yuce_tenant_id`, `yuce_task_instance_id`, `yuce_data_create_time`, `dt`) (SELECT `tax_amount`, `post_amount`, `open_id`, `order_tag`, `biz_desc`, `mask_post_receiver`, `shop_order_tag_ui`, `shop_cost_amount`, `supermarket_order_serial_no`, `mask_post_addr`, `order_status`, `biz`, `recommend_end_ship_time`, `only_platform_cost_amount`, `order_amount`, `author_cost_amount`, `user_coordinate`, `order_type`, `app_id`, `modify_post_amount`, `promise_detail`, `d_car_shop_biz_data`, `open_address_id`, `create_time`, `order_expire_time`, `shop_name`, `buyer_words`, `promotion_amount`, `post_promotion_amount`, `promotion_shop_amount`, `finish_time`, `pay_time`, `user_id_info`, `shop_id`, `appointment_ship_time`, `total_promotion_amount`, `post_insurance_amount`, `exp_ship_time`, `address_tag_ui`, `channel_payment_no`, `order_status_desc`, `latest_receipt_time`, `order_id`, `serial_number_list`, `order_operate_record_list`, `order_phase_list`, `sub_b_type`, `ship_time`, `promise_info`, `user_nick_name`, `shop_period_purchase_info`, `post_origin_amount`, `recommend_start_ship_time`, `promotion_redpack_talent_amount`, `update_time`, `seller_remark_stars`, `earliest_receipt_time`, `promotion_platform_amount`, `sku_order_list`, `doudian_open_id`, `user_icon`, `pay_type`, `promotion_talent_amount`, `b_type`, `platform_cost_amount`, `promotion_redpack_platform_amount`, `encrypt_post_tel`, `modify_amount`, `consolidate_info`, `b_type_desc`, `promotion_detail`, `early_arrival`, `sub_b_type_desc`, `pay_amount`, `order_level`, `tax_amount_not_come_out`, `post_addr`, `logistics_info`, `main_status_desc`, `target_arrival_time`, `cancel_reason`, `aweme_id`, `order_type_desc`, `encrypt_post_receiver`, `seller_words`, `receipt_date`, `trade_type_desc`, `trade_type`, `promotion_redpack_amount`, `promotion_pay_amount`, `main_status`, `mask_post_tel`, `user_tag_ui`, `origin_data`, `yuce_cube_shop_id`, `yuce_tenant_id`, `yuce_task_instance_id`, `yuce_data_create_time`, `dt` FROM (SELECT CASE WHEN CASE WHEN `ods_db_dd_sale_order_list_info_du`.`update_time` IS NOT NULL THEN `ods_db_dd_sale_order_list_info_du`.`update_time` ELSE '' END < CASE WHEN `t1`.`update_time` IS NOT NULL THEN `t1`.`update_time` ELSE '' END THEN `t1`.`tax_amount` ELSE `ods_db_dd_sale_order_list_info_du`.`tax_amount` END AS `tax_amount`, CASE WHEN CASE WHEN `ods_db_dd_sale_order_list_info_du`.`update_time` IS NOT NULL THEN `ods_db_dd_sale_order_list_info_du`.`update_time` ELSE '' END < CASE WHEN `t1`.`update_time` IS NOT NULL THEN `t1`.`update_time` ELSE '' END THEN `t1`.`post_amount` ELSE `ods_db_dd_sale_order_list_info_du`.`post_amount` END AS `post_amount`, CASE WHEN CASE WHEN `ods_db_dd_sale_order_list_info_du`.`update_time` IS NOT NULL THEN `ods_db_dd_sale_order_list_info_du`.`update_time` ELSE '' END < CASE WHEN `t1`.`update_time` IS NOT NULL THEN `t1`.`update_time` ELSE '' END THEN `t1`.`open_id` ELSE `ods_db_dd_sale_order_list_info_du`.`open_id` END AS `open_id`, CASE WHEN CASE WHEN `ods_db_dd_sale_order_list_info_du`.`update_time` IS NOT NULL THEN `ods_db_dd_sale_order_list_info_du`.`update_time` ELSE '' END < CASE WHEN `t1`.`update_time` IS NOT NULL THEN `t1`.`update_time` ELSE '' END THEN `t1`.`order_tag` ELSE `ods_db_dd_sale_order_list_info_du`.`order_tag` END AS `order_tag`, CASE WHEN CASE WHEN `ods_db_dd_sale_order_list_info_du`.`update_time` IS NOT NULL THEN `ods_db_dd_sale_order_list_info_du`.`update_time` ELSE '' END < CASE WHEN `t1`.`update_time` IS NOT NULL THEN `t1`.`update_time` ELSE '' END THEN `t1`.`biz_desc` ELSE `ods_db_dd_sale_order_list_info_du`.`biz_desc` END AS `biz_desc`, CASE WHEN CASE WHEN `ods_db_dd_sale_order_list_info_du`.`update_time` IS NOT NULL THEN `ods_db_dd_sale_order_list_info_du`.`update_time` ELSE '' END < CASE WHEN `t1`.`update_time` IS NOT NULL THEN `t1`.`update_time` ELSE '' END THEN `t1`.`mask_post_receiver` ELSE `ods_db_dd_sale_order_list_info_du`.`mask_post_receiver` END AS `mask_post_receiver`, CASE WHEN CASE WHEN `ods_db_dd_sale_order_list_info_du`.`update_time` IS NOT NULL THEN `ods_db_dd_sale_order_list_info_du`.`update_time` ELSE '' END < CASE WHEN `t1`.`update_time` IS NOT NULL THEN `t1`.`update_time` ELSE '' END THEN `t1`.`shop_order_tag_ui` ELSE `ods_db_dd_sale_order_list_info_du`.`shop_order_tag_ui` END AS `shop_order_tag_ui`, CASE WHEN CASE WHEN `ods_db_dd_sale_order_list_info_du`.`update_time` IS NOT NULL THEN `ods_db_dd_sale_order_list_info_du`.`update_time` ELSE '' END < CASE WHEN `t1`.`update_time` IS NOT NULL THEN `t1`.`update_time` ELSE '' END THEN `t1`.`shop_cost_amount` ELSE `ods_db_dd_sale_order_list_info_du`.`shop_cost_amount` END AS `shop_cost_amount`, CASE WHEN CASE WHEN `ods_db_dd_sale_order_list_info_du`.`update_time` IS NOT NULL THEN `ods_db_dd_sale_order_list_info_du`.`update_time` ELSE '' END < CASE WHEN `t1`.`update_time` IS NOT NULL THEN `t1`.`update_time` ELSE '' END THEN `t1`.`supermarket_order_serial_no` ELSE `ods_db_dd_sale_order_list_info_du`.`supermarket_order_serial_no` END AS `supermarket_order_serial_no`, CASE WHEN CASE WHEN `ods_db_dd_sale_order_list_info_du`.`update_time` IS NOT NULL THEN `ods_db_dd_sale_order_list_info_du`.`update_time` ELSE '' END < CASE WHEN `t1`.`update_time` IS NOT NULL THEN `t1`.`update_time` ELSE '' END THEN `t1`.`mask_post_addr` ELSE `ods_db_dd_sale_order_list_info_du`.`mask_post_addr` END AS `mask_post_addr`, CASE WHEN CASE WHEN `ods_db_dd_sale_order_list_info_du`.`update_time` IS NOT NULL THEN `ods_db_dd_sale_order_list_info_du`.`update_time` ELSE '' END < CASE WHEN `t1`.`update_time` IS NOT NULL THEN `t1`.`update_time` ELSE '' END THEN `t1`.`order_status` ELSE `ods_db_dd_sale_order_list_info_du`.`order_status` END AS `order_status`, CASE WHEN CASE WHEN `ods_db_dd_sale_order_list_info_du`.`update_time` IS NOT NULL THEN `ods_db_dd_sale_order_list_info_du`.`update_time` ELSE '' END < CASE WHEN `t1`.`update_time` IS NOT NULL THEN `t1`.`update_time` ELSE '' END THEN `t1`.`biz` ELSE `ods_db_dd_sale_order_list_info_du`.`biz` END AS `biz`, CASE WHEN CASE WHEN `ods_db_dd_sale_order_list_info_du`.`update_time` IS NOT NULL THEN `ods_db_dd_sale_order_list_info_du`.`update_time` ELSE '' END < CASE WHEN `t1`.`update_time` IS NOT NULL THEN `t1`.`update_time` ELSE '' END THEN `t1`.`recommend_end_ship_time` ELSE `ods_db_dd_sale_order_list_info_du`.`recommend_end_ship_time` END AS `recommend_end_ship_time`, CASE WHEN CASE WHEN `ods_db_dd_sale_order_list_info_du`.`update_time` IS NOT NULL THEN `ods_db_dd_sale_order_list_info_du`.`update_time` ELSE '' END < CASE WHEN `t1`.`update_time` IS NOT NULL THEN `t1`.`update_time` ELSE '' END THEN `t1`.`only_platform_cost_amount` ELSE `ods_db_dd_sale_order_list_info_du`.`only_platform_cost_amount` END AS `only_platform_cost_amount`, CASE WHEN CASE WHEN `ods_db_dd_sale_order_list_info_du`.`update_time` IS NOT NULL THEN `ods_db_dd_sale_order_list_info_du`.`update_time` ELSE '' END < CASE WHEN `t1`.`update_time` IS NOT NULL THEN `t1`.`update_time` ELSE '' END THEN `t1`.`order_amount` ELSE `ods_db_dd_sale_order_list_info_du`.`order_amount` END AS `order_amount`, CASE WHEN CASE WHEN `ods_db_dd_sale_order_list_info_du`.`update_time` IS NOT NULL THEN `ods_db_dd_sale_order_list_info_du`.`update_time` ELSE '' END < CASE WHEN `t1`.`update_time` IS NOT NULL THEN `t1`.`update_time` ELSE '' END THEN `t1`.`author_cost_amount` ELSE `ods_db_dd_sale_order_list_info_du`.`author_cost_amount` END AS `author_cost_amount`, CASE WHEN CASE WHEN `ods_db_dd_sale_order_list_info_du`.`update_time` IS NOT NULL THEN `ods_db_dd_sale_order_list_info_du`.`update_time` ELSE '' END < CASE WHEN `t1`.`update_time` IS NOT NULL THEN `t1`.`update_time` ELSE '' END THEN `t1`.`user_coordinate` ELSE `ods_db_dd_sale_order_list_info_du`.`user_coordinate` END AS `user_coordinate`, CASE WHEN CASE WHEN `ods_db_dd_sale_order_list_info_du`.`update_time` IS NOT NULL THEN `ods_db_dd_sale_order_list_info_du`.`update_time` ELSE '' END < CASE WHEN `t1`.`update_time` IS NOT NULL THEN `t1`.`update_time` ELSE '' END THEN `t1`.`order_type` ELSE `ods_db_dd_sale_order_list_info_du`.`order_type` END AS `order_type`, CASE WHEN CASE WHEN `ods_db_dd_sale_order_list_info_du`.`update_time` IS NOT NULL THEN `ods_db_dd_sale_order_list_info_du`.`update_time` ELSE '' END < CASE WHEN `t1`.`update_time` IS NOT NULL THEN `t1`.`update_time` ELSE '' END THEN `t1`.`app_id` ELSE `ods_db_dd_sale_order_list_info_du`.`app_id` END AS `app_id`, CASE WHEN CASE WHEN `ods_db_dd_sale_order_list_info_du`.`update_time` IS NOT NULL THEN `ods_db_dd_sale_order_list_info_du`.`update_time` ELSE '' END < CASE WHEN `t1`.`update_time` IS NOT NULL THEN `t1`.`update_time` ELSE '' END THEN `t1`.`modify_post_amount` ELSE `ods_db_dd_sale_order_list_info_du`.`modify_post_amount` END AS `modify_post_amount`, CASE WHEN CASE WHEN `ods_db_dd_sale_order_list_info_du`.`update_time` IS NOT NULL THEN `ods_db_dd_sale_order_list_info_du`.`update_time` ELSE '' END < CASE WHEN `t1`.`update_time` IS NOT NULL THEN `t1`.`update_time` ELSE '' END THEN `t1`.`promise_detail` ELSE `ods_db_dd_sale_order_list_info_du`.`promise_detail` END AS `promise_detail`, CASE WHEN CASE WHEN `ods_db_dd_sale_order_list_info_du`.`update_time` IS NOT NULL THEN `ods_db_dd_sale_order_list_info_du`.`update_time` ELSE '' END < CASE WHEN `t1`.`update_time` IS NOT NULL THEN `t1`.`update_time` ELSE '' END THEN `t1`.`d_car_shop_biz_data` ELSE `ods_db_dd_sale_order_list_info_du`.`d_car_shop_biz_data` END AS `d_car_shop_biz_data`, CASE WHEN CASE WHEN `ods_db_dd_sale_order_list_info_du`.`update_time` IS NOT NULL THEN `ods_db_dd_sale_order_list_info_du`.`update_time` ELSE '' END < CASE WHEN `t1`.`update_time` IS NOT NULL THEN `t1`.`update_time` ELSE '' END THEN `t1`.`open_address_id` ELSE `ods_db_dd_sale_order_list_info_du`.`open_address_id` END AS `open_address_id`, CASE WHEN CASE WHEN `ods_db_dd_sale_order_list_info_du`.`update_time` IS NOT NULL THEN `ods_db_dd_sale_order_list_info_du`.`update_time` ELSE '' END < CASE WHEN `t1`.`update_time` IS NOT NULL THEN `t1`.`update_time` ELSE '' END THEN `t1`.`create_time` ELSE `ods_db_dd_sale_order_list_info_du`.`create_time` END AS `create_time`, CASE WHEN CASE WHEN `ods_db_dd_sale_order_list_info_du`.`update_time` IS NOT NULL THEN `ods_db_dd_sale_order_list_info_du`.`update_time` ELSE '' END < CASE WHEN `t1`.`update_time` IS NOT NULL THEN `t1`.`update_time` ELSE '' END THEN `t1`.`order_expire_time` ELSE `ods_db_dd_sale_order_list_info_du`.`order_expire_time` END AS `order_expire_time`, CASE WHEN CASE WHEN `ods_db_dd_sale_order_list_info_du`.`update_time` IS NOT NULL THEN `ods_db_dd_sale_order_list_info_du`.`update_time` ELSE '' END < CASE WHEN `t1`.`update_time` IS NOT NULL THEN `t1`.`update_time` ELSE '' END THEN `t1`.`shop_name` ELSE `ods_db_dd_sale_order_list_info_du`.`shop_name` END AS `shop_name`, CASE WHEN CASE WHEN `ods_db_dd_sale_order_list_info_du`.`update_time` IS NOT NULL THEN `ods_db_dd_sale_order_list_info_du`.`update_time` ELSE '' END < CASE WHEN `t1`.`update_time` IS NOT NULL THEN `t1`.`update_time` ELSE '' END THEN `t1`.`buyer_words` ELSE `ods_db_dd_sale_order_list_info_du`.`buyer_words` END AS `buyer_words`, CASE WHEN CASE WHEN `ods_db_dd_sale_order_list_info_du`.`update_time` IS NOT NULL THEN `ods_db_dd_sale_order_list_info_du`.`update_time` ELSE '' END < CASE WHEN `t1`.`update_time` IS NOT NULL THEN `t1`.`update_time` ELSE '' END THEN `t1`.`promotion_amount` ELSE `ods_db_dd_sale_order_list_info_du`.`promotion_amount` END AS `promotion_amount`, CASE WHEN CASE WHEN `ods_db_dd_sale_order_list_info_du`.`update_time` IS NOT NULL THEN `ods_db_dd_sale_order_list_info_du`.`update_time` ELSE '' END < CASE WHEN `t1`.`update_time` IS NOT NULL THEN `t1`.`update_time` ELSE '' END THEN `t1`.`post_promotion_amount` ELSE `ods_db_dd_sale_order_list_info_du`.`post_promotion_amount` END AS `post_promotion_amount`, CASE WHEN CASE WHEN `ods_db_dd_sale_order_list_info_du`.`update_time` IS NOT NULL THEN `ods_db_dd_sale_order_list_info_du`.`update_time` ELSE '' END < CASE WHEN `t1`.`update_time` IS NOT NULL THEN `t1`.`update_time` ELSE '' END THEN `t1`.`promotion_shop_amount` ELSE `ods_db_dd_sale_order_list_info_du`.`promotion_shop_amount` END AS `promotion_shop_amount`, CASE WHEN CASE WHEN `ods_db_dd_sale_order_list_info_du`.`update_time` IS NOT NULL THEN `ods_db_dd_sale_order_list_info_du`.`update_time` ELSE '' END < CASE WHEN `t1`.`update_time` IS NOT NULL THEN `t1`.`update_time` ELSE '' END THEN `t1`.`finish_time` ELSE `ods_db_dd_sale_order_list_info_du`.`finish_time` END AS `finish_time`, CASE WHEN CASE WHEN `ods_db_dd_sale_order_list_info_du`.`update_time` IS NOT NULL THEN `ods_db_dd_sale_order_list_info_du`.`update_time` ELSE '' END < CASE WHEN `t1`.`update_time` IS NOT NULL THEN `t1`.`update_time` ELSE '' END THEN `t1`.`pay_time` ELSE `ods_db_dd_sale_order_list_info_du`.`pay_time` END AS `pay_time`, CASE WHEN CASE WHEN `ods_db_dd_sale_order_list_info_du`.`update_time` IS NOT NULL THEN `ods_db_dd_sale_order_list_info_du`.`update_time` ELSE '' END < CASE WHEN `t1`.`update_time` IS NOT NULL THEN `t1`.`update_time` ELSE '' END THEN `t1`.`user_id_info` ELSE `ods_db_dd_sale_order_list_info_du`.`user_id_info` END AS `user_id_info`, CASE WHEN CASE WHEN `ods_db_dd_sale_order_list_info_du`.`update_time` IS NOT NULL THEN `ods_db_dd_sale_order_list_info_du`.`update_time` ELSE '' END < CASE WHEN `t1`.`update_time` IS NOT NULL THEN `t1`.`update_time` ELSE '' END THEN `t1`.`shop_id` ELSE `ods_db_dd_sale_order_list_info_du`.`shop_id` END AS `shop_id`, CASE WHEN CASE WHEN `ods_db_dd_sale_order_list_info_du`.`update_time` IS NOT NULL THEN `ods_db_dd_sale_order_list_info_du`.`update_time` ELSE '' END < CASE WHEN `t1`.`update_time` IS NOT NULL THEN `t1`.`update_time` ELSE '' END THEN `t1`.`appointment_ship_time` ELSE `ods_db_dd_sale_order_list_info_du`.`appointment_ship_time` END AS `appointment_ship_time`, CASE WHEN CASE WHEN `ods_db_dd_sale_order_list_info_du`.`update_time` IS NOT NULL THEN `ods_db_dd_sale_order_list_info_du`.`update_time` ELSE '' END < CASE WHEN `t1`.`update_time` IS NOT NULL THEN `t1`.`update_time` ELSE '' END THEN `t1`.`total_promotion_amount` ELSE `ods_db_dd_sale_order_list_info_du`.`total_promotion_amount` END AS `total_promotion_amount`, CASE WHEN CASE WHEN `ods_db_dd_sale_order_list_info_du`.`update_time` IS NOT NULL THEN `ods_db_dd_sale_order_list_info_du`.`update_time` ELSE '' END < CASE WHEN `t1`.`update_time` IS NOT NULL THEN `t1`.`update_time` ELSE '' END THEN `t1`.`post_insurance_amount` ELSE `ods_db_dd_sale_order_list_info_du`.`post_insurance_amount` END AS `post_insurance_amount`, CASE WHEN CASE WHEN `ods_db_dd_sale_order_list_info_du`.`update_time` IS NOT NULL THEN `ods_db_dd_sale_order_list_info_du`.`update_time` ELSE '' END < CASE WHEN `t1`.`update_time` IS NOT NULL THEN `t1`.`update_time` ELSE '' END THEN `t1`.`exp_ship_time` ELSE `ods_db_dd_sale_order_list_info_du`.`exp_ship_time` END AS `exp_ship_time`, CASE WHEN CASE WHEN `ods_db_dd_sale_order_list_info_du`.`update_time` IS NOT NULL THEN `ods_db_dd_sale_order_list_info_du`.`update_time` ELSE '' END < CASE WHEN `t1`.`update_time` IS NOT NULL THEN `t1`.`update_time` ELSE '' END THEN `t1`.`address_tag_ui` ELSE `ods_db_dd_sale_order_list_info_du`.`address_tag_ui` END AS `address_tag_ui`, CASE WHEN CASE WHEN `ods_db_dd_sale_order_list_info_du`.`update_time` IS NOT NULL THEN `ods_db_dd_sale_order_list_info_du`.`update_time` ELSE '' END < CASE WHEN `t1`.`update_time` IS NOT NULL THEN `t1`.`update_time` ELSE '' END THEN `t1`.`channel_payment_no` ELSE `ods_db_dd_sale_order_list_info_du`.`channel_payment_no` END AS `channel_payment_no`, CASE WHEN CASE WHEN `ods_db_dd_sale_order_list_info_du`.`update_time` IS NOT NULL THEN `ods_db_dd_sale_order_list_info_du`.`update_time` ELSE '' END < CASE WHEN `t1`.`update_time` IS NOT NULL THEN `t1`.`update_time` ELSE '' END THEN `t1`.`order_status_desc` ELSE `ods_db_dd_sale_order_list_info_du`.`order_status_desc` END AS `order_status_desc`, CASE WHEN CASE WHEN `ods_db_dd_sale_order_list_info_du`.`update_time` IS NOT NULL THEN `ods_db_dd_sale_order_list_info_du`.`update_time` ELSE '' END < CASE WHEN `t1`.`update_time` IS NOT NULL THEN `t1`.`update_time` ELSE '' END THEN `t1`.`latest_receipt_time` ELSE `ods_db_dd_sale_order_list_info_du`.`latest_receipt_time` END AS `latest_receipt_time`, CASE WHEN CASE WHEN `ods_db_dd_sale_order_list_info_du`.`update_time` IS NOT NULL THEN `ods_db_dd_sale_order_list_info_du`.`update_time` ELSE '' END < CASE WHEN `t1`.`update_time` IS NOT NULL THEN `t1`.`update_time` ELSE '' END THEN `t1`.`order_id` ELSE `ods_db_dd_sale_order_list_info_du`.`order_id` END AS `order_id`, CASE WHEN CASE WHEN `ods_db_dd_sale_order_list_info_du`.`update_time` IS NOT NULL THEN `ods_db_dd_sale_order_list_info_du`.`update_time` ELSE '' END < CASE WHEN `t1`.`update_time` IS NOT NULL THEN `t1`.`update_time` ELSE '' END THEN `t1`.`serial_number_list` ELSE `ods_db_dd_sale_order_list_info_du`.`serial_number_list` END AS `serial_number_list`, CASE WHEN CASE WHEN `ods_db_dd_sale_order_list_info_du`.`update_time` IS NOT NULL THEN `ods_db_dd_sale_order_list_info_du`.`update_time` ELSE '' END < CASE WHEN `t1`.`update_time` IS NOT NULL THEN `t1`.`update_time` ELSE '' END THEN `t1`.`order_operate_record_list` ELSE `ods_db_dd_sale_order_list_info_du`.`order_operate_record_list` END AS `order_operate_record_list`, CASE WHEN CASE WHEN `ods_db_dd_sale_order_list_info_du`.`update_time` IS NOT NULL THEN `ods_db_dd_sale_order_list_info_du`.`update_time` ELSE '' END < CASE WHEN `t1`.`update_time` IS NOT NULL THEN `t1`.`update_time` ELSE '' END THEN `t1`.`order_phase_list` ELSE `ods_db_dd_sale_order_list_info_du`.`order_phase_list` END AS `order_phase_list`, CASE WHEN CASE WHEN `ods_db_dd_sale_order_list_info_du`.`update_time` IS NOT NULL THEN `ods_db_dd_sale_order_list_info_du`.`update_time` ELSE '' END < CASE WHEN `t1`.`update_time` IS NOT NULL THEN `t1`.`update_time` ELSE '' END THEN `t1`.`sub_b_type` ELSE `ods_db_dd_sale_order_list_info_du`.`sub_b_type` END AS `sub_b_type`, CASE WHEN CASE WHEN `ods_db_dd_sale_order_list_info_du`.`update_time` IS NOT NULL THEN `ods_db_dd_sale_order_list_info_du`.`update_time` ELSE '' END < CASE WHEN `t1`.`update_time` IS NOT NULL THEN `t1`.`update_time` ELSE '' END THEN `t1`.`ship_time` ELSE `ods_db_dd_sale_order_list_info_du`.`ship_time` END AS `ship_time`, CASE WHEN CASE WHEN `ods_db_dd_sale_order_list_info_du`.`update_time` IS NOT NULL THEN `ods_db_dd_sale_order_list_info_du`.`update_time` ELSE '' END < CASE WHEN `t1`.`update_time` IS NOT NULL THEN `t1`.`update_time` ELSE '' END THEN `t1`.`promise_info` ELSE `ods_db_dd_sale_order_list_info_du`.`promise_info` END AS `promise_info`, CASE WHEN CASE WHEN `ods_db_dd_sale_order_list_info_du`.`update_time` IS NOT NULL THEN `ods_db_dd_sale_order_list_info_du`.`update_time` ELSE '' END < CASE WHEN `t1`.`update_time` IS NOT NULL THEN `t1`.`update_time` ELSE '' END THEN `t1`.`user_nick_name` ELSE `ods_db_dd_sale_order_list_info_du`.`user_nick_name` END AS `user_nick_name`, CASE WHEN CASE WHEN `ods_db_dd_sale_order_list_info_du`.`update_time` IS NOT NULL THEN `ods_db_dd_sale_order_list_info_du`.`update_time` ELSE '' END < CASE WHEN `t1`.`update_time` IS NOT NULL THEN `t1`.`update_time` ELSE '' END THEN `t1`.`shop_period_purchase_info` ELSE `ods_db_dd_sale_order_list_info_du`.`shop_period_purchase_info` END AS `shop_period_purchase_info`, CASE WHEN CASE WHEN `ods_db_dd_sale_order_list_info_du`.`update_time` IS NOT NULL THEN `ods_db_dd_sale_order_list_info_du`.`update_time` ELSE '' END < CASE WHEN `t1`.`update_time` IS NOT NULL THEN `t1`.`update_time` ELSE '' END THEN `t1`.`post_origin_amount` ELSE `ods_db_dd_sale_order_list_info_du`.`post_origin_amount` END AS `post_origin_amount`, CASE WHEN CASE WHEN `ods_db_dd_sale_order_list_info_du`.`update_time` IS NOT NULL THEN `ods_db_dd_sale_order_list_info_du`.`update_time` ELSE '' END < CASE WHEN `t1`.`update_time` IS NOT NULL THEN `t1`.`update_time` ELSE '' END THEN `t1`.`recommend_start_ship_time` ELSE `ods_db_dd_sale_order_list_info_du`.`recommend_start_ship_time` END AS `recommend_start_ship_time`, CASE WHEN CASE WHEN `ods_db_dd_sale_order_list_info_du`.`update_time` IS NOT NULL THEN `ods_db_dd_sale_order_list_info_du`.`update_time` ELSE '' END < CASE WHEN `t1`.`update_time` IS NOT NULL THEN `t1`.`update_time` ELSE '' END THEN `t1`.`promotion_redpack_talent_amount` ELSE `ods_db_dd_sale_order_list_info_du`.`promotion_redpack_talent_amount` END AS `promotion_redpack_talent_amount`, CASE WHEN CASE WHEN `ods_db_dd_sale_order_list_info_du`.`update_time` IS NOT NULL THEN `ods_db_dd_sale_order_list_info_du`.`update_time` ELSE '' END < CASE WHEN `t1`.`update_time` IS NOT NULL THEN `t1`.`update_time` ELSE '' END THEN `t1`.`update_time` ELSE `ods_db_dd_sale_order_list_info_du`.`update_time` END AS `update_time`, CASE WHEN CASE WHEN `ods_db_dd_sale_order_list_info_du`.`update_time` IS NOT NULL THEN `ods_db_dd_sale_order_list_info_du`.`update_time` ELSE '' END < CASE WHEN `t1`.`update_time` IS NOT NULL THEN `t1`.`update_time` ELSE '' END THEN `t1`.`seller_remark_stars` ELSE `ods_db_dd_sale_order_list_info_du`.`seller_remark_stars` END AS `seller_remark_stars`, CASE WHEN CASE WHEN `ods_db_dd_sale_order_list_info_du`.`update_time` IS NOT NULL THEN `ods_db_dd_sale_order_list_info_du`.`update_time` ELSE '' END < CASE WHEN `t1`.`update_time` IS NOT NULL THEN `t1`.`update_time` ELSE '' END THEN `t1`.`earliest_receipt_time` ELSE `ods_db_dd_sale_order_list_info_du`.`earliest_receipt_time` END AS `earliest_receipt_time`, CASE WHEN CASE WHEN `ods_db_dd_sale_order_list_info_du`.`update_time` IS NOT NULL THEN `ods_db_dd_sale_order_list_info_du`.`update_time` ELSE '' END < CASE WHEN `t1`.`update_time` IS NOT NULL THEN `t1`.`update_time` ELSE '' END THEN `t1`.`promotion_platform_amount` ELSE `ods_db_dd_sale_order_list_info_du`.`promotion_platform_amount` END AS `promotion_platform_amount`, CASE WHEN CASE WHEN `ods_db_dd_sale_order_list_info_du`.`update_time` IS NOT NULL THEN `ods_db_dd_sale_order_list_info_du`.`update_time` ELSE '' END < CASE WHEN `t1`.`update_time` IS NOT NULL THEN `t1`.`update_time` ELSE '' END THEN `t1`.`sku_order_list` ELSE `ods_db_dd_sale_order_list_info_du`.`sku_order_list` END AS `sku_order_list`, CASE WHEN CASE WHEN `ods_db_dd_sale_order_list_info_du`.`update_time` IS NOT NULL THEN `ods_db_dd_sale_order_list_info_du`.`update_time` ELSE '' END < CASE WHEN `t1`.`update_time` IS NOT NULL THEN `t1`.`update_time` ELSE '' END THEN `t1`.`doudian_open_id` ELSE `ods_db_dd_sale_order_list_info_du`.`doudian_open_id` END AS `doudian_open_id`, CASE WHEN CASE WHEN `ods_db_dd_sale_order_list_info_du`.`update_time` IS NOT NULL THEN `ods_db_dd_sale_order_list_info_du`.`update_time` ELSE '' END < CASE WHEN `t1`.`update_time` IS NOT NULL THEN `t1`.`update_time` ELSE '' END THEN `t1`.`user_icon` ELSE `ods_db_dd_sale_order_list_info_du`.`user_icon` END AS `user_icon`, CASE WHEN CASE WHEN `ods_db_dd_sale_order_list_info_du`.`update_time` IS NOT NULL THEN `ods_db_dd_sale_order_list_info_du`.`update_time` ELSE '' END < CASE WHEN `t1`.`update_time` IS NOT NULL THEN `t1`.`update_time` ELSE '' END THEN `t1`.`pay_type` ELSE `ods_db_dd_sale_order_list_info_du`.`pay_type` END AS `pay_type`, CASE WHEN CASE WHEN `ods_db_dd_sale_order_list_info_du`.`update_time` IS NOT NULL THEN `ods_db_dd_sale_order_list_info_du`.`update_time` ELSE '' END < CASE WHEN `t1`.`update_time` IS NOT NULL THEN `t1`.`update_time` ELSE '' END THEN `t1`.`promotion_talent_amount` ELSE `ods_db_dd_sale_order_list_info_du`.`promotion_talent_amount` END AS `promotion_talent_amount`, CASE WHEN CASE WHEN `ods_db_dd_sale_order_list_info_du`.`update_time` IS NOT NULL THEN `ods_db_dd_sale_order_list_info_du`.`update_time` ELSE '' END < CASE WHEN `t1`.`update_time` IS NOT NULL THEN `t1`.`update_time` ELSE '' END THEN `t1`.`b_type` ELSE `ods_db_dd_sale_order_list_info_du`.`b_type` END AS `b_type`, CASE WHEN CASE WHEN `ods_db_dd_sale_order_list_info_du`.`update_time` IS NOT NULL THEN `ods_db_dd_sale_order_list_info_du`.`update_time` ELSE '' END < CASE WHEN `t1`.`update_time` IS NOT NULL THEN `t1`.`update_time` ELSE '' END THEN `t1`.`platform_cost_amount` ELSE `ods_db_dd_sale_order_list_info_du`.`platform_cost_amount` END AS `platform_cost_amount`, CASE WHEN CASE WHEN `ods_db_dd_sale_order_list_info_du`.`update_time` IS NOT NULL THEN `ods_db_dd_sale_order_list_info_du`.`update_time` ELSE '' END < CASE WHEN `t1`.`update_time` IS NOT NULL THEN `t1`.`update_time` ELSE '' END THEN `t1`.`promotion_redpack_platform_amount` ELSE `ods_db_dd_sale_order_list_info_du`.`promotion_redpack_platform_amount` END AS `promotion_redpack_platform_amount`, CASE WHEN CASE WHEN `ods_db_dd_sale_order_list_info_du`.`update_time` IS NOT NULL THEN `ods_db_dd_sale_order_list_info_du`.`update_time` ELSE '' END < CASE WHEN `t1`.`update_time` IS NOT NULL THEN `t1`.`update_time` ELSE '' END THEN `t1`.`encrypt_post_tel` ELSE `ods_db_dd_sale_order_list_info_du`.`encrypt_post_tel` END AS `encrypt_post_tel`, CASE WHEN CASE WHEN `ods_db_dd_sale_order_list_info_du`.`update_time` IS NOT NULL THEN `ods_db_dd_sale_order_list_info_du`.`update_time` ELSE '' END < CASE WHEN `t1`.`update_time` IS NOT NULL THEN `t1`.`update_time` ELSE '' END THEN `t1`.`modify_amount` ELSE `ods_db_dd_sale_order_list_info_du`.`modify_amount` END AS `modify_amount`, CASE WHEN CASE WHEN `ods_db_dd_sale_order_list_info_du`.`update_time` IS NOT NULL THEN `ods_db_dd_sale_order_list_info_du`.`update_time` ELSE '' END < CASE WHEN `t1`.`update_time` IS NOT NULL THEN `t1`.`update_time` ELSE '' END THEN `t1`.`consolidate_info` ELSE `ods_db_dd_sale_order_list_info_du`.`consolidate_info` END AS `consolidate_info`, CASE WHEN CASE WHEN `ods_db_dd_sale_order_list_info_du`.`update_time` IS NOT NULL THEN `ods_db_dd_sale_order_list_info_du`.`update_time` ELSE '' END < CASE WHEN `t1`.`update_time` IS NOT NULL THEN `t1`.`update_time` ELSE '' END THEN `t1`.`b_type_desc` ELSE `ods_db_dd_sale_order_list_info_du`.`b_type_desc` END AS `b_type_desc`, CASE WHEN CASE WHEN `ods_db_dd_sale_order_list_info_du`.`update_time` IS NOT NULL THEN `ods_db_dd_sale_order_list_info_du`.`update_time` ELSE '' END < CASE WHEN `t1`.`update_time` IS NOT NULL THEN `t1`.`update_time` ELSE '' END THEN `t1`.`promotion_detail` ELSE `ods_db_dd_sale_order_list_info_du`.`promotion_detail` END AS `promotion_detail`, CASE WHEN CASE WHEN `ods_db_dd_sale_order_list_info_du`.`update_time` IS NOT NULL THEN `ods_db_dd_sale_order_list_info_du`.`update_time` ELSE '' END < CASE WHEN `t1`.`update_time` IS NOT NULL THEN `t1`.`update_time` ELSE '' END THEN `t1`.`early_arrival` ELSE `ods_db_dd_sale_order_list_info_du`.`early_arrival` END AS `early_arrival`, CASE WHEN CASE WHEN `ods_db_dd_sale_order_list_info_du`.`update_time` IS NOT NULL THEN `ods_db_dd_sale_order_list_info_du`.`update_time` ELSE '' END < CASE WHEN `t1`.`update_time` IS NOT NULL THEN `t1`.`update_time` ELSE '' END THEN `t1`.`sub_b_type_desc` ELSE `ods_db_dd_sale_order_list_info_du`.`sub_b_type_desc` END AS `sub_b_type_desc`, CASE WHEN CASE WHEN `ods_db_dd_sale_order_list_info_du`.`update_time` IS NOT NULL THEN `ods_db_dd_sale_order_list_info_du`.`update_time` ELSE '' END < CASE WHEN `t1`.`update_time` IS NOT NULL THEN `t1`.`update_time` ELSE '' END THEN `t1`.`pay_amount` ELSE `ods_db_dd_sale_order_list_info_du`.`pay_amount` END AS `pay_amount`, CASE WHEN CASE WHEN `ods_db_dd_sale_order_list_info_du`.`update_time` IS NOT NULL THEN `ods_db_dd_sale_order_list_info_du`.`update_time` ELSE '' END < CASE WHEN `t1`.`update_time` IS NOT NULL THEN `t1`.`update_time` ELSE '' END THEN `t1`.`order_level` ELSE `ods_db_dd_sale_order_list_info_du`.`order_level` END AS `order_level`, CASE WHEN CASE WHEN `ods_db_dd_sale_order_list_info_du`.`update_time` IS NOT NULL THEN `ods_db_dd_sale_order_list_info_du`.`update_time` ELSE '' END < CASE WHEN `t1`.`update_time` IS NOT NULL THEN `t1`.`update_time` ELSE '' END THEN `t1`.`tax_amount_not_come_out` ELSE `ods_db_dd_sale_order_list_info_du`.`tax_amount_not_come_out` END AS `tax_amount_not_come_out`, CASE WHEN CASE WHEN `ods_db_dd_sale_order_list_info_du`.`update_time` IS NOT NULL THEN `ods_db_dd_sale_order_list_info_du`.`update_time` ELSE '' END < CASE WHEN `t1`.`update_time` IS NOT NULL THEN `t1`.`update_time` ELSE '' END THEN `t1`.`post_addr` ELSE `ods_db_dd_sale_order_list_info_du`.`post_addr` END AS `post_addr`, CASE WHEN CASE WHEN `ods_db_dd_sale_order_list_info_du`.`update_time` IS NOT NULL THEN `ods_db_dd_sale_order_list_info_du`.`update_time` ELSE '' END < CASE WHEN `t1`.`update_time` IS NOT NULL THEN `t1`.`update_time` ELSE '' END THEN `t1`.`logistics_info` ELSE `ods_db_dd_sale_order_list_info_du`.`logistics_info` END AS `logistics_info`, CASE WHEN CASE WHEN `ods_db_dd_sale_order_list_info_du`.`update_time` IS NOT NULL THEN `ods_db_dd_sale_order_list_info_du`.`update_time` ELSE '' END < CASE WHEN `t1`.`update_time` IS NOT NULL THEN `t1`.`update_time` ELSE '' END THEN `t1`.`main_status_desc` ELSE `ods_db_dd_sale_order_list_info_du`.`main_status_desc` END AS `main_status_desc`, CASE WHEN CASE WHEN `ods_db_dd_sale_order_list_info_du`.`update_time` IS NOT NULL THEN `ods_db_dd_sale_order_list_info_du`.`update_time` ELSE '' END < CASE WHEN `t1`.`update_time` IS NOT NULL THEN `t1`.`update_time` ELSE '' END THEN `t1`.`target_arrival_time` ELSE `ods_db_dd_sale_order_list_info_du`.`target_arrival_time` END AS `target_arrival_time`, CASE WHEN CASE WHEN `ods_db_dd_sale_order_list_info_du`.`update_time` IS NOT NULL THEN `ods_db_dd_sale_order_list_info_du`.`update_time` ELSE '' END < CASE WHEN `t1`.`update_time` IS NOT NULL THEN `t1`.`update_time` ELSE '' END THEN `t1`.`cancel_reason` ELSE `ods_db_dd_sale_order_list_info_du`.`cancel_reason` END AS `cancel_reason`, CASE WHEN CASE WHEN `ods_db_dd_sale_order_list_info_du`.`update_time` IS NOT NULL THEN `ods_db_dd_sale_order_list_info_du`.`update_time` ELSE '' END < CASE WHEN `t1`.`update_time` IS NOT NULL THEN `t1`.`update_time` ELSE '' END THEN `t1`.`aweme_id` ELSE `ods_db_dd_sale_order_list_info_du`.`aweme_id` END AS `aweme_id`, CASE WHEN CASE WHEN `ods_db_dd_sale_order_list_info_du`.`update_time` IS NOT NULL THEN `ods_db_dd_sale_order_list_info_du`.`update_time` ELSE '' END < CASE WHEN `t1`.`update_time` IS NOT NULL THEN `t1`.`update_time` ELSE '' END THEN `t1`.`order_type_desc` ELSE `ods_db_dd_sale_order_list_info_du`.`order_type_desc` END AS `order_type_desc`, CASE WHEN CASE WHEN `ods_db_dd_sale_order_list_info_du`.`update_time` IS NOT NULL THEN `ods_db_dd_sale_order_list_info_du`.`update_time` ELSE '' END < CASE WHEN `t1`.`update_time` IS NOT NULL THEN `t1`.`update_time` ELSE '' END THEN `t1`.`encrypt_post_receiver` ELSE `ods_db_dd_sale_order_list_info_du`.`encrypt_post_receiver` END AS `encrypt_post_receiver`, CASE WHEN CASE WHEN `ods_db_dd_sale_order_list_info_du`.`update_time` IS NOT NULL THEN `ods_db_dd_sale_order_list_info_du`.`update_time` ELSE '' END < CASE WHEN `t1`.`update_time` IS NOT NULL THEN `t1`.`update_time` ELSE '' END THEN `t1`.`seller_words` ELSE `ods_db_dd_sale_order_list_info_du`.`seller_words` END AS `seller_words`, CASE WHEN CASE WHEN `ods_db_dd_sale_order_list_info_du`.`update_time` IS NOT NULL THEN `ods_db_dd_sale_order_list_info_du`.`update_time` ELSE '' END < CASE WHEN `t1`.`update_time` IS NOT NULL THEN `t1`.`update_time` ELSE '' END THEN `t1`.`receipt_date` ELSE `ods_db_dd_sale_order_list_info_du`.`receipt_date` END AS `receipt_date`, CASE WHEN CASE WHEN `ods_db_dd_sale_order_list_info_du`.`update_time` IS NOT NULL THEN `ods_db_dd_sale_order_list_info_du`.`update_time` ELSE '' END < CASE WHEN `t1`.`update_time` IS NOT NULL THEN `t1`.`update_time` ELSE '' END THEN `t1`.`trade_type_desc` ELSE `ods_db_dd_sale_order_list_info_du`.`trade_type_desc` END AS `trade_type_desc`, CASE WHEN CASE WHEN `ods_db_dd_sale_order_list_info_du`.`update_time` IS NOT NULL THEN `ods_db_dd_sale_order_list_info_du`.`update_time` ELSE '' END < CASE WHEN `t1`.`update_time` IS NOT NULL THEN `t1`.`update_time` ELSE '' END THEN `t1`.`trade_type` ELSE `ods_db_dd_sale_order_list_info_du`.`trade_type` END AS `trade_type`, CASE WHEN CASE WHEN `ods_db_dd_sale_order_list_info_du`.`update_time` IS NOT NULL THEN `ods_db_dd_sale_order_list_info_du`.`update_time` ELSE '' END < CASE WHEN `t1`.`update_time` IS NOT NULL THEN `t1`.`update_time` ELSE '' END THEN `t1`.`promotion_redpack_amount` ELSE `ods_db_dd_sale_order_list_info_du`.`promotion_redpack_amount` END AS `promotion_redpack_amount`, CASE WHEN CASE WHEN `ods_db_dd_sale_order_list_info_du`.`update_time` IS NOT NULL THEN `ods_db_dd_sale_order_list_info_du`.`update_time` ELSE '' END < CASE WHEN `t1`.`update_time` IS NOT NULL THEN `t1`.`update_time` ELSE '' END THEN `t1`.`promotion_pay_amount` ELSE `ods_db_dd_sale_order_list_info_du`.`promotion_pay_amount` END AS `promotion_pay_amount`, CASE WHEN CASE WHEN `ods_db_dd_sale_order_list_info_du`.`update_time` IS NOT NULL THEN `ods_db_dd_sale_order_list_info_du`.`update_time` ELSE '' END < CASE WHEN `t1`.`update_time` IS NOT NULL THEN `t1`.`update_time` ELSE '' END THEN `t1`.`main_status` ELSE `ods_db_dd_sale_order_list_info_du`.`main_status` END AS `main_status`, CASE WHEN CASE WHEN `ods_db_dd_sale_order_list_info_du`.`update_time` IS NOT NULL THEN `ods_db_dd_sale_order_list_info_du`.`update_time` ELSE '' END < CASE WHEN `t1`.`update_time` IS NOT NULL THEN `t1`.`update_time` ELSE '' END THEN `t1`.`mask_post_tel` ELSE `ods_db_dd_sale_order_list_info_du`.`mask_post_tel` END AS `mask_post_tel`, CASE WHEN CASE WHEN `ods_db_dd_sale_order_list_info_du`.`update_time` IS NOT NULL THEN `ods_db_dd_sale_order_list_info_du`.`update_time` ELSE '' END < CASE WHEN `t1`.`update_time` IS NOT NULL THEN `t1`.`update_time` ELSE '' END THEN `t1`.`user_tag_ui` ELSE `ods_db_dd_sale_order_list_info_du`.`user_tag_ui` END AS `user_tag_ui`, CASE WHEN CASE WHEN `ods_db_dd_sale_order_list_info_du`.`update_time` IS NOT NULL THEN `ods_db_dd_sale_order_list_info_du`.`update_time` ELSE '' END < CASE WHEN `t1`.`update_time` IS NOT NULL THEN `t1`.`update_time` ELSE '' END THEN `t1`.`origin_data` ELSE `ods_db_dd_sale_order_list_info_du`.`origin_data` END AS `origin_data`, CASE WHEN CASE WHEN `ods_db_dd_sale_order_list_info_du`.`update_time` IS NOT NULL THEN `ods_db_dd_sale_order_list_info_du`.`update_time` ELSE '' END < CASE WHEN `t1`.`update_time` IS NOT NULL THEN `t1`.`update_time` ELSE '' END THEN `t1`.`yuce_cube_shop_id` ELSE `ods_db_dd_sale_order_list_info_du`.`yuce_cube_shop_id` END AS `yuce_cube_shop_id`, CASE WHEN CASE WHEN `ods_db_dd_sale_order_list_info_du`.`update_time` IS NOT NULL THEN `ods_db_dd_sale_order_list_info_du`.`update_time` ELSE '' END < CASE WHEN `t1`.`update_time` IS NOT NULL THEN `t1`.`update_time` ELSE '' END THEN `t1`.`yuce_tenant_id` ELSE `ods_db_dd_sale_order_list_info_du`.`yuce_tenant_id` END AS `yuce_tenant_id`, CASE WHEN CASE WHEN `ods_db_dd_sale_order_list_info_du`.`update_time` IS NOT NULL THEN `ods_db_dd_sale_order_list_info_du`.`update_time` ELSE '' END < CASE WHEN `t1`.`update_time` IS NOT NULL THEN `t1`.`update_time` ELSE '' END THEN `t1`.`yuce_task_instance_id` ELSE `ods_db_dd_sale_order_list_info_du`.`yuce_task_instance_id` END AS `yuce_task_instance_id`, CASE WHEN CASE WHEN `ods_db_dd_sale_order_list_info_du`.`update_time` IS NOT NULL THEN `ods_db_dd_sale_order_list_info_du`.`update_time` ELSE '' END < CASE WHEN `t1`.`update_time` IS NOT NULL THEN `t1`.`update_time` ELSE '' END THEN `t1`.`yuce_data_create_time` ELSE `ods_db_dd_sale_order_list_info_du`.`yuce_data_create_time` END AS `yuce_data_create_time`, CASE WHEN CASE WHEN `ods_db_dd_sale_order_list_info_du`.`update_time` IS NOT NULL THEN `ods_db_dd_sale_order_list_info_du`.`update_time` ELSE '' END < CASE WHEN `t1`.`update_time` IS NOT NULL THEN `t1`.`update_time` ELSE '' END THEN `t1`.`dt` WHEN SUBSTRING(CAST(CASE WHEN CAST(`ods_db_dd_sale_order_list_info_du`.`pay_time` AS DECIMAL(38, 8)) > 99999999999 THEN CAST(FROM_UNIXTIME(CAST(`ods_db_dd_sale_order_list_info_du`.`pay_time` AS DECIMAL(38, 8)) / 1000) AS DATETIME) WHEN CAST(`ods_db_dd_sale_order_list_info_du`.`pay_time` AS DECIMAL(38, 8)) < 30000000 THEN str_to_date(CAST(`ods_db_dd_sale_order_list_info_du`.`pay_time` AS DECIMAL(38, 8)), '%Y%m%d') ELSE CAST(FROM_UNIXTIME(CAST(`ods_db_dd_sale_order_list_info_du`.`pay_time` AS DECIMAL(38, 8))) AS DATETIME) END AS VARCHAR), 1, 10) IS NOT NULL THEN SUBSTRING(CAST(CASE WHEN CAST(`ods_db_dd_sale_order_list_info_du`.`pay_time` AS DECIMAL(38, 8)) > 99999999999 THEN CAST(FROM_UNIXTIME(CAST(`ods_db_dd_sale_order_list_info_du`.`pay_time` AS DECIMAL(38, 8)) / 1000) AS DATETIME) WHEN CAST(`ods_db_dd_sale_order_list_info_du`.`pay_time` AS DECIMAL(38, 8)) < 30000000 THEN str_to_date(CAST(`ods_db_dd_sale_order_list_info_du`.`pay_time` AS DECIMAL(38, 8)), '%Y%m%d') ELSE CAST(FROM_UNIXTIME(CAST(`ods_db_dd_sale_order_list_info_du`.`pay_time` AS DECIMAL(38, 8))) AS DATETIME) END AS VARCHAR), 1, 10) ELSE '9999-12-31' END AS `dt` FROM ((SELECT `tax_amount` AS `tax_amount`, `post_amount` AS `post_amount`, `open_id` AS `open_id`, `order_tag` AS `order_tag`, `biz_desc` AS `biz_desc`, `mask_post_receiver` AS `mask_post_receiver`, `shop_order_tag_ui` AS `shop_order_tag_ui`, `shop_cost_amount` AS `shop_cost_amount`, `supermarket_order_serial_no` AS `supermarket_order_serial_no`, `mask_post_addr` AS `mask_post_addr`, `order_status` AS `order_status`, `biz` AS `biz`, `only_platform_cost_amount` AS `only_platform_cost_amount`, `recommend_end_ship_time` AS `recommend_end_ship_time`, `order_amount` AS `order_amount`, `author_cost_amount` AS `author_cost_amount`, `user_coordinate` AS `user_coordinate`, `order_type` AS `order_type`, `app_id` AS `app_id`, `modify_post_amount` AS `modify_post_amount`, `promise_detail` AS `promise_detail`, `d_car_shop_biz_data` AS `d_car_shop_biz_data`, `create_time` AS `create_time`, `open_address_id` AS `open_address_id`, `order_expire_time` AS `order_expire_time`, `shop_name` AS `shop_name`, `promotion_amount` AS `promotion_amount`, `promotion_shop_amount` AS `promotion_shop_amount`, `buyer_words` AS `buyer_words`, `post_promotion_amount` AS `post_promotion_amount`, `finish_time` AS `finish_time`, `pay_time` AS `pay_time`, `user_id_info` AS `user_id_info`, `shop_id` AS `shop_id`, `appointment_ship_time` AS `appointment_ship_time`, `exp_ship_time` AS `exp_ship_time`, `total_promotion_amount` AS `total_promotion_amount`, `post_insurance_amount` AS `post_insurance_amount`, `address_tag_ui` AS `address_tag_ui`, `channel_payment_no` AS `channel_payment_no`, `order_status_desc` AS `order_status_desc`, `order_id` AS `order_id`, `serial_number_list` AS `serial_number_list`, `latest_receipt_time` AS `latest_receipt_time`, `order_operate_record_list` AS `order_operate_record_list`, `sub_b_type` AS `sub_b_type`, `order_phase_list` AS `order_phase_list`, `ship_time` AS `ship_time`, `promise_info` AS `promise_info`, `user_nick_name` AS `user_nick_name`, `shop_period_purchase_info` AS `shop_period_purchase_info`, `recommend_start_ship_time` AS `recommend_start_ship_time`, `post_origin_amount` AS `post_origin_amount`, `promotion_redpack_talent_amount` AS `promotion_redpack_talent_amount`, `update_time` AS `update_time`, `seller_remark_stars` AS `seller_remark_stars`, `earliest_receipt_time` AS `earliest_receipt_time`, `promotion_platform_amount` AS `promotion_platform_amount`, `sku_order_list` AS `sku_order_list`, `doudian_open_id` AS `doudian_open_id`, `user_icon` AS `user_icon`, `pay_type` AS `pay_type`, `promotion_talent_amount` AS `promotion_talent_amount`, `b_type` AS `b_type`, `platform_cost_amount` AS `platform_cost_amount`, `promotion_redpack_platform_amount` AS `promotion_redpack_platform_amount`, `encrypt_post_tel` AS `encrypt_post_tel`, `consolidate_info` AS `consolidate_info`, `modify_amount` AS `modify_amount`, `b_type_desc` AS `b_type_desc`, `promotion_detail` AS `promotion_detail`, `early_arrival` AS `early_arrival`, `sub_b_type_desc` AS `sub_b_type_desc`, `order_level` AS `order_level`, `pay_amount` AS `pay_amount`, `tax_amount_not_come_out` AS `tax_amount_not_come_out`, `post_addr` AS `post_addr`, `logistics_info` AS `logistics_info`, `main_status_desc` AS `main_status_desc`, `target_arrival_time` AS `target_arrival_time`, `cancel_reason` AS `cancel_reason`, `aweme_id` AS `aweme_id`, `order_type_desc` AS `order_type_desc`, `encrypt_post_receiver` AS `encrypt_post_receiver`, `seller_words` AS `seller_words`, `trade_type_desc` AS `trade_type_desc`, `receipt_date` AS `receipt_date`, `trade_type` AS `trade_type`, `promotion_redpack_amount` AS `promotion_redpack_amount`, `promotion_pay_amount` AS `promotion_pay_amount`, `main_status` AS `main_status`, `mask_post_tel` AS `mask_post_tel`, `user_tag_ui` AS `user_tag_ui`, `origin_data` AS `origin_data`, `yuce_cube_shop_id` AS `yuce_cube_shop_id`, `yuce_tenant_id` AS `yuce_tenant_id`, `yuce_task_instance_id` AS `yuce_task_instance_id`, `yuce_data_create_time` AS `yuce_data_create_time`, `$f102`, `$f103`, `$f104` FROM (SELECT `tax_amount`, `post_amount`, `open_id`, `order_tag`, `biz_desc`, `mask_post_receiver`, `shop_order_tag_ui`, `shop_cost_amount`, `supermarket_order_serial_no`, `mask_post_addr`, `order_status`, `biz`, `only_platform_cost_amount`, `recommend_end_ship_time`, `order_amount`, `author_cost_amount`, `user_coordinate`, `order_type`, `app_id`, `modify_post_amount`, `promise_detail`, `d_car_shop_biz_data`, `create_time`, `open_address_id`, `order_expire_time`, `shop_name`, `promotion_amount`, `promotion_shop_amount`, `buyer_words`, `post_promotion_amount`, `finish_time`, `pay_time`, `user_id_info`, `shop_id`, `appointment_ship_time`, `exp_ship_time`, `total_promotion_amount`, `post_insurance_amount`, `address_tag_ui`, `channel_payment_no`, `order_status_desc`, `order_id`, `serial_number_list`, `latest_receipt_time`, `order_operate_record_list`, `sub_b_type`, `order_phase_list`, `ship_time`, `promise_info`, `user_nick_name`, `shop_period_purchase_info`, `recommend_start_ship_time`, `post_origin_amount`, `promotion_redpack_talent_amount`, `update_time`, `seller_remark_stars`, `earliest_receipt_time`, `promotion_platform_amount`, `sku_order_list`, `doudian_open_id`, `user_icon`, `pay_type`, `promotion_talent_amount`, `b_type`, `platform_cost_amount`, `promotion_redpack_platform_amount`, `encrypt_post_tel`, `consolidate_info`, `modify_amount`, `b_type_desc`, `promotion_detail`, `early_arrival`, `sub_b_type_desc`, `order_level`, `pay_amount`, `tax_amount_not_come_out`, `post_addr`, `logistics_info`, `main_status_desc`, `target_arrival_time`, `cancel_reason`, `aweme_id`, `order_type_desc`, `encrypt_post_receiver`, `seller_words`, `trade_type_desc`, `receipt_date`, `trade_type`, `promotion_redpack_amount`, `promotion_pay_amount`, `main_status`, `mask_post_tel`, `user_tag_ui`, `origin_data`, `yuce_cube_shop_id`, `yuce_tenant_id`, `yuce_task_instance_id`, `yuce_data_create_time`, CASE WHEN `order_id` IS NOT NULL THEN `order_id` ELSE 'yuce@#$123456qwer' END AS `$f102`, CASE WHEN `yuce_cube_shop_id` IS NOT NULL THEN `yuce_cube_shop_id` ELSE 'yuce@#$123456qwer' END AS `$f103`, CASE WHEN `yuce_tenant_id` IS NOT NULL THEN `yuce_tenant_id` ELSE 'yuce@#$123456qwer' END AS `$f104` FROM (SELECT `tax_amount`, `post_amount`, `open_id`, `order_tag`, `biz_desc`, `mask_post_receiver`, `shop_order_tag_ui`, `shop_cost_amount`, `supermarket_order_serial_no`, `mask_post_addr`, `order_status`, `biz`, `only_platform_cost_amount`, `recommend_end_ship_time`, `order_amount`, `author_cost_amount`, `user_coordinate`, `order_type`, `app_id`, `modify_post_amount`, `promise_detail`, `d_car_shop_biz_data`, `create_time`, `open_address_id`, `order_expire_time`, `shop_name`, `promotion_amount`, `promotion_shop_amount`, `buyer_words`, `post_promotion_amount`, `finish_time`, `pay_time`, `user_id_info`, `shop_id`, `appointment_ship_time`, `exp_ship_time`, `total_promotion_amount`, `post_insurance_amount`, `address_tag_ui`, `channel_payment_no`, `order_status_desc`, `order_id`, `serial_number_list`, `latest_receipt_time`, `order_operate_record_list`, `sub_b_type`, `order_phase_list`, `ship_time`, `promise_info`, `user_nick_name`, `shop_period_purchase_info`, `recommend_start_ship_time`, `post_origin_amount`, `promotion_redpack_talent_amount`, `update_time`, `seller_remark_stars`, `earliest_receipt_time`, `promotion_platform_amount`, `sku_order_list`, `doudian_open_id`, `user_icon`, `pay_type`, `promotion_talent_amount`, `b_type`, `platform_cost_amount`, `promotion_redpack_platform_amount`, `encrypt_post_tel`, `consolidate_info`, `modify_amount`, `b_type_desc`, `promotion_detail`, `early_arrival`, `sub_b_type_desc`, `order_level`, `pay_amount`, `tax_amount_not_come_out`, `post_addr`, `logistics_info`, `main_status_desc`, `target_arrival_time`, `cancel_reason`, `aweme_id`, `order_type_desc`, `encrypt_post_receiver`, `seller_words`, `trade_type_desc`, `receipt_date`, `trade_type`, `promotion_redpack_amount`, `promotion_pay_amount`, `main_status`, `mask_post_tel`, `user_tag_ui`, `origin_data`, `yuce_cube_shop_id`, `yuce_tenant_id`, `yuce_task_instance_id`, `yuce_data_create_time`, `$101`, ROW_NUMBER() OVER (PARTITION BY `order_id`, `yuce_cube_shop_id`, `yuce_tenant_id` ORDER BY `$101` IS NULL DESC, `$101` DESC) AS `w0$o0` FROM (SELECT `tax_amount` AS `tax_amount`, `post_amount` AS `post_amount`, `open_id` AS `open_id`, `order_tag` AS `order_tag`, `biz_desc` AS `biz_desc`, `mask_post_receiver` AS `mask_post_receiver`, `shop_order_tag_ui` AS `shop_order_tag_ui`, `shop_cost_amount` AS `shop_cost_amount`, `supermarket_order_serial_no` AS `supermarket_order_serial_no`, `mask_post_addr` AS `mask_post_addr`, `order_status` AS `order_status`, `biz` AS `biz`, `only_platform_cost_amount` AS `only_platform_cost_amount`, `recommend_end_ship_time` AS `recommend_end_ship_time`, `order_amount` AS `order_amount`, `author_cost_amount` AS `author_cost_amount`, `user_coordinate` AS `user_coordinate`, `order_type` AS `order_type`, `app_id` AS `app_id`, `modify_post_amount` AS `modify_post_amount`, `promise_detail` AS `promise_detail`, `d_car_shop_biz_data` AS `d_car_shop_biz_data`, `create_time` AS `create_time`, `open_address_id` AS `open_address_id`, `order_expire_time` AS `order_expire_time`, `shop_name` AS `shop_name`, `promotion_amount` AS `promotion_amount`, `promotion_shop_amount` AS `promotion_shop_amount`, `buyer_words` AS `buyer_words`, `post_promotion_amount` AS `post_promotion_amount`, `finish_time` AS `finish_time`, `pay_time` AS `pay_time`, `user_id_info` AS `user_id_info`, `shop_id` AS `shop_id`, `appointment_ship_time` AS `appointment_ship_time`, `exp_ship_time` AS `exp_ship_time`, `total_promotion_amount` AS `total_promotion_amount`, `post_insurance_amount` AS `post_insurance_amount`, `address_tag_ui` AS `address_tag_ui`, `channel_payment_no` AS `channel_payment_no`, `order_status_desc` AS `order_status_desc`, `order_id` AS `order_id`, `serial_number_list` AS `serial_number_list`, `latest_receipt_time` AS `latest_receipt_time`, `order_operate_record_list` AS `order_operate_record_list`, `sub_b_type` AS `sub_b_type`, `order_phase_list` AS `order_phase_list`, `ship_time` AS `ship_time`, `promise_info` AS `promise_info`, `user_nick_name` AS `user_nick_name`, `shop_period_purchase_info` AS `shop_period_purchase_info`, `recommend_start_ship_time` AS `recommend_start_ship_time`, `post_origin_amount` AS `post_origin_amount`, `promotion_redpack_talent_amount` AS `promotion_redpack_talent_amount`, `update_time` AS `update_time`, `seller_remark_stars` AS `seller_remark_stars`, `earliest_receipt_time` AS `earliest_receipt_time`, `promotion_platform_amount` AS `promotion_platform_amount`, `sku_order_list` AS `sku_order_list`, `doudian_open_id` AS `doudian_open_id`, `user_icon` AS `user_icon`, `pay_type` AS `pay_type`, `promotion_talent_amount` AS `promotion_talent_amount`, `b_type` AS `b_type`, `platform_cost_amount` AS `platform_cost_amount`, `promotion_redpack_platform_amount` AS `promotion_redpack_platform_amount`, `encrypt_post_tel` AS `encrypt_post_tel`, `consolidate_info` AS `consolidate_info`, `modify_amount` AS `modify_amount`, `b_type_desc` AS `b_type_desc`, `promotion_detail` AS `promotion_detail`, `early_arrival` AS `early_arrival`, `sub_b_type_desc` AS `sub_b_type_desc`, `order_level` AS `order_level`, `pay_amount` AS `pay_amount`, `tax_amount_not_come_out` AS `tax_amount_not_come_out`, `post_addr` AS `post_addr`, `logistics_info` AS `logistics_info`, `main_status_desc` AS `main_status_desc`, `target_arrival_time` AS `target_arrival_time`, `cancel_reason` AS `cancel_reason`, `aweme_id` AS `aweme_id`, `order_type_desc` AS `order_type_desc`, `encrypt_post_receiver` AS `encrypt_post_receiver`, `seller_words` AS `seller_words`, `trade_type_desc` AS `trade_type_desc`, `receipt_date` AS `receipt_date`, `trade_type` AS `trade_type`, `promotion_redpack_amount` AS `promotion_redpack_amount`, `promotion_pay_amount` AS `promotion_pay_amount`, `main_status` AS `main_status`, `mask_post_tel` AS `mask_post_tel`, `user_tag_ui` AS `user_tag_ui`, `origin_data` AS `origin_data`, `yuce_cube_shop_id` AS `yuce_cube_shop_id`, `yuce_tenant_id` AS `yuce_tenant_id`, `yuce_task_instance_id` AS `yuce_task_instance_id`, `yuce_data_create_time` AS `yuce_data_create_time`, `$101` FROM (SELECT `ods_db_dd_sale_order_list_info_du`.`tax_amount`, `ods_db_dd_sale_order_list_info_du`.`post_amount`, `ods_db_dd_sale_order_list_info_du`.`open_id`, `ods_db_dd_sale_order_list_info_du`.`order_tag`, `ods_db_dd_sale_order_list_info_du`.`biz_desc`, `ods_db_dd_sale_order_list_info_du`.`mask_post_receiver`, `ods_db_dd_sale_order_list_info_du`.`shop_order_tag_ui`, `ods_db_dd_sale_order_list_info_du`.`shop_cost_amount`, `ods_db_dd_sale_order_list_info_du`.`supermarket_order_serial_no`, `ods_db_dd_sale_order_list_info_du`.`mask_post_addr`, `ods_db_dd_sale_order_list_info_du`.`order_status`, `ods_db_dd_sale_order_list_info_du`.`biz`, `ods_db_dd_sale_order_list_info_du`.`only_platform_cost_amount`, `ods_db_dd_sale_order_list_info_du`.`recommend_end_ship_time`, `ods_db_dd_sale_order_list_info_du`.`order_amount`, `ods_db_dd_sale_order_list_info_du`.`author_cost_amount`, `ods_db_dd_sale_order_list_info_du`.`user_coordinate`, `ods_db_dd_sale_order_list_info_du`.`order_type`, `ods_db_dd_sale_order_list_info_du`.`app_id`, `ods_db_dd_sale_order_list_info_du`.`modify_post_amount`, `ods_db_dd_sale_order_list_info_du`.`promise_detail`, `ods_db_dd_sale_order_list_info_du`.`d_car_shop_biz_data`, `ods_db_dd_sale_order_list_info_du`.`create_time`, `ods_db_dd_sale_order_list_info_du`.`open_address_id`, `ods_db_dd_sale_order_list_info_du`.`order_expire_time`, `ods_db_dd_sale_order_list_info_du`.`shop_name`, `ods_db_dd_sale_order_list_info_du`.`promotion_amount`, `ods_db_dd_sale_order_list_info_du`.`promotion_shop_amount`, `ods_db_dd_sale_order_list_info_du`.`buyer_words`, `ods_db_dd_sale_order_list_info_du`.`post_promotion_amount`, `ods_db_dd_sale_order_list_info_du`.`finish_time`, `ods_db_dd_sale_order_list_info_du`.`pay_time`, `ods_db_dd_sale_order_list_info_du`.`user_id_info`, `ods_db_dd_sale_order_list_info_du`.`shop_id`, `ods_db_dd_sale_order_list_info_du`.`appointment_ship_time`, `ods_db_dd_sale_order_list_info_du`.`exp_ship_time`, `ods_db_dd_sale_order_list_info_du`.`total_promotion_amount`, `ods_db_dd_sale_order_list_info_du`.`post_insurance_amount`, `ods_db_dd_sale_order_list_info_du`.`address_tag_ui`, `ods_db_dd_sale_order_list_info_du`.`channel_payment_no`, `ods_db_dd_sale_order_list_info_du`.`order_status_desc`, `ods_db_dd_sale_order_list_info_du`.`order_id`, `ods_db_dd_sale_order_list_info_du`.`serial_number_list`, `ods_db_dd_sale_order_list_info_du`.`latest_receipt_time`, `ods_db_dd_sale_order_list_info_du`.`order_operate_record_list`, `ods_db_dd_sale_order_list_info_du`.`sub_b_type`, `ods_db_dd_sale_order_list_info_du`.`order_phase_list`, `ods_db_dd_sale_order_list_info_du`.`ship_time`, `ods_db_dd_sale_order_list_info_du`.`promise_info`, `ods_db_dd_sale_order_list_info_du`.`user_nick_name`, `ods_db_dd_sale_order_list_info_du`.`shop_period_purchase_info`, `ods_db_dd_sale_order_list_info_du`.`recommend_start_ship_time`, `ods_db_dd_sale_order_list_info_du`.`post_origin_amount`, `ods_db_dd_sale_order_list_info_du`.`promotion_redpack_talent_amount`, `ods_db_dd_sale_order_list_info_du`.`update_time`, `ods_db_dd_sale_order_list_info_du`.`seller_remark_stars`, `ods_db_dd_sale_order_list_info_du`.`earliest_receipt_time`, `ods_db_dd_sale_order_list_info_du`.`promotion_platform_amount`, `ods_db_dd_sale_order_list_info_du`.`sku_order_list`, `ods_db_dd_sale_order_list_info_du`.`doudian_open_id`, `ods_db_dd_sale_order_list_info_du`.`user_icon`, `ods_db_dd_sale_order_list_info_du`.`pay_type`, `ods_db_dd_sale_order_list_info_du`.`promotion_talent_amount`, `ods_db_dd_sale_order_list_info_du`.`b_type`, `ods_db_dd_sale_order_list_info_du`.`platform_cost_amount`, `ods_db_dd_sale_order_list_info_du`.`promotion_redpack_platform_amount`, `ods_db_dd_sale_order_list_info_du`.`encrypt_post_tel`, `ods_db_dd_sale_order_list_info_du`.`consolidate_info`, `ods_db_dd_sale_order_list_info_du`.`modify_amount`, `ods_db_dd_sale_order_list_info_du`.`b_type_desc`, `ods_db_dd_sale_order_list_info_du`.`promotion_detail`, `ods_db_dd_sale_order_list_info_du`.`early_arrival`, `ods_db_dd_sale_order_list_info_du`.`sub_b_type_desc`, `ods_db_dd_sale_order_list_info_du`.`order_level`, `ods_db_dd_sale_order_list_info_du`.`pay_amount`, `ods_db_dd_sale_order_list_info_du`.`tax_amount_not_come_out`, `ods_db_dd_sale_order_list_info_du`.`post_addr`, `ods_db_dd_sale_order_list_info_du`.`logistics_info`, `ods_db_dd_sale_order_list_info_du`.`main_status_desc`, `ods_db_dd_sale_order_list_info_du`.`target_arrival_time`, `ods_db_dd_sale_order_list_info_du`.`cancel_reason`, `ods_db_dd_sale_order_list_info_du`.`aweme_id`, `ods_db_dd_sale_order_list_info_du`.`order_type_desc`, `ods_db_dd_sale_order_list_info_du`.`encrypt_post_receiver`, `ods_db_dd_sale_order_list_info_du`.`seller_words`, `ods_db_dd_sale_order_list_info_du`.`trade_type_desc`, `ods_db_dd_sale_order_list_info_du`.`receipt_date`, `ods_db_dd_sale_order_list_info_du`.`trade_type`, `ods_db_dd_sale_order_list_info_du`.`promotion_redpack_amount`, `ods_db_dd_sale_order_list_info_du`.`promotion_pay_amount`, `ods_db_dd_sale_order_list_info_du`.`main_status`, `ods_db_dd_sale_order_list_info_du`.`mask_post_tel`, `ods_db_dd_sale_order_list_info_du`.`user_tag_ui`, `ods_db_dd_sale_order_list_info_du`.`origin_data`, `ods_db_dd_sale_order_list_info_du`.`yuce_cube_shop_id`, `ods_db_dd_sale_order_list_info_du`.`yuce_tenant_id`, `ods_db_dd_sale_order_list_info_du`.`yuce_task_instance_id`, `ods_db_dd_sale_order_list_info_du`.`yuce_data_create_time`, CASE WHEN CAST(`ods_db_dd_sale_order_list_info_du`.`update_time` AS DECIMAL(38, 8)) > 99999999999 THEN CAST(FROM_UNIXTIME(CAST(`ods_db_dd_sale_order_list_info_du`.`update_time` AS DECIMAL(38, 8)) / 1000) AS DATETIME) WHEN CAST(`ods_db_dd_sale_order_list_info_du`.`update_time` AS DECIMAL(38, 8)) < 30000000 THEN str_to_date(CAST(`ods_db_dd_sale_order_list_info_du`.`update_time` AS DECIMAL(38, 8)), '%Y%m%d') ELSE CAST(FROM_UNIXTIME(CAST(`ods_db_dd_sale_order_list_info_du`.`update_time` AS DECIMAL(38, 8))) AS DATETIME) END AS `$101` FROM `lake`.`saas_datalake`.`ods_db_dd_sale_order_list_info_du` WHERE SUBSTRING(`ods_db_dd_sale_order_list_info_du`.`dt`, 1, 10) >= '2025-09-25' AND SUBSTRING(`ods_db_dd_sale_order_list_info_du`.`dt`, 1, 10) <= '2025-09-26' AND `ods_db_dd_sale_order_list_info_du`.`yuce_tenant_id` = 'hzktppglyxgs_283476') AS `ods_db_dd_sale_order_list_info_du`) AS `ods_db_dd_sale_order_list_info_du`) AS `ods_db_dd_sale_order_list_info_du` WHERE `w0$o0` = 1) AS `ods_db_dd_sale_order_list_info_du`) AS `ods_db_dd_sale_order_list_info_du` FULL JOIN (SELECT `tax_amount` AS `tax_amount`, `post_amount` AS `post_amount`, `open_id` AS `open_id`, `order_tag` AS `order_tag`, `biz_desc` AS `biz_desc`, `mask_post_receiver` AS `mask_post_receiver`, `shop_order_tag_ui` AS `shop_order_tag_ui`, `shop_cost_amount` AS `shop_cost_amount`, `supermarket_order_serial_no` AS `supermarket_order_serial_no`, `mask_post_addr` AS `mask_post_addr`, `order_status` AS `order_status`, `biz` AS `biz`, `recommend_end_ship_time` AS `recommend_end_ship_time`, `only_platform_cost_amount` AS `only_platform_cost_amount`, `order_amount` AS `order_amount`, `author_cost_amount` AS `author_cost_amount`, `user_coordinate` AS `user_coordinate`, `order_type` AS `order_type`, `app_id` AS `app_id`, `modify_post_amount` AS `modify_post_amount`, `promise_detail` AS `promise_detail`, `d_car_shop_biz_data` AS `d_car_shop_biz_data`, `open_address_id` AS `open_address_id`, `create_time` AS `create_time`, `order_expire_time` AS `order_expire_time`, `shop_name` AS `shop_name`, `buyer_words` AS `buyer_words`, `promotion_amount` AS `promotion_amount`, `post_promotion_amount` AS `post_promotion_amount`, `promotion_shop_amount` AS `promotion_shop_amount`, `finish_time` AS `finish_time`, `pay_time` AS `pay_time`, `user_id_info` AS `user_id_info`, `shop_id` AS `shop_id`, `appointment_ship_time` AS `appointment_ship_time`, `total_promotion_amount` AS `total_promotion_amount`, `post_insurance_amount` AS `post_insurance_amount`, `exp_ship_time` AS `exp_ship_time`, `address_tag_ui` AS `address_tag_ui`, `channel_payment_no` AS `channel_payment_no`, `order_status_desc` AS `order_status_desc`, `latest_receipt_time` AS `latest_receipt_time`, `order_id` AS `order_id`, `serial_number_list` AS `serial_number_list`, `order_operate_record_list` AS `order_operate_record_list`, `order_phase_list` AS `order_phase_list`, `sub_b_type` AS `sub_b_type`, `ship_time` AS `ship_time`, `promise_info` AS `promise_info`, `user_nick_name` AS `user_nick_name`, `shop_period_purchase_info` AS `shop_period_purchase_info`, `post_origin_amount` AS `post_origin_amount`, `recommend_start_ship_time` AS `recommend_start_ship_time`, `promotion_redpack_talent_amount` AS `promotion_redpack_talent_amount`, `update_time` AS `update_time`, `seller_remark_stars` AS `seller_remark_stars`, `earliest_receipt_time` AS `earliest_receipt_time`, `promotion_platform_amount` AS `promotion_platform_amount`, `sku_order_list` AS `sku_order_list`, `doudian_open_id` AS `doudian_open_id`, `user_icon` AS `user_icon`, `pay_type` AS `pay_type`, `promotion_talent_amount` AS `promotion_talent_amount`, `b_type` AS `b_type`, `platform_cost_amount` AS `platform_cost_amount`, `promotion_redpack_platform_amount` AS `promotion_redpack_platform_amount`, `encrypt_post_tel` AS `encrypt_post_tel`, `modify_amount` AS `modify_amount`, `consolidate_info` AS `consolidate_info`, `b_type_desc` AS `b_type_desc`, `promotion_detail` AS `promotion_detail`, `early_arrival` AS `early_arrival`, `sub_b_type_desc` AS `sub_b_type_desc`, `pay_amount` AS `pay_amount`, `order_level` AS `order_level`, `tax_amount_not_come_out` AS `tax_amount_not_come_out`, `post_addr` AS `post_addr`, `logistics_info` AS `logistics_info`, `main_status_desc` AS `main_status_desc`, `target_arrival_time` AS `target_arrival_time`, `cancel_reason` AS `cancel_reason`, `aweme_id` AS `aweme_id`, `order_type_desc` AS `order_type_desc`, `encrypt_post_receiver` AS `encrypt_post_receiver`, `seller_words` AS `seller_words`, `receipt_date` AS `receipt_date`, `trade_type_desc` AS `trade_type_desc`, `trade_type` AS `trade_type`, `promotion_redpack_amount` AS `promotion_redpack_amount`, `promotion_pay_amount` AS `promotion_pay_amount`, `main_status` AS `main_status`, `mask_post_tel` AS `mask_post_tel`, `user_tag_ui` AS `user_tag_ui`, `dt` AS `dt`, `origin_data` AS `origin_data`, `yuce_cube_shop_id` AS `yuce_cube_shop_id`, `yuce_task_instance_id` AS `yuce_task_instance_id`, `yuce_data_create_time` AS `yuce_data_create_time`, `yuce_tenant_id` AS `yuce_tenant_id`, `$f101`, `$f102`, `$f103` FROM (SELECT `ods_db_dd_sale_order_list_info_f`.`tax_amount`, `ods_db_dd_sale_order_list_info_f`.`post_amount`, `ods_db_dd_sale_order_list_info_f`.`open_id`, `ods_db_dd_sale_order_list_info_f`.`order_tag`, `ods_db_dd_sale_order_list_info_f`.`biz_desc`, `ods_db_dd_sale_order_list_info_f`.`mask_post_receiver`, `ods_db_dd_sale_order_list_info_f`.`shop_order_tag_ui`, `ods_db_dd_sale_order_list_info_f`.`shop_cost_amount`, `ods_db_dd_sale_order_list_info_f`.`supermarket_order_serial_no`, `ods_db_dd_sale_order_list_info_f`.`mask_post_addr`, `ods_db_dd_sale_order_list_info_f`.`order_status`, `ods_db_dd_sale_order_list_info_f`.`biz`, `ods_db_dd_sale_order_list_info_f`.`recommend_end_ship_time`, `ods_db_dd_sale_order_list_info_f`.`only_platform_cost_amount`, `ods_db_dd_sale_order_list_info_f`.`order_amount`, `ods_db_dd_sale_order_list_info_f`.`author_cost_amount`, `ods_db_dd_sale_order_list_info_f`.`user_coordinate`, `ods_db_dd_sale_order_list_info_f`.`order_type`, `ods_db_dd_sale_order_list_info_f`.`app_id`, `ods_db_dd_sale_order_list_info_f`.`modify_post_amount`, `ods_db_dd_sale_order_list_info_f`.`promise_detail`, `ods_db_dd_sale_order_list_info_f`.`d_car_shop_biz_data`, `ods_db_dd_sale_order_list_info_f`.`open_address_id`, `ods_db_dd_sale_order_list_info_f`.`create_time`, `ods_db_dd_sale_order_list_info_f`.`order_expire_time`, `ods_db_dd_sale_order_list_info_f`.`shop_name`, `ods_db_dd_sale_order_list_info_f`.`buyer_words`, `ods_db_dd_sale_order_list_info_f`.`promotion_amount`, `ods_db_dd_sale_order_list_info_f`.`post_promotion_amount`, `ods_db_dd_sale_order_list_info_f`.`promotion_shop_amount`, `ods_db_dd_sale_order_list_info_f`.`finish_time`, `ods_db_dd_sale_order_list_info_f`.`pay_time`, `ods_db_dd_sale_order_list_info_f`.`user_id_info`, `ods_db_dd_sale_order_list_info_f`.`shop_id`, `ods_db_dd_sale_order_list_info_f`.`appointment_ship_time`, `ods_db_dd_sale_order_list_info_f`.`total_promotion_amount`, `ods_db_dd_sale_order_list_info_f`.`post_insurance_amount`, `ods_db_dd_sale_order_list_info_f`.`exp_ship_time`, `ods_db_dd_sale_order_list_info_f`.`address_tag_ui`, `ods_db_dd_sale_order_list_info_f`.`channel_payment_no`, `ods_db_dd_sale_order_list_info_f`.`order_status_desc`, `ods_db_dd_sale_order_list_info_f`.`latest_receipt_time`, `ods_db_dd_sale_order_list_info_f`.`order_id`, `ods_db_dd_sale_order_list_info_f`.`serial_number_list`, `ods_db_dd_sale_order_list_info_f`.`order_operate_record_list`, `ods_db_dd_sale_order_list_info_f`.`order_phase_list`, `ods_db_dd_sale_order_list_info_f`.`sub_b_type`, `ods_db_dd_sale_order_list_info_f`.`ship_time`, `ods_db_dd_sale_order_list_info_f`.`promise_info`, `ods_db_dd_sale_order_list_info_f`.`user_nick_name`, `ods_db_dd_sale_order_list_info_f`.`shop_period_purchase_info`, `ods_db_dd_sale_order_list_info_f`.`post_origin_amount`, `ods_db_dd_sale_order_list_info_f`.`recommend_start_ship_time`, `ods_db_dd_sale_order_list_info_f`.`promotion_redpack_talent_amount`, `ods_db_dd_sale_order_list_info_f`.`update_time`, `ods_db_dd_sale_order_list_info_f`.`seller_remark_stars`, `ods_db_dd_sale_order_list_info_f`.`earliest_receipt_time`, `ods_db_dd_sale_order_list_info_f`.`promotion_platform_amount`, `ods_db_dd_sale_order_list_info_f`.`sku_order_list`, `ods_db_dd_sale_order_list_info_f`.`doudian_open_id`, `ods_db_dd_sale_order_list_info_f`.`user_icon`, `ods_db_dd_sale_order_list_info_f`.`pay_type`, `ods_db_dd_sale_order_list_info_f`.`promotion_talent_amount`, `ods_db_dd_sale_order_list_info_f`.`b_type`, `ods_db_dd_sale_order_list_info_f`.`platform_cost_amount`, `ods_db_dd_sale_order_list_info_f`.`promotion_redpack_platform_amount`, `ods_db_dd_sale_order_list_info_f`.`encrypt_post_tel`, `ods_db_dd_sale_order_list_info_f`.`modify_amount`, `ods_db_dd_sale_order_list_info_f`.`consolidate_info`, `ods_db_dd_sale_order_list_info_f`.`b_type_desc`, `ods_db_dd_sale_order_list_info_f`.`promotion_detail`, `ods_db_dd_sale_order_list_info_f`.`early_arrival`, `ods_db_dd_sale_order_list_info_f`.`sub_b_type_desc`, `ods_db_dd_sale_order_list_info_f`.`pay_amount`, `ods_db_dd_sale_order_list_info_f`.`order_level`, `ods_db_dd_sale_order_list_info_f`.`tax_amount_not_come_out`, `ods_db_dd_sale_order_list_info_f`.`post_addr`, `ods_db_dd_sale_order_list_info_f`.`logistics_info`, `ods_db_dd_sale_order_list_info_f`.`main_status_desc`, `ods_db_dd_sale_order_list_info_f`.`target_arrival_time`, `ods_db_dd_sale_order_list_info_f`.`cancel_reason`, `ods_db_dd_sale_order_list_info_f`.`aweme_id`, `ods_db_dd_sale_order_list_info_f`.`order_type_desc`, `ods_db_dd_sale_order_list_info_f`.`encrypt_post_receiver`, `ods_db_dd_sale_order_list_info_f`.`seller_words`, `ods_db_dd_sale_order_list_info_f`.`receipt_date`, `ods_db_dd_sale_order_list_info_f`.`trade_type_desc`, `ods_db_dd_sale_order_list_info_f`.`trade_type`, `ods_db_dd_sale_order_list_info_f`.`promotion_redpack_amount`, `ods_db_dd_sale_order_list_info_f`.`promotion_pay_amount`, `ods_db_dd_sale_order_list_info_f`.`main_status`, `ods_db_dd_sale_order_list_info_f`.`mask_post_tel`, `ods_db_dd_sale_order_list_info_f`.`user_tag_ui`, `ods_db_dd_sale_order_list_info_f`.`dt`, `ods_db_dd_sale_order_list_info_f`.`origin_data`, `ods_db_dd_sale_order_list_info_f`.`yuce_cube_shop_id`, `ods_db_dd_sale_order_list_info_f`.`yuce_task_instance_id`, `ods_db_dd_sale_order_list_info_f`.`yuce_data_create_time`, `ods_db_dd_sale_order_list_info_f`.`yuce_tenant_id`, CASE WHEN `ods_db_dd_sale_order_list_info_f`.`order_id` IS NOT NULL THEN `ods_db_dd_sale_order_list_info_f`.`order_id` ELSE 'yuce@#$123456qwer' END AS `$f101`, CASE WHEN `ods_db_dd_sale_order_list_info_f`.`yuce_cube_shop_id` IS NOT NULL THEN `ods_db_dd_sale_order_list_info_f`.`yuce_cube_shop_id` ELSE 'yuce@#$123456qwer' END AS `$f102`, CASE WHEN `ods_db_dd_sale_order_list_info_f`.`yuce_tenant_id` IS NOT NULL THEN `ods_db_dd_sale_order_list_info_f`.`yuce_tenant_id` ELSE 'yuce@#$123456qwer' END AS `$f103` FROM ((SELECT `ods_db_dd_sale_order_list_info_f`.`tax_amount`, `ods_db_dd_sale_order_list_info_f`.`post_amount`, `ods_db_dd_sale_order_list_info_f`.`open_id`, `ods_db_dd_sale_order_list_info_f`.`order_tag`, `ods_db_dd_sale_order_list_info_f`.`biz_desc`, `ods_db_dd_sale_order_list_info_f`.`mask_post_receiver`, `ods_db_dd_sale_order_list_info_f`.`shop_order_tag_ui`, `ods_db_dd_sale_order_list_info_f`.`shop_cost_amount`, `ods_db_dd_sale_order_list_info_f`.`supermarket_order_serial_no`, `ods_db_dd_sale_order_list_info_f`.`mask_post_addr`, `ods_db_dd_sale_order_list_info_f`.`order_status`, `ods_db_dd_sale_order_list_info_f`.`biz`, `ods_db_dd_sale_order_list_info_f`.`recommend_end_ship_time`, `ods_db_dd_sale_order_list_info_f`.`only_platform_cost_amount`, `ods_db_dd_sale_order_list_info_f`.`order_amount`, `ods_db_dd_sale_order_list_info_f`.`author_cost_amount`, `ods_db_dd_sale_order_list_info_f`.`user_coordinate`, `ods_db_dd_sale_order_list_info_f`.`order_type`, `ods_db_dd_sale_order_list_info_f`.`app_id`, `ods_db_dd_sale_order_list_info_f`.`modify_post_amount`, `ods_db_dd_sale_order_list_info_f`.`promise_detail`, `ods_db_dd_sale_order_list_info_f`.`d_car_shop_biz_data`, `ods_db_dd_sale_order_list_info_f`.`open_address_id`, `ods_db_dd_sale_order_list_info_f`.`create_time`, `ods_db_dd_sale_order_list_info_f`.`order_expire_time`, `ods_db_dd_sale_order_list_info_f`.`shop_name`, `ods_db_dd_sale_order_list_info_f`.`buyer_words`, `ods_db_dd_sale_order_list_info_f`.`promotion_amount`, `ods_db_dd_sale_order_list_info_f`.`post_promotion_amount`, `ods_db_dd_sale_order_list_info_f`.`promotion_shop_amount`, `ods_db_dd_sale_order_list_info_f`.`finish_time`, `ods_db_dd_sale_order_list_info_f`.`pay_time`, `ods_db_dd_sale_order_list_info_f`.`user_id_info`, `ods_db_dd_sale_order_list_info_f`.`shop_id`, `ods_db_dd_sale_order_list_info_f`.`appointment_ship_time`, `ods_db_dd_sale_order_list_info_f`.`total_promotion_amount`, `ods_db_dd_sale_order_list_info_f`.`post_insurance_amount`, `ods_db_dd_sale_order_list_info_f`.`exp_ship_time`, `ods_db_dd_sale_order_list_info_f`.`address_tag_ui`, `ods_db_dd_sale_order_list_info_f`.`channel_payment_no`, `ods_db_dd_sale_order_list_info_f`.`order_status_desc`, `ods_db_dd_sale_order_list_info_f`.`latest_receipt_time`, `ods_db_dd_sale_order_list_info_f`.`order_id`, `ods_db_dd_sale_order_list_info_f`.`serial_number_list`, `ods_db_dd_sale_order_list_info_f`.`order_operate_record_list`, `ods_db_dd_sale_order_list_info_f`.`order_phase_list`, `ods_db_dd_sale_order_list_info_f`.`sub_b_type`, `ods_db_dd_sale_order_list_info_f`.`ship_time`, `ods_db_dd_sale_order_list_info_f`.`promise_info`, `ods_db_dd_sale_order_list_info_f`.`user_nick_name`, `ods_db_dd_sale_order_list_info_f`.`shop_period_purchase_info`, `ods_db_dd_sale_order_list_info_f`.`post_origin_amount`, `ods_db_dd_sale_order_list_info_f`.`recommend_start_ship_time`, `ods_db_dd_sale_order_list_info_f`.`promotion_redpack_talent_amount`, `ods_db_dd_sale_order_list_info_f`.`update_time`, `ods_db_dd_sale_order_list_info_f`.`seller_remark_stars`, `ods_db_dd_sale_order_list_info_f`.`earliest_receipt_time`, `ods_db_dd_sale_order_list_info_f`.`promotion_platform_amount`, `ods_db_dd_sale_order_list_info_f`.`sku_order_list`, `ods_db_dd_sale_order_list_info_f`.`doudian_open_id`, `ods_db_dd_sale_order_list_info_f`.`user_icon`, `ods_db_dd_sale_order_list_info_f`.`pay_type`, `ods_db_dd_sale_order_list_info_f`.`promotion_talent_amount`, `ods_db_dd_sale_order_list_info_f`.`b_type`, `ods_db_dd_sale_order_list_info_f`.`platform_cost_amount`, `ods_db_dd_sale_order_list_info_f`.`promotion_redpack_platform_amount`, `ods_db_dd_sale_order_list_info_f`.`encrypt_post_tel`, `ods_db_dd_sale_order_list_info_f`.`modify_amount`, `ods_db_dd_sale_order_list_info_f`.`consolidate_info`, `ods_db_dd_sale_order_list_info_f`.`b_type_desc`, `ods_db_dd_sale_order_list_info_f`.`promotion_detail`, `ods_db_dd_sale_order_list_info_f`.`early_arrival`, `ods_db_dd_sale_order_list_info_f`.`sub_b_type_desc`, `ods_db_dd_sale_order_list_info_f`.`pay_amount`, `ods_db_dd_sale_order_list_info_f`.`order_level`, `ods_db_dd_sale_order_list_info_f`.`tax_amount_not_come_out`, `ods_db_dd_sale_order_list_info_f`.`post_addr`, `ods_db_dd_sale_order_list_info_f`.`logistics_info`, `ods_db_dd_sale_order_list_info_f`.`main_status_desc`, `ods_db_dd_sale_order_list_info_f`.`target_arrival_time`, `ods_db_dd_sale_order_list_info_f`.`cancel_reason`, `ods_db_dd_sale_order_list_info_f`.`aweme_id`, `ods_db_dd_sale_order_list_info_f`.`order_type_desc`, `ods_db_dd_sale_order_list_info_f`.`encrypt_post_receiver`, `ods_db_dd_sale_order_list_info_f`.`seller_words`, `ods_db_dd_sale_order_list_info_f`.`receipt_date`, `ods_db_dd_sale_order_list_info_f`.`trade_type_desc`, `ods_db_dd_sale_order_list_info_f`.`trade_type`, `ods_db_dd_sale_order_list_info_f`.`promotion_redpack_amount`, `ods_db_dd_sale_order_list_info_f`.`promotion_pay_amount`, `ods_db_dd_sale_order_list_info_f`.`main_status`, `ods_db_dd_sale_order_list_info_f`.`mask_post_tel`, `ods_db_dd_sale_order_list_info_f`.`user_tag_ui`, `ods_db_dd_sale_order_list_info_f`.`dt`, `ods_db_dd_sale_order_list_info_f`.`origin_data`, `ods_db_dd_sale_order_list_info_f`.`yuce_cube_shop_id`, `ods_db_dd_sale_order_list_info_f`.`yuce_task_instance_id`, `ods_db_dd_sale_order_list_info_f`.`yuce_data_create_time`, `ods_db_dd_sale_order_list_info_f`.`yuce_tenant_id` FROM `lake`.`saas_datalake`.`ods_db_dd_sale_order_list_info_f` WHERE `ods_db_dd_sale_order_list_info_f`.`yuce_tenant_id` = 'hzktppglyxgs_283476') AS `ods_db_dd_sale_order_list_info_f` INNER JOIN (SELECT `ods_db_dd_sale_order_list_info_du`.`yuce_tenant_id` FROM `lake`.`saas_datalake`.`ods_db_dd_sale_order_list_info_du` WHERE SUBSTRING(`ods_db_dd_sale_order_list_info_du`.`dt`, 1, 10) >= '2025-09-25' AND SUBSTRING(`ods_db_dd_sale_order_list_info_du`.`dt`, 1, 10) <= '2025-09-26' AND `ods_db_dd_sale_order_list_info_du`.`yuce_tenant_id` = 'hzktppglyxgs_283476' GROUP BY `ods_db_dd_sale_order_list_info_du`.`yuce_tenant_id`) AS `ods_db_dd_sale_order_list_info_du0` ON `ods_db_dd_sale_order_list_info_f`.`yuce_tenant_id` = `ods_db_dd_sale_order_list_info_du0`.`yuce_tenant_id`)) AS `t0`) AS `t1` ON ((`ods_db_dd_sale_order_list_info_du`.`$f102` = `t1`.`$f101` AND `ods_db_dd_sale_order_list_info_du`.`$f103` = `t1`.`$f102`) AND `ods_db_dd_sale_order_list_info_du`.`$f104` = `t1`.`$f103`))) AS `t3`)