select
rp.store_code as storecode,
div.name as division,
COALESCE(tmpl.default_code,'') as mmcode
from 
res_partner as rp
left join division_mapping as dp on dp.partner_id = rp.id
left join division_mapping_product_product_rel as rel on dp.id = rel.division_mapping_id
left join division as div on div.id = dp.division_id
left join product_product as prod on prod.id = rel.product_product_id
left join product_template as tmpl on tmpl.id = prod.product_tmpl_id;