SELECT
*
FROM
SiteElements
WHERE
Status = 1
AND
SecLevel <= #seclevel#
AND
ItemLevel = 'T'
ORDER BY ItemOrder, ParentID
SELECT
*
FROM
SiteElements
WHERE
Status = 1
AND
SecLevel <= #SecLevel#
AND
ItemLevel = 'S'
AND
ParentID =
ORDER BY SubOrder
The International Coral Reef Initiative
