Description of problem:

When investigating duplicate output in bug 252165, we came to conclusion that:

- we need to (outer) join rhnChannel with rhnChannelCloned to make hibernate happy;
- but the join should be via c.id = c_1_.id, not c.id = c_1_.original_id.

I grepped eng/java/code/src/com/redhat/rhn/domain/channel/Channel.hbm.xml and
found three more occurencies of outer join with .original_id:

    <sql-query name="Channel.findByIdAndUserId">
        <![CDATA[SELECT {c.*} 
              FROM rhnChannel {c},
              rhnChannelCloned c_1_
             WHERE c.id = :cid
               AND c.id = c_1_.original_id (+)
               AND rhn_channel.user_role_check(c.id, :userId, 'subscribe') = 1]]>
        <return alias="c" class="com.redhat.rhn.domain.channel.Channel" />
    </sql-query>
    
   <sql-query name="Channel.findByLabelAndUserId">
        <![CDATA[SELECT {c.*} 
              FROM rhnChannel {c},
              rhnChannelCloned c_1_
             WHERE c.label = :label
               AND c.id = c_1_.original_id (+)
               AND rhn_channel.user_role_check(c.id, :userId, 'subscribe') = 1]]>
        <return alias="c" class="com.redhat.rhn.domain.channel.Channel" />
    </sql-query>
    
    <sql-query name="Channel.findBaseChannel">
        <![CDATA[SELECT {c.*} 
              FROM rhnChannel {c}, rhnChannelCloned c_1_, rhnServerChannel sc
             WHERE sc.server_id = :sid
               AND sc.channel_id = c.id
               AND c.id = c_1_.original_id (+)
               AND c.parent_channel IS NULL]]>
        <return alias="c" class="com.redhat.rhn.domain.channel.Channel" />
    </sql-query>


That might not be correct.

Version-Release number of selected component (if applicable):

5.1.0.

How reproducible:

I just looked at the code.

Steps to Reproduce:
1. I don't really have steps here. I assume that somewhere, these queries might
cause problems and duplicate output.
2. Find those places.
  
Actual results:

Duplicate output.

Expected results:

No duplicate output and profit.

Additional info:

This is mainly a placeholder for investigating whether those joins with
.original_id are legit or not.