**NAS_DB_OBJECTS**
rs1.prg_forums.creating_date, 1, timestamp, 3, 1
rs1.prg_forums.created_from, 2, text, 3, 1
rs1.prg_forums.intfield01, 3, int4, 3, 1
rs1.prg_forums.field01, 4, text, 3, 1
rs2.forum.countE, 1, text, 3, 1
rs3.forum.countT, 1, text, 3, 1
rs4.forum.last, 1, text, 3, 1
rs5.forum.unread, 1, text, 3, 1
**NAS_DB_OBJECTS**
**NAS_SQL_OBJECTS**
**NAS_SELECT = SELECT creating_date, created_from, intfield01, field01 FROM prg_forums**
**NAS_WHERE = WHERE ((archiv like 'false') AND (((user_right LIKE '|**NAS_USER**|') OR (group_right LIKE 'a') OR (group_right LIKE 'g' AND intfield06 IN (SELECT object_id FROM prg_forum_read WHERE ((user_right IS NULL) AND (group_right IS NULL)))) OR (group_right LIKE 'g' AND intfield06 IN (SELECT object_id FROM prg_forum_read WHERE (((user_right LIKE '|**NAS_USER**|') OR (group_right IN (|**memberingroups**|)))))))))**
**NAS_ORDER = ORDER BY |**FORUM_ORDER**|**
**NAS_MR = 200**
**NAS_NFC = 0**
**NAS_SQL_OBJECTS NAME=rs1**
Groupware - **OX_APP_TITLE**
Liste
Forenthema
Beiträge / Ungelesen
Threads
Letzter Beitrag vom
Moderator
Angelegt am
**NAS-REPEAT NAME=rs1**
**NAS_SQL_OBJECTS**
**NAS_SELECT = SELECT count(intfield01) AS countE FROM prg_forum_entries WHERE intfield02 LIKE '|**rs1.prg_forums.intfield01**|'**
**NAS_WHERE = **
**NAS_ORDER = **
**NAS_SQL_OBJECTS NAME=rs2**
**NAS_SQL_OBJECTS**
**NAS_SELECT = SELECT count(intfield01) AS countT FROM prg_forum_entries WHERE ((intfield02 LIKE '|**rs1.prg_forums.intfield01**|') AND (intfield03 IS NULL))**
**NAS_WHERE = **
**NAS_ORDER = **
**NAS_SQL_OBJECTS NAME=rs3**
**NAS_SQL_OBJECTS**
**NAS_SELECT = SELECT creating_date AS last FROM prg_forum_entries WHERE intfield02 LIKE '|**rs1.prg_forums.intfield01**|'**
**NAS_WHERE = **
**NAS_ORDER = ORDER BY creating_date DESC**
**NAS_SQL_OBJECTS NAME=rs4**
**NAS_SQL_OBJECTS**
**NAS_SELECT = SELECT (|**rs2.forum.countE**| - count(object_id)) AS unread FROM prg_forum_seen WHERE ((username like '|**NAS_USER**|') AND (forum_id = '|**rs1.prg_forums.intfield01**|'))**
**NAS_WHERE = **
**NAS_ORDER = **
**NAS_SQL_OBJECTS NAME=rs5**