Thanks for the reply, yours worked in my SQL client. But I seem to be having a real problem with backticks (I think).

CDbCommand:) failed: SQLSTATE[42000]: Syntax error or access violation:
1064 You have an error in your SQL syntax; check the manual that
corresponds to your MySQL server version for the right syntax to use near
'.`title, i`.`area_id, i`.`slug`...