Article Topics
select distinct tblArticles.articleid, tblarticles.title from
tblArticles, tlkpTopicGroup, TrelSectionArt
where
tblArticles.TopicID = #url.topicid#
and tblArticles.Status = 1
and
(
(TblArticles.CAL_DATE_Start <= #CreateODBCDate(Now())# and TblArticles.CAL_DATE_END >= #CreateODBCDate(Now())# and TblArticles.CAL_DATE_END is not null and TblArticles.CAL_DATE_Start is not null)
or (TblArticles.CAL_DATE_END is null and TblArticles.CAL_DATE_Start is not null and TblArticles.CAL_DATE_Start <= #CreateODBCDate(Now())#)
or (TblArticles.CAL_DATE_Start is null and TblArticles.CAL_DATE_END is not null and TblArticles.CAL_DATE_END >= #CreateODBCDate(Now())#)
or (TblArticles.CAL_DATE_Start is null and TblArticles.CAL_DATE_END is null)
)
