Mura CMS : How to combine or commingle multiple feeds/content collections across multiple Mura CMS sites under the same installation.

mura-combine-feeds.cfm

<cfscript>
  // Combine feeds/content collections across multiple Mura sites under same install

  feed1 = $.getBean('feed').loadBy(name='Feed Name Goes Here', siteid='SomeSiteID');
  feed2 = $.getBean('feed').loadBy(name='Another Feed Name Goes Here', siteid='AnotherSiteID');

  // Use Query of Queries to UNION recordsets
  qoq = new Query();
  qoq.setAttributes(rs1=feed1.getQuery(), rs2=feed2.getQuery());
  qoq.setSQL('SELECT * FROM rs1 UNION SELECT * FROM rs2 ORDER BY releasedate');
  rsQoQ = qoq.execute().getResult();

  // Use the combined query to seed the contentIterator
  iterator = $.getBean('contentIterator').setQuery(rsQoQ);
</cfscript>