Database Error Issue

I've received this error a few times in the last copule days.  Anyone know what could be causing it?

Query:

SELECT `bx_sites_main`.`id`, `bx_sites_main`.`url`, `bx_sites_main`.`title`, `bx_sites_main`.`entryUri`, 
`bx_sites_main`.`description`, `bx_sites_main`.`photo`, `bx_sites_main`.`commentsCount`, `bx_sites_main`.
`date`, `bx_sites_main`.`ownerid`, `bx_sites_main`.`categories`, `bx_sites_main`.`tags`, `bx_sites_main`.`rate`  
 FROM `bx_sites_main`   ,Profiles LEFT JOIN sys_acl_levels_members ON `sys_acl_levels_members`.IDMember = Profiles.ID 
AND (`sys_acl_levels_members`.DateStarts IS NULL OR `sys_acl_levels_members`.DateStarts <= 
FROM_UNIXTIME(1265206775)) AND (`sys_acl_levels_members`.DateExpires IS NULL OR `sys_acl_levels_members`
.DateExpires > FROM_UNIXTIME(1265206775)) WHERE 1 AND `bx_sites_main`.`status` ='approved'   order by
 sys_acl_levels_members.IDLevel desc,   `Rate` DESC, `RateCount` DESC, `date` DESC LIMIT 0, 10

Mysql error: Column 'RateCount' in order clause is ambiguous

Found error in the file '/home/public_html/inc/classes/BxDolSearch.php' at line 524.
Called 'db_res_assoc_arr' function with erroneous argument #0.

What's at line 524?  I had one the other day on D6 that was due to a line:

$$sQuery

when it should of been

$sQuery

My bad on that.  It turned out to be 40 lines above where the server was reporting the error.  Look for the simple things.

Scratch that.

It says your "RateCount" is ambiguous.  I had something like this before to.  It means that within the DB you have 2 fields (probably in seperate tables) that is causing your errors.  When creating a site I had named a field in the field builders on the join page as class and I had upgraded the e-mail system that it had an item with class as the name, I got the same error.

Check your field builders and look around to see if you named something the same thing as what another item is using in the DB.