ActiveRecord: where not in select ?

[eluser]pmoroom[/eluser]
[quote author="toopay" date="1308978220"]I will say that CI AR is actually not really using AR pattern. It kinda just like a helper, with a lot limitation (nested where, subquery, etc). And if you already comfort with writing SQL directly, you will face some ackward when using CI AR.

Actually, thats why i create my own db helper, for generates my needs of crafting SQL with object orientation.[/quote]

I found it to be the same as you. It's great for basic things, but for more complex you need to go back to standard SQL or perhaps there is a way to do it in AR CI, but it's not worth the effort to work it out