select 
    b.id as boutId,
    b.event_id,
    b.created_at,
    b.match_is_rated,
    b.period_1_length_in_minutes,
    b.period_2_length_in_minutes,
    b.period_3_length_in_minutes,
    r1.id as topLineRegistrationId,
    w1.id as topLineWrestlerId,
    w1.first_name as topLineWrestlerFirstName,
    w1.last_name as topLineWrestlerLastName,
    w1.birthday as topLineBirthday,
    t1.id as topLineTeamId,
    t1.team_name as topLineTeamName,
    wi1.weight_in_pounds as topLineWeight,
    r2.id as bottomLineRegistrationId,
    w2.id as bottomLineWrestlerId,
    w2.first_name as bottomLineWrestlerFirstName,
    w2.last_name as bottomLineWrestlerLastName,
    w2.birthday as bottomLineBirthday,
    t2.id as bottomLineTeamId,
    t2.team_name as bottomLineTeamName,
    wi2.weight_in_pounds as bottomLineWeight,
    ws.id as wrestlingStylesId,
    ws.name_of_style
    from bouts b
    join registrations r1 on b.top_line_wrestler_registration_id=r1.id
    join registrations r2 on b.bottom_line_wrestler_registration_id=r2.id
    join wrestlers w1 on w1.id=r1.wrestler_id
    join wrestlers w2 on w2.id=r2.wrestler_id
    left join teams t1 on t1.id=r1.team_id
    left join teams t2 on t2.id=r2.team_id
    join weigh_ins wi1 on w1.id=wi1.wrestler_id and wi1.event_id=b.event_id
    join weigh_ins wi2 on w2.id=wi2.wrestler_id and wi2.event_id=b.event_id
    join wrestling_styles ws on ws.id=b.wrestling_styles_id
    where b.dispatch_time_in_utc is null 
    and b.event_id=? 
    -- and b.dual_meets_id is null
    order by b.created_at asc;

select 
    b.id as boutId,
    b.event_id,
    b.created_at,
    b.match_is_rated,
    b.period_1_length_in_minutes,
    b.period_2_length_in_minutes,
    b.period_3_length_in_minutes,
    r1.id as topLineRegistrationId,
    w1.id as topLineWrestlerId,
    w1.first_name as topLineWrestlerFirstName,
    w1.last_name as topLineWrestlerLastName,
    w1.birthday as topLineBirthday,
    t1.id as topLineTeamId,
    t1.team_name as topLineTeamName,
    wi1.weight_in_pounds as topLineWeight,
    r2.id as bottomLineRegistrationId,
    w2.id as bottomLineWrestlerId,
    w2.first_name as bottomLineWrestlerFirstName,
    w2.last_name as bottomLineWrestlerLastName,
    w2.birthday as bottomLineBirthday,
    t2.id as bottomLineTeamId,
    t2.team_name as bottomLineTeamName,
    wi2.weight_in_pounds as bottomLineWeight,
    ws.id as wrestlingStylesId,
    ws.name_of_style
    from bouts b
    join registrations r1 on b.top_line_wrestler_registration_id=r1.id
    join registrations r2 on b.bottom_line_wrestler_registration_id=r2.id
    join wrestlers w1 on w1.id=r1.wrestler_id
    join wrestlers w2 on w2.id=r2.wrestler_id
    left join teams t1 on t1.id=r1.team_id
    left join teams t2 on t2.id=r2.team_id
    join weigh_ins wi1 on w1.id=wi1.wrestler_id and wi1.event_id=b.event_id
    join weigh_ins wi2 on w2.id=wi2.wrestler_id and wi2.event_id=b.event_id
    join wrestling_styles ws on ws.id=b.wrestling_styles_id
    where b.dispatch_time_in_utc is null 
    and b.event_id=? 
    -- and b.dual_meets_id is null
    order by b.created_at asc;