select contentid, menutitle, title, body from tcontent where siteid= and ( (tcontent.Active = 1 AND tcontent.DisplayStart <= #createodbcdatetime(now())# AND (tcontent.DisplayStop >= #createodbcdatetime(now())# or tcontent.DisplayStop is null) AND tcontent.Display = 2 AND tcontent.Approved = 1 AND tcontent.contentid = AND tcontent.moduleAssign like '%00000000000000000000000000000000000%') or (tcontent.Active = 1 AND tcontent.Display = 1 AND tcontent.Approved = 1 AND tcontent.contentid = AND tcontent.moduleAssign like '%00000000000000000000000000000000000%') ) #setDynamicContent(rsTemplate.body)#