Complex SQL Query with Active Record

[eluser]Burak Erdem[/eluser]
[quote author="jedd" date="1261157235"][quote author="demods" date="1261154939"]
I'm trying to write a complex sql query with CI Active Record, but I couldn't manage to write it.
[/quote]

Show the SQL you're trying to emulate.

Show the AR snippet that you've got so far.

Describe how the results of what you've got so far diverge from your intent.[/quote]

The problem is that I also couldn't manage to write the SQL query itself. I know that's not related to CI but if I can write the query, maybe I can also emulate it with AR.

Thanks.