10 лучших по оценкам - DatsoGallery

$database->setQuery("select * from #__fatsogallery ..... order by rating desc");

	case 'rating':
	$database->setQuery("select *, "
	. " imgvotes/imgvotesum "
	. " as rating from #__datsogallery "
	. " as a, #__datsogallery_catg "
	. " as ca where  a.catid=ca.cid "
	. " and a.imgvotes>0 "
	. " and a.published=1 "
	. " and a.approved=1 "
    . " and ca.published=1 "
	. " and ca.access<=$gid "
	. " order by rating,imgvotes desc limit $ad_toplist");