我的sql

select
pl.contract_code,
pl.project_code,
pl.customer_name,
pl.execute_num,
pl.productName,
pl.execute_date,
p.business_line,
p.project_leader,
pd.product_type,
pd.product_num,
pd.package_product_id,
pd.product_id,
pd.hanle_status
from tb_project_execute_logs pl left join
tb_project p
on pl.project_code = p.project_code
LEFT JOIN tb_project_product pd
on p.id = pd.project_id
WHERE p.version_status = 1
and ((pd.product_type = 2 and pd.package_product_id = pl.product_id) or
(pl.product_type <>2 and pl.product_id = pd.product_id)) order by pl.execute_date desc