资深java工程师写mysql表子查询left join导致大事务-线上事故

select  
    id, item_id, item_name, is_use, item_category_level_oms1, item_category_level_oms2,
    item_category_level_oms3, item_category_level_oms4, item_type, sub_type, package_id,
    package_type, item_channel, manage_type, trade_mode, tax_type, item_brand, item_brandName,
    quanlity_five_hundred, addKnowledge, item_category_level_oms1_name, item_category_level_oms2_name,
    item_category_level_oms3_name, item_category_level_oms4_name, tag_id, store_code
   ,  
    item_img_s
   
    from t_ambient_x where item_id in (
        select distinct(c.item_id) from t_ambient_x c left join t_ambient_x2 d
        on c.item_id = d.data_source_id
        and d.data_source_type = 1
         WHERE  c.item_name like CONCAT('%','荣耀V40 双超级快充 5000万超感光影像 5G手机','%') 
    )
    order by addKnowledge desc
    limit 0, 30