[eluser]mandrake[/eluser]
It's possible generate with Datamapper a query like this:
Code:
SELECT `table`.*, `images`.`*`
FROM (`table`)
LEFT OUTER JOIN `images` as images ON `table`.`id` = `images`.`table_id` AND `images`.`is_main` = 1
ORDER BY `table`.`id` asc
LIMIT 20