select r.title from cr_revisions r, cr_items i where i.latest_revision = r.revision_id and i.item_id = :invoice_id update cr_items set latest_revision = null, live_revision = null where item_id = :invoice_id