**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**

Список

 
**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** **NAS-REPEAT NAME=rs1**

Тема

Статьи / Непрочитано

Нити

Последняя статья от

Модератор

Кем создано

**rs1.prg_forums.field01**  **rs2.forum.countE** / **rs5.forum.unread**  **rs3.forum.countT**  **rs4.forum.last**  **rs1.prg_forums.created_from**  **rs1.prg_forums.creating_date**