SELECT reg.cons_id
    , totals.cons_first_name as first_name 
    , totals.cons_last_name as last_name
    , '' as primary_email
    , reg.is_captain
    , reg.enabled
    , reg.participation_id
    , reg.registration_date
    , reg.fr_id
    , reg.screenname
    , reg.is_anonymous
    , reg.private_page 
    
    , amount_confirmed + amount_unconfirmed as total
    
  FROM
  	cp.fr_registration reg
        INNER JOIN cp.fr_campaign camp
        on (reg.fr_id = camp.fr_id)
		 
	

LEFT OUTER JOIN cp.fr_team team
		ON (reg.team_id = team.team_id)


LEFT OUTER JOIN cp.fr_mv_gbep totals
		ON (reg.cons_id = totals.cons_id
        AND
        reg.fr_id = totals.fr_id)
WHERE reg.site_id = ?

	AND reg.fr_id in (1340) /* use whatever fr_id value we have if no event type is specified */
 
	AND reg.enabled = 1

	AND camp.status in (1,2,3)
	


	
    	AND convert(reg.first_name_lower,'US7ASCII') LIKE convert('%%%%%','US7ASCII')
	
    
    


	AND lower(team.name) LIKE '%early%'



 ORDER BY name ASC , ROWNUM ASC  ) row_  WHERE rownum <= ? ) WHERE rnum >= ? , Error: ORA-00918: column ambiguously defined


com.convio.exception.CVSQLException: SQL: SELECT * FROM (SELECT row_.*, ROWNUM rnum FROM (-- sql/tr/find_participants.sql