Mura: Active Content

gistfile1.sql

WHERE
  (
		tcontent.Active = 1
		AND tcontent.Approved = 1
		AND tcontent.siteid = <cfqueryparam cfsqltype="cf_sql_varchar" value="#arguments.siteID#"/>
	)

	AND (
		tcontent.Display = 2
		AND (
			tcontent.DisplayStart <= #createodbcdate(now())#
			AND (
				tcontent.DisplayStop >= #createodbcdate(now())#
				OR tcontent.DisplayStop IS NULL
			)
		)
		OR tcontent.Display = 1
	)