MySQL Errno : 1064 PHPCMS2008ÎÊÌâ

PHPCMSÆóÒµ»ÆÒ³2008·ÖÒ³ÎÊÌâ
ÎÒÓÃÒÔÏ·½Ê½Çóƽ¾ùÊý
  {get sql="SELECT DISTINCT c.*,
(select round(avg(sort1)) from `phpcms_yp_dp` where userid=c.userid) avgsort1,
(select round(avg(avgprice)) from `phpcms_yp_dp` where userid=c.userid) avgprice 
from `phpcms_member_company` `c`,`phpcms_yp_relation` `r` 
WHERE c.userid = r.userid AND $where 
ORDER BY avgprice DESC" rows="$pagesize" page="$page"
urlrule="$M[url]company.php?pagesize=$pagesize&listtype=$listtype&areaname=$areaname&catid=$catid|$M[url]company.php?pagesize=$pagesize&listtype=$listtype&areaname=$areaname&catid=$catid&page=\\$page" 
distinctfield="\c.userid"}

½«³öÏÖÈçÏ´íÎó
MySQL Query : SELECT COUNT(distinct c.userid) AS `count` from `yehsow_yp_dp` where userid=c.userid) avgsort1, (select round(avg(avgprice)) from `yehsow_yp_dp` where userid=c.userid) avgprice from `yehsow_member_company` `c`,`yehsow_yp_relation` `r` WHERE c.userid = r.userid AND c.status = '1' ORDER BY avgprice DESC 
MySQL Error : 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 ') avgsort1, (select round(avg(avgprice)) from `yehsow_yp_dp` where userid=c.us' at line 1 
MySQL Errno : 1064 
Message : MySQL Query Error

µ±ÎÒ°Ñ·ÖÒ³page="$page"ɾ³ýû´