SELECT goScript
FROM Libraries
WHERE libraryCode = '#navbar#'
SELECT *
FROM Categories
WHERE resourceCode like 'reference'
AND
categoryID = #categoryID#
SELECT subjectHeading, Subjects.subjectID, sequenceNo
FROM Subjects, Categories_Subjects
WHERE
Subjects.subjectID = Categories_Subjects.subjectID
AND
Categories_Subjects.categoryID = #url.categoryID#
ORDER BY sequenceNo
SELECT DISTINCT eResources.title,
eReferences.annotation,
eResources.resourceID,
eResources.moreInfo,
eResources_Libraries.libraryCode,
eResources_Libraries.allowAccess
FROM eResources INNER JOIN
eResources_Subjects ON eResources.resourceID = eResources_Subjects.resourceID
INNER JOIN
eReferences ON eResources.resourceID = eReferences.resourceID
INNER JOIN
eResources_Libraries ON eResources.resourceID = eResources_Libraries.resourceID
WHERE (eResources_Subjects.subjectID = #evaluate(heads[index])#)
AND (eResources.status LIKE 'display')
AND (NOT (eResources_Libraries.allowAccess = 0))
ORDER BY eResources.title
SELECT DISTINCT title, annotation, resourceID, moreinfo
FROM r#index#
ORDER BY title