更新下厂bug

MPA00003222    PPA00000200

SELECT 
    ppb.`CODE`,
    pp.ID,
    pp.`CODE`,
    pts.TOPIC_NAME,
    ads.STAFF_ID AS staffId,
    0,
    NOW(),ppb.BANYIN_CIP
FROM pi_pubplan pp
LEFT JOIN pi_topics pts ON pp.TOPIC_ID=pts.TOPIC_ID
LEFT JOIN pi_lookupcode_relation plr ON plr.LOOKUPCODE_SRC = pts.DUTY_DEPT
LEFT JOIN ad_person adp ON adp.`CODE` = plr.RELATED_RECORD_CODE  AND adp.DEL_FLAG = 0
LEFT JOIN ad_staff ads ON ads.PERSON_ID = adp.PERSON_ID AND ads.`STATUS` = 'XT0801'
LEFT JOIN pi_topic_product_relation ptpr ON pp.TOPIC_ID=ptpr.TOPIC_ID
LEFT JOIN pi_prtmanufact_bill ppb ON ppb.PRODUCT_ID=ptpr.PRODUCT_ID
WHERE pp.`CODE` in(
    SELECT pp.`CODE`
    FROM pi_prtmanufact_bill ppb
    LEFT JOIN pi_prtmanufact_schedule pps ON ppb.PRTMANUFACT_BILL_ID=pps.PRTMANUFACT_BILL_ID
    LEFT JOIN pi_topic_product_relation ptpr ON ppb.PRODUCT_ID=ptpr.PRODUCT_ID
    LEFT JOIN pi_pubplan pp ON pp.TOPIC_ID=ptpr.TOPIC_ID
    WHERE pp.IS_PRTING='PI2301' AND pps.SYNCHRO_STATUS=1 AND ppb.BANYIN_CIP='1-1' 
AND (
pps.SYNCHRO_TIME >= date_sub(curdate(), INTERVAL 360 DAY)
AND pps.SYNCHRO_TIME <= date_format(now(), '%y-%m-%d')
)
    GROUP BY pp.ID
) AND ppb.BANYIN_CIP='1-1' AND pp.IS_PRTING='PI2301' AND pp.`STATUS`!='PI1405'
GROUP BY pp.ID
 

转载于:https://my.oschina.net/marlon520/blog/1800355