Add scope wherever we can

[Dynnammo]

Any resource has a single scope in Decidim , therefore we could make a left join with the name of the scope instead of letting currently the id of the scope.

select
decidim_scopes.name,
...
from blabla
left join decidim_scopes on decidim_scopes.id = decidim_scope_id
...

• proposals
• meetings
• debates
• projects

Not currently taken into account : accountability results, elections