$a="SELECT sum(case when a.score in (4,5) then 1 else 0 end)/COUNT(a.id)*100 hpl,c.* FROM decorationeva a,projects b LEFT JOIN decoration c ON b.decorationid=c.id where a.pid=b.id GROUP BY b.decorationid ORDER BY hpl desc,c.id asc";