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
