select cx.*, ci.live_revision, ci.latest_revision, ci.locale, ci.publish_status, ci.content_type, ci.storage_type from ${table_name} cx, cr_items ci where ci.${revision}_revision = cx.revision_id and ci.item_id = :item_id select name from cr_items where parent_id = :parent_id