selectavg(`rating`) as aggregate from `ratings` where `ratings`.`ratable_type` ='event'and `ratings`.`ratable_id` =4104and `ratings`.`ratable_id` isnotnull
selectavg(`rating`) as aggregate from `ratings` where `ratings`.`ratable_type` ='event'and `ratings`.`ratable_id` =4104and `ratings`.`ratable_id` isnotnull
select `people`.*, `commentator_event`.`event_id` as `pivot_event_id`, `commentator_event`.`person_id` as `pivot_person_id`, `commentator_event`.`chair` as `pivot_chair`, `commentator_event`.`created_at` as `pivot_created_at`, `commentator_event`.`updated_at` as `pivot_updated_at` from `people` innerjoin `commentator_event` on `people`.`id` = `commentator_event`.`person_id` where `commentator_event`.`event_id` =4104
select `people`.*, `bout_fighter`.`bout_id` as `pivot_bout_id`, `bout_fighter`.`person_id` as `pivot_person_id`, `bout_fighter`.`id` as `pivot_id`, `bout_fighter`.`title_status` as `pivot_title_status`, `bout_fighter`.`fight_weight` as `pivot_fight_weight`, `bout_fighter`.`prefight_record` as `pivot_prefight_record`, `bout_fighter`.`designation` as `pivot_designation`, `bout_fighter`.`fighting_out_of` as `pivot_fighting_out_of`, `bout_fighter`.`created_at` as `pivot_created_at`, `bout_fighter`.`updated_at` as `pivot_updated_at` from `people` innerjoin `bout_fighter` on `people`.`id` = `bout_fighter`.`person_id` where `bout_fighter`.`bout_id` in (24695)