Thread

Hello,

I’m running EE 1.6.9 on Site A and use the Multiple Site Manager to manage Site B. Both sites have similarly structured data that I’d like to pull and display in one table.

Is there a way with SQL to query both sites and display data in one table?

Thanks for any insight,
Jenny

Hi jtoast,

You should be able to do this easily just by using channel entries and the parameter site=“siteA|siteB|siteC”. Please see the Docs on MSM

If this doesn’t help you please let me know and we’ll find a solution.

Sean

Thanks, Sean. Looks like this solution should work with EE 1.6.9 as well. I’ll give it a try!

http://expressionengine.com/legacy_docs/cp/sites/code.html

Best,
Jenny

So, using weblog entries does indeed work for simple queries. But if I’m doing more advanced querying, is there a way to reference multiples sites via SQL? Or is this beyond the scope of the forums?

Thanks much,
Jenny

Hi Jenny,

I’m not familiar with SQL queries myself. But I could move the thread to community support if you would like. You might find more people able to help you with the queries.

Sean