select searchterms, datesearched from #prefix#search_log where datesearched > select searchterms, datesearched from searchstats order by datesearched desc select searchterms, count(searchterms) as score from searchstats where datesearched > group by searchterms order by score desc select searchterms, count(searchterms) as score from searchstats where datesearched > group by searchterms order by score desc select searchterms, count(searchterms) as score from searchstats where datesearched > group by searchterms order by score desc select searchterms, count(searchterms) as score from searchstats group by searchterms order by score desc

General Stats
Latest Search: #latest.searchterms[1]# (#dateFormat(latest.dateSearched[1],"m/d/yy")# at #timeFormat(latest.dateSearched[1],"h:mm tt")#)
Most Popular (Today): #todaysbest.searchterms# (#todaysbest.score#)
Most Popular (Past 30 Days): #thismonth.searchterms# (#thismonth.score#)
Most Popular (Past 365 Days): #thisyear.searchterms# (#thisyear.score#)

Top 30 Search Terms
#searchTerms# #score#