This uses solr and infintescroll to create a frontpage widget.
%STARTINCLUDE%<!-- --> <div class="jqInfiniteScroll recentChanges {itemSelector:'.clsIndexItem', localMode:true, bufferPx:200}"> %DBCALL{"%WEB%.%TOPIC%" section="backend" LIMIT="%LIMIT{default="20"}%" PAGE="%PAGE{default="0"}%" THEWEB="%THEWEB{default="%BASEWEB%"}%" FILTER="%FILTER{default="TopicType!~'\bTopicStub\b'"}%" }% </div> <div class="jqInfiniteScrollNavi foswikiHidden"> <a href="%SCRIPTURLPATH{"view"}%/%WEB%/%TOPIC%?page=1§ion=backend&skin=text&template=view&web=%THEWEB{default="%BASEWEB%"}%&filter=%ENCODE{"%FILTER{default="TopicType!~'\bTopicStub\b'"}%"}%&limit=%LIMIT{default="20"}%" class='jqInfiniteScrollNext'>More</a> </div> <literal><style> .recentChanges { overflow-x:hidden; overflow-y:auto; padding-right:1em; height:%HEIGHT{default="40em"}%; } </style></literal> <!-- %JQREQUIRE{"infinitescroll" warn="off"}% -->%STOPINCLUDE%
%STARTSECTION{"backend"}%<noautolink>%DBQUERY{ "%URLPARAM{"filter" default="%FILTER{default="TopicType!~'\bTopicStub\b'"}%"}%" exclude="^(WebLexicon|WebChanges|WebPreferences|WebStatistics|WebTopicList|WebIndex|WebNotify|WebHome|WebLinks|TopCategory|Category|ClassifiedTopic|TopicType|WebTopicEditTemplate|WebAtom|WebRss|WebLeftBar|WebSearch.*|WebTagList|CategoryBrowser|UntaggedTopics|UncategorizedTopics)$" webs="%URLPARAM{"web" default="%THEWEB{default="%BASEWEB%"}%"}%" skip="%CALCULATE{"$EVAL(%URLPARAM{"page" default="%PAGE{default="0"}%"}%*%URLPARAM{"limit" default="%LIMIT{default="20"}%"}%)"}%" limit="%URLPARAM{"limit" default="%LIMIT{default="20"}%"}%" sort="modified" reverse="on" format="$percntDBCALL{\"$web.$topic->RenderIndexItem\"}$percnt" separator="$n" }%</noautolink>%ENDSECTION{"backend"}%