[Deprecated] DMZ 1.5.4 (DataMapper OverZealous Edition)

[eluser]OverZealous[/eluser]
[quote author="mandrake" date="1258065242"]It's possible generate with Datamapper a query like this:[/quote]

Was that a question? ;-)

If so, you can't make that exact query (there is no way in CodeIgniter's AR to use compound join statements without modifying the CI database libraries).

Depending on what it is you are asking, you might be able to get similar results like this:

Code:

$tables = new Table();
$tables
    ->where_related_image('is_main', 1)
    ->order_by('id', 'ASC')
    ->get();

But you didn't provide enough information. How are image and table related (1-to-N or 1-to-1)? If they are 1-to-1, you can include the columns from images in your results. If they are 1-to-N, there is no way in DMZ, currently, to include the columns. You'll have to run an extra query for each result to get those columns.

The next version of DMZ (yet to be released) will have support for subqueries, which could be used for this. You still won't be able to write compound JOIN statements, and I don't have any plans to include them.

Also, check out the query method, which will let you run your own queries manually. I don't recommend that unless there is no way to build the query otherwise, but I can't see a way around it with your example.