how to do multiple selects and arithmetic using Active Record

[eluser]m4rw3r[/eluser]
If you want to circumvent the escaping that the where() method does and assign the value directly:

Code:

$this->db->ar_from[] = "(SELECT id FROM products ... ) as prod";

Then you can make subselects and similar operations.
I don't know if it is recommended to do like this, but I think it improves performance of the query (otherwise you have to do some of the work in PHP).