select `id`,`customer_id`,`source_id`,`source_name`,`seller_id`,`marketplace_id`,`name`,`parent_asin`,`asin`,`msku`,`sku`,`quality`,`delivery_type`,`fnsku`,`image`,`status`,`currency`,`country`,`country_icon`,`listing_method`,`listing_person`,`salesman_id`,`salesman`,`business_user_name`,`business_user_id`,`department_id`,`department_name`,`publish_time`,`un_publish_time`,`first_order_time`,`first_arrival_time`,`remark`,`watermark_status`,`is_narf`,`is_pan_eu`,`is_efn`,`create_by`,`create_time`,`update_by`,`update_time`,`is_deleted`,`is_join_small`,`recommend_join_small`,`no_join_small_reason`,`parent_msku`,`product_type`,`order_source_sku_id`,`browse_path_by_id`,`browse_path_by_id_crc`,`source_status`,`listing_person_id`,`trans_to_fba_status`,`not_trans_to_fba_reason`,`not_trans_to_fba_remark`,`real_product_type`,`quality_update_time`,`status_update_time`,`storage_type`,`del_status`,`trans_to_fba_time`,`trans_to_fba_pending_time`,`delivery_type_update_time`,`pending_transshipment_quantity`,`fc_processing_quantity`,`buy_box_type`,`asin_crc`,`estimate_sale_num`,`available_day`,`available_date`,`recommend_num`,`grounding_time`,`handling_time`,`handling_time_update_time`,`first_leg_shipping_type`,`buy_box_delivery_type`,`buy_box_event_time`,`buy_box_event_time_site`,`buy_box_offer_seller_id`,`buy_box_price`,`buy_box_listing_price`,`buy_box_offer_source_name`,`is_deleted_update_time`,`is_hot`,`is_hot_update_time`,`condition_type` from t_amazon_listing_17 where (customer_id = 1 and update_time>= date_add(replace('2024-07-07 20:30:00','%',' '), INTERVAL -2 DAY));