**NAS_DB_OBJECTS** rs1.prg_forum_entries.intfield01, 1 , int4 rs1.prg_forum_entries.field01, 2 , text rs1.prg_forum_entries.intfield02, 3 , int4 rs1.prg_forum_entries.created_from, 4 , text rs1.prg_forum_entries.creating_date, 5 , timestamp rs2.prg_forums.field01, 1 , text rs3.forum.countM, 1, text **NAS_DB_OBJECTS** **NAS_SQL_OBJECTS** **NAS_SELECT = SELECT intfield01, field01, intfield02, created_from, creating_date FROM prg_forum_entries** **NAS_WHERE = |**SQL_WHERE**|** **NAS_ORDER = ORDER BY |**FORUM_SEARCH_ORDER**|** **NAS_MR = 200** **NAS_NFC = maxRowSide** **NAS_SQL_OBJECTS NAME=rs1** **NAS_SQL_OBJECTS** **NAS_SELECT = SELECT count(intfield01) AS countM FROM prg_forum_entries** **NAS_WHERE = |**SQL_WHERE**|** **NAS_ORDER = ** **NAS_SQL_OBJECTS NAME=rs3** Groupware - **OX_APP_TITLE**
   Forum       Archiv       Abonnements       Liste       Erweiterte Suche    
 
**NumberOfResults_rs1**
**NEW_BUTTON** 
**NAS-REPEAT NAME=rs1** **NAS_SQL_OBJECTS** **NAS_SELECT = SELECT field01 FROM prg_forums** **NAS_WHERE = WHERE intfield01 = |**rs1.prg_forum_entries.intfield02**|** **NAS_ORDER = ** **NAS_SQL_OBJECTS NAME=rs2** **NAS-REPEAT NAME=rs1**
 **rs3.forum.countM** gefundene Einträge  
  Nachrichten Titel     Forum Author     Angelegt am    
**rs1.prg_forum_entries.field01**  **rs2.prg_forums.field01**  **rs1.prg_forum_entries.created_from**  **rs1.prg_forum_entries.creating_date**