select live_revision from cr_items where item_id = :template_id select count(*) from cr_revisions where item_id = :template_id