if (arguments.avg LTE 0) num = "zero"; else if (arguments.avg LT 1) num = "half"; else if (arguments.avg LT 1.5) num = "one"; else if (arguments.avg LT 2) num = "onehalf"; else if (arguments.avg LT 2.5) num = "two"; else if (arguments.avg LT 3) num = "twohalf"; else if (arguments.avg LT 3.5) num = "three"; else if (arguments.avg LT 4) num = "threehalf"; else if (arguments.avg LT 4.5) num = "four"; else if (arguments.avg LT 5) num = "fourhalf"; else if (arguments.avg GTE 5) num = "five"; select avg(tcontentratings.rate) as theAvg, count(tcontentratings.contentID) as theCount, (count(tcontentratings.contentID)-downVotes) as upVotes, downVotes from tcontentratings left join (select count(rate) as downVotes, contentID,siteID from tcontentratings where siteID= and contentID= and rate=1 group by contentID,siteID) qDownVotes On (tcontentratings.contentID=qDownVotes.contentID and tcontentratings.siteID=qDownVotes.siteID) where tcontentratings.siteID= and tcontentratings.contentID= group by downVotes select * from ( SELECT Top #arguments.limit# tcontent.ContentHistID, tcontent.ContentID, tcontent.Approved, tcontent.filename, tcontent.Active, tcontent.Type, tcontent.OrderNo, tcontent.ParentID, tcontent.siteID, tcontent.moduleID, tcontent.Title, tcontent.menuTitle, tcontent.lastUpdate, tcontent.lastUpdateBy, tcontent.lastUpdateByID, tcontent.Display, tcontent.DisplayStart, tcontent.DisplayStop, tcontent.isnav, tcontent.restricted, avg(tcontentratings.rate) AS theAvg, count(tcontentratings.contentID) AS theCount, tcontent.isfeature,tcontent.inheritObjects,tcontent.target, tcontent.targetParams,tcontent.islocked,tcontent.sortBy,tcontent.sortDirection,tcontent.releaseDate, tfiles.fileSize,tfiles.FileExt,tfiles.ContentType,tfiles.ContentSubType FROM tcontent INNER JOIN tcontentratings ON tcontent.contentid=tcontentratings.contentid and tcontent.siteid=tcontentratings.siteid LEFT JOIN tfiles On tcontent.FileID=tfiles.FileID and tcontent.siteID=tfiles.siteID WHERE tcontent.siteid='#arguments.siteid#' and tcontent.Active=1 and (tcontent.Type ='Page' or tcontent.Type = 'Component' or tcontent.Type = 'Link' or tcontent.Type = 'File' or tcontent.Type = 'Portal' or tcontent.Type = 'Calendar' or tcontent.Type = 'Form' or tcontent.Type = 'Gallery') and tcontentratings.entered >= #createodbcdatetime(createdatetime(year(start),month(start),day(start),0,0,0))# and tcontentratings.entered >= #createodbcdatetime(createdatetime(year(arguments.startDate),month(arguments.startDate),day(arguments.startDate),0,0,0))# and tcontentratings.entered <= #createodbcdatetime(createdatetime(year(stop),month(stop),day(stop),23,59,0))# and tcontentratings.entered <= #createodbcdatetime(createdatetime(year(arguments.stopDate),month(arguments.stopDate),day(arguments.stopDate),23,59,0))# group by tcontent.ContentHistID, tcontent.ContentID, tcontent.Approved, tcontent.filename, tcontent.Active, tcontent.Type, tcontent.OrderNo, tcontent.ParentID, tcontent.siteID, tcontent.moduleID, tcontent.Title, tcontent.menuTitle, tcontent.lastUpdate, tcontent.lastUpdateBy, tcontent.lastUpdateByID, tcontent.Display, tcontent.DisplayStart, tcontent.DisplayStop, tcontent.isnav, tcontent.restricted,tcontent.isfeature,tcontent.inheritObjects, tcontent.target,tcontent.targetParams,tcontent.islocked,tcontent.sortBy,tcontent.sortDirection, tcontent.releaseDate,tfiles.fileSize,tfiles.FileExt,tfiles.ContentType,tfiles.ContentSubType HAVING count(tcontentratings.contentID) >= #arguments.threshold# ORDER BY theAvg desc, theCount desc limit #arguments.limit# ) where ROWNUM <=1