rc_score

rc_score

select *
from score s
inner join roi_campaign_score rcs on rcs.score_id = s.score_id
inner join roi_campaign_score_type rcst on rcst.roi_campaign_score_type_id = rcs.roi_campaign_score_type_id
inner join roi_campaign_score_weight rcsw on rcsw.roi_campaign_score_id = rcs.roi_campaign_score_id
inner join score_score_attribute ssa on ssa.score_attribute_id = rcsw.score_attribute_id
where rcs.roi_campaign_id in (55)

select rcs.roi_campaign_score_id, s.score_id, s.score_name, sa.*, w.roi_campaign_score_weight_id, w.roi_campaign_score_weight_value, rcs.primary_score
from roi_campaign_score rcs
inner join score s on (s.score_id = rcs.score_id)
inner join score_score_attribute ssa on (ssa.score_id = s.score_id)
inner join score_attribute sa on (sa.score_attribute_id = ssa.score_attribute_id)
inner join roi_campaign_score_weight w on (w.roi_campaign_score_id = rcs.roi_campaign_score_id
and w.score_attribute_id = sa.score_attribute_id
)
where rcs.roi_campaign_id = 55
order by roi_campaign_score_id