different updates

doesnt_work.sql

UPDATE tracked_points SET worker_id = worker_tags.worker_id
 FROM tags LEFT JOIN worker_tags ON tags.id = worker_tags.tag_id
 WHERE (tags.frequency = tracked_points.frequency OR worker_tags.id IS NULL)
 AND tracked_points.worker_id_checked_at IS NULL

select.sql

SELECT tracked_points.id, tracked_points.worker_id, worker_tags.worker_id FROM tracked_points 
INNER JOIN tags ON tags.frequency = tracked_points.frequency
LEFT JOIN worker_tags ON worker_tags.tag_id = tags.id
WHERE tracked_points.worker_id IS NULL
AND (tags.frequency = tracked_points.frequency OR worker_tags.id IS NULL)
ORDER BY recorded_at DESC
LIMIT 100

works.sql

UPDATE tracked_points SET worker_id = worker_tags.worker_id
FROM tags
LEFT JOIN worker_tags ON worker_tags.tag_id = tags.id
WHERE tracked_points.worker_id IS NULL
AND tags.frequency = tracked_points.frequency