[solved] database helpers

[eluser]superfake123[/eluser]
How do I use the databse helpers with this query? I'd like to do it properly using the codeigniter helpers but could not get it to work. I'd get an sql error 'colum not found'