[eluser]mjsilva[/eluser]
Thanks for the answer Colin.
It would be a good feature if active record have something like we have in views eg: $this->load->view('my_view', TRUE) to "spit" the content of the view insteed of loading it, same for AR a $this->db->select('select * from playBoyMansion', TRUE) could return the SQL select statement.
Just for security sake since AR automatically escapes and sanitize the query.
As for my problem, I've fixed it with plain SQL as u suggest, thanks.