SELECT * FROM theweekin WHERE year >= #url.startYear# AND year <= #url.endYear#
SELECT * FROM repositoryfiles WHERE dateYear <> 0 AND type = 'nfo' AND dateYear >= #url.startYear# AND dateYear <= #url.endYear#
SELECT magID,magReleaseDate,magHeadline,magTitle,magIssue FROM magazineissues WHERE magReleaseDate IS NOT NULL
SELECT UniqueID,date,month,year,description,type,author FROM documents WHERE category <> 'Amiga' AND category <> 'Apple II' AND category <> 'Atari ST' AND year >= '#url.startYear#' AND year <= '#url.endYear#'
SELECT * FROM repositoryfiles WHERE dateYear <> 0 AND (type = 'Text' OR type = 'Interview' OR type = 'Newsletter') AND dateYear >= #url.startYear# AND dateYear <= #url.endYear#
SELECT UniqueID,date,month,year,description,type,author FROM documents WHERE (category = 'Amiga' OR category = 'Apple II' OR category = 'Atari ST') AND year IS NOT NULL AND year >= '#url.startYear#' AND year <= '#url.endYear#'
SELECT * FROM repositoryfiles WHERE dateYear <> 0 AND (type = 'Advert' OR type = 'ANSI Logo' OR type = 'ASCII Logo' OR type = 'BBS Advert' OR type = 'Image' OR type = 'Logo' OR type = 'Video') AND dateYear >= #url.startYear# AND dateYear <= #url.endYear#
SELECT *
FROM RSCombined
WHERE (
datasource IS NOT NULL
AND Ryear >= #url.startYear#
AND Ryear <= #url.endYear#
AND Rmonth IS NOT NULL
AND Rmonth <> 0
)
ORDER BY 5 asc, 4 asc, 3 asc