SELECT IssueYear
FROM invited_publications
GROUP BY IssueYear
ORDER BY IssueYear DESC;
SELECT *
FROM invited_publications
WHERE IssueYear = '#IssueYear#'
ORDER BY IssueNo DESC;
SELECT *
FROM invited_publications
WHERE IssueYear = '#IssueYear#' AND (
IssueNo = #i#
OR
)
ORDER BY IssueNo DESC;
SELECT *
FROM invited_publications
WHERE IssueYear = '#IssueYear#'
ORDER BY IssueNo DESC;