SELECT IssueYear
FROM refereed_publications
GROUP BY IssueYear
ORDER BY IssueYear DESC;
SELECT *
FROM refereed_publications
WHERE IssueYear = '#IssueYear#'
ORDER BY IssueNo DESC;
SELECT *
FROM refereed_publications
WHERE IssueYear = '#IssueYear#' AND (
IssueNo = #i#
OR
)
ORDER BY IssueNo DESC;
SELECT *
FROM refereed_publications
WHERE IssueYear = '#IssueYear#'
ORDER BY IssueNo DESC;
Conference Proceedings
SELECT *
FROM conference_proceedings
WHERE IssueYear = '#IssueYear#'
ORDER BY IssueNo DESC;
SELECT *
FROM conference_proceedings
WHERE IssueYear = '#IssueYear#' AND (
IssueNo = #i#
OR
)
ORDER BY IssueNo DESC;
SELECT *
FROM conference_proceedings
WHERE IssueYear = '#IssueYear#'
ORDER BY IssueNo DESC;