select t.id,t.ts,t.name,t.rating,min(picture.id) pid from (select apparel.id,apparel.ts,apparel.name,R.rating from (select avg((n-dist) * value) rating,rating.apparel from (select count(account) n,avg(dif) dist,account from (select T2.account,abs(T1.value-T2.value) dif from rating T1,rating T2 where T1.account='Toba' and T2.account<>'Toba' and T1.apparel=T2.apparel and (abs(T1.value-T2.value) < 3)) T group by account order by N desc,dist asc) T,rating where T.account=rating.account and rating.apparel not in (select apparel from rating where account='Toba') group by apparel order by rating desc) R,apparel where R.apparel=apparel.id) t,picture where picture.apparel=t.id group by t.id order by rating desc