003 - Loskoppelen ritten in route zonder kop

UPDATE 
Planning SET pla_van=0, pla_naar=0, pla_route=0 
WHERE pla_id IN
(SELECT DISTINCT R1.pla_id FROM planning R1 
WHERE R1.pla_status = 'W'
AND R1.pla_route NOT IN (SELECT DISTINCT P2.pla_route FROM planning P2 WHERE (P2.pla_van = 1) AND (CONVERT(DATE, P2.pla_datumtijd) = CONVERT(DATE, GETDATE())))
AND (R1.pla_route > 0)
AND (CONVERT(DATE, R1.pla_datumtijd) = CONVERT(DATE, GETDATE())));