SELECT threads.ForumNumber, threads.ID, threads.NumReplies, threads.TSCreated, threads.Author, threads.Title, forums.ForumURL, forums.ForumTitle FROM Threads INNER JOIN forums ON forums.forumNumber = threads.forumNumber AND forums.class = threads.class WHERE forums.ForumCategory = '#attributes.ForumCategory#' AND forums.Searchable = 1 AND threads.Deleted = 0 AND forums.Deleted = 0 AND threads.TSCreated > #attributes.Date# AND threads.Class= 1.0 #Class# ORDER BY threads.TSCreated Desc pages = Ceiling(GetResults.RecordCount / SearchPageLength); PageNavigator = ""; if (Pages GT 1) { PageNavigator = DefaultFont & "Pages:"; for (count = 1; count LTE Pages; count = count + 1){ if (attributes.CurrentPage NEQ count) { PageNavigator = PageNavigator & " #Count# |"; } else { PageNavigator = PageNavigator & " #Count# |"; } } if (attributes.CurrentPage LT Pages) { PageNavigator = PageNavigator & " Next &##187;"; } PageNavigator = PageNavigator & "
"; } #DefaultFont##PageNavigator#

if (NumReplies GT 0) {Replies_dsp = " (#NumReplies#)";} else {Replies_dsp = "";} if (CurrentRow MOD 2 eq 1) {bg_color=RowColor1;} else {bg_color=RowColor2;} #HeaderFont#  Search Results   #HeaderFont#  Dialogue   #HeaderFont#  Posted by   #HeaderFont#  Date  #RowHeight_img# #DefaultFont#     No matches found.   Try again.   #RowHeight_img# #DefaultFont#  #Title##Replies_dsp#   #DefaultFont#  #ForumTitle#   #DefaultFont#  #Author#   #DefaultFont#  #DateFormat(TSCreated,'mmm d, yyyy')#  #RowHeight_img#

#DefaultFont##PageNavigator#