select *
from manager_contentaddresource cas
inner join manager_contenttemplate ct on cas.content_template_id = ct.id
inner join manager_mediaitem mi on mi.content_template_id = ct.id
inner join manager_medialistitems mli on mli.media_id = mi.id
inner join manager_medialist ml on mli.media_list_id = ml.id
inner join manager_contentprofile cp on cp.media_list_id = ml.id
where cp.id = 1