CDbCommand failed to execute the SQL statement: 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 'rank from
(select distinct a.*, ifnull(b.votes, 0) as votes, c.username, c.p' at line 1
