DataMapper ORM v1.8.2

[eluser]WanWizard[/eluser]
I think you can, but you'll have to use a subquery which is going to make it complex.

It would be handy if DataMapper would support WHERE EXIST, but it doesn't (and I'm not sure all RDBMS's support that, so many not a good idea either).

Alternatively, you could add a custom method to your model, write a standard query for it, run that using $this->db->query, make sure it returns at least the category id column, and convert the result back into the object by calling

Code:

$result = $this->db->query('your sql here');
$result and $this->_process_query($result);