DataMapper ORM v1.8.0

[eluser]danijelb[/eluser]
[quote author="rherriman" date="1303933915"]danijelb:

It would be easier to answer your question with more schema details. It's difficult to tell from your post what tables there are, and what fields they contain.[/quote]

Here it is:
http://i56.tinypic.com/14t3pyp.png

Greyed out tables are just here to show the rest of schema, but are not important for my question.

A connection between Pages and Content needs to be created to get be as close as the Desired result table (which I can get by classic SQL queries)...

Also, the connection (relationship) will need to be created dinamically (but I think I will be able to handle it, just first I need to figure out the way to create this type of relationship)...

This is a concept where all site's content can be nested whether it's a page, an article, image, category, or something else... Also, this way - multilingual content is much more easier to manipulate and I can have global comment system (which would store comments based on contents.id)... And it would be easy to incorporate new content types and they would get all benefits of this way of storing (they would get comments, multilinguality, nesting...)

But for now I just need to figure out how to (manually) create this (Page-Content) relationship...