MySQL, using BETWEEN-clause with Active Record

[eluser]Vitsaus[/eluser]
How can I use simple sql queries with Between-clause if I use Active record? Manual didn't give any clear guide with that or maybe I'm just blind.

I want to do something like this:

Code:

SELECT some, random, things FROM pages WHERE lft BETWEEN 2 AND 11 ORDER BY lft ASC