select * from pm_projectsx where revision_id=:revision_id
where you'd use the latest or live revision from cr_items depending on which makes sense for your application.
Then you'd set the attributes for content::revision::new using that data.