Strul igen

Det jag försöker med är att hämta dom användare som har skrivit flest gästboks inlägg och hur många varje person har skrivit. Fel meddelandet jag får är:

Microsoft JET Database Engine error '80004005'
ORDER BY clause (antal) conflicts with DISTINCT.

"select distinct t2.[from], "&_			
	"t1.id, "&_
	"t1.usrname, "&_
	"t1.gender, "&_
	"t1.dob, "&_
	"t1.senast, "&_
	"(select count(id) as antal from tblUserPm where [from]=t1.id) "&_
	"from tblUserInfo as t1,tblUserPm as t2 "&_
	"where t2.privat=false AND t2.ref > 1 AND t1.id=t2.[from] "&_ 
	"order by antal"

"select distinct t2.[from], "&_			
	"t1.id, "&_
	"t1.usrname, "&_
	"t1.gender, "&_
	"t1.dob, "&_
	"t1.senast, "&_
	"(select count(id) from tblUserPm where [from]=t1.id) as antal "&_
	"from tblUserInfo as t1,tblUserPm as t2 "&_
	"where t2.privat=false AND t2.ref > 1 AND t1.id=t2.[from] "&_ 
	"order by 7"

Tusen tack LarsG.