<p>Currently all optional mia type tables are joined in the main&nbsp;MIA query, this is redundant for MultipleMIAs as they are explicitly selected separately after the main MIA query. </p>

<p>Joining to multiple MIA tables cause a lot of duplication of rows which hurts performance and stops paging working as expected. Local tests showed 900 returned rows for a query to select 19 movies if all known MIAs are optionally requested&nbsp;<img alt="Tongue" height="16" src="https://issues.team-mediaportal.com/plugins/servlet/jeditor_ck_provider.jsp?file=plugins/smiley/images/jira_tongue.png" title="Tongue" width="16"></p>

<p>Rework the query builders to only join MultipleMIA tables if they are a necessary requested MIA.</p>

<p>&nbsp;</p>