This uses solr and infintescroll to create a frontpage widget.
%STARTINCLUDE%<div class="jqInfiniteScroll recentChanges %CLASS{default=""}%" data-item-selector=".clsIndexItem" data-local-mode="true" data-buffer-px="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" topic="%WEB%.%TOPIC%" page="1" section="backend" skin="text" template="view" web="%THEWEB{default="%BASEWEB%"}%" filter="%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" encode="off" 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.*)$" 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"}%