A Few Helpful Alma Analytics Queries
Today:
CURRENT_DATE
CURRENT_TIMESTAMP
Setting Data Type:
CAST(“dimension.field” AS X)
X can be DATE or TIMESTAMP if a date field.
X can be STRING or INTEGER if a number.
Setting Time Part:
X(“dimension.field”)
X can equal YEAR, QUARTER, MONTH, DAY, DAYOFYEAR, DAYOFWEEK, HOUR, MINUTE, or SECOND for any date field.
Filter for 7 Days Ago:
TIMESTAMPADD(SQL_TSI_DAY, -7, CURRENT_DATE)
First Day of Last Month:
TIMESTAMPADD(SQL_TSI_MONTH, -1, TIMESTAMPADD( SQL_TSI_DAY , DAYOFMONTH( CURRENT_DATE) * -(1) + 1, CURRENT_DATE))
Last Day of Last Month:
TIMESTAMPADD( SQL_TSI_DAY , -(1), TIMESTAMPADD( SQL_TSI_DAY , DAYOFMONTH( CURRENT_DATE) * -(1) + 1, CURRENT_DATE))
First Day of Current Year:
TIMESTAMPADD(SQL_TSI_YEAR, 0, TIMESTAMPADD( SQL_TSI_DAY , DAYOFYEAR( CURRENT_DATE) * -(1) + 1, CURRENT_DATE))
Extract Subject Letter from Permanent Call Number:
Evaluate('regexp_substr(%1,''[A-z]+'')',"Holding Details"."Permanent Call Number")
Extract Subject Number from Permanent Call Number:
Evaluate('regexp_substr(%1,''[0-9]+'')',Evaluate('regexp_substr(%1,''[A-z]+[0-9]+'')',"Holding Details"."Permanent Call Number"))
Extract Subject Date from Permanent Call Number:
Evaluate('regexp_substr(%1,''([A-z])([0-9]+)\ ([0-9]+)'')',"Holding Details"."Permanent Call Number")
Split Call Numbers Based on a Period Followed by a Letter:
Split 1: REPLACE(Evaluate('regexp_substr(%1,''[^\.]+[^A-z]+'',1,1)',"Holding Details"."Permanent Call Number"),' .',‘’)
Split 2: REPLACE(Evaluate('regexp_substr(%1,''[^\.]+[^A-z]+'',1,2)',"Holding Details"."Permanent Call Number"),' .',‘’)
Extract Barcodes with Non-Numerical Characters from Barcode:
Evaluate('REGEXP_INSTR(%1, ''^[0-9]+$'')',"Physical Item Details"."Barcode")
Extract OCLC Number from Network Number:
CASE WHEN EVALUATE('regexp_substr(%1,''OCOLC'')',(UPPER("Bibliographic Details"."Network Number"))) IS NOT NULL THEN EVALUATE('regexp_substr(%1,''OCOLC+[0-9()]+'')',(UPPER("Bibliographic Details"."Network Number")))
WHEN EVALUATE('regexp_substr(%1,''OCN'')',(UPPER("Bibliographic Details"."Network Number"))) IS NOT NULL THEN EVALUATE('regexp_substr(%1,''OCN+[0-9]+'')',(UPPER("Bibliographic Details"."Network Number")))
WHEN EVALUATE('regexp_substr(%1,''OCM'')',(UPPER("Bibliographic Details"."Network Number"))) IS NOT NULL THEN EVALUATE('regexp_substr(%1,''OCM+[0-9]+'')',(UPPER("Bibliographic Details"."Network Number")))
WHEN EVALUATE('regexp_substr(%1,''ON'')',(UPPER("Bibliographic Details"."Network Number"))) IS NOT NULL THEN EVALUATE('regexp_substr(%1,''ON+[0-9]+'')',(UPPER("Bibliographic Details"."Network Number")))
ELSE 'No OCLC Number Available'
END
Extract 978 ISBNs from ISBN:
CASE WHEN "Bibliographic Details"."ISBN" LIKE '978%' THEN REPLACE(LEFT(SUBSTRING("Bibliographic Details"."ISBN" FROM LOCATE('978',"Bibliographic Details"."ISBN")), LOCATE(' ', SUBSTRING(CONCAT("Bibliographic Details"."ISBN",'; ') FROM LOCATE('978',"Bibliographic Details"."ISBN")))),';','')
WHEN "Bibliographic Details"."ISBN" LIKE '% 978%' THEN REPLACE(LEFT(SUBSTRING("Bibliographic Details"."ISBN" FROM LOCATE(' 978',"Bibliographic Details"."ISBN")), LOCATE(';', SUBSTRING(CONCAT("Bibliographic Details"."ISBN",'; ') FROM LOCATE(' 978',"Bibliographic Details"."ISBN")))),';','')
ELSE 'NO ISBN'
END
CASE Statement to group dates 1988-2020 and before 1988: (Bins are way simpler than writing a CASE statement.)
CASE WHEN ("Bibliographic Details"."Publication Date" NOT LIKE '%1988%' AND "Bibliographic Details"."Publication Date" NOT LIKE '%1989%' AND "Bibliographic Details"."Publication Date" NOT LIKE '%1990%' AND "Bibliographic Details"."Publication Date" NOT LIKE '%1991%' AND "Bibliographic Details"."Publication Date" NOT LIKE '%1992%' AND "Bibliographic Details"."Publication Date" NOT LIKE '%1993%' AND "Bibliographic Details"."Publication Date" NOT LIKE '%1994%' AND "Bibliographic Details"."Publication Date" NOT LIKE '%1995%' AND "Bibliographic Details"."Publication Date" NOT LIKE '%1996%' AND "Bibliographic Details"."Publication Date" NOT LIKE '%1997%' AND "Bibliographic Details"."Publication Date" NOT LIKE '%1998%' AND "Bibliographic Details"."Publication Date" NOT LIKE '%1999%' AND "Bibliographic Details"."Publication Date" NOT LIKE '%2000%' AND "Bibliographic Details"."Publication Date" NOT LIKE '%2001%' AND "Bibliographic Details"."Publication Date" NOT LIKE '%2002%' AND "Bibliographic Details"."Publication Date" NOT LIKE '%2003%' AND "Bibliographic Details"."Publication Date" NOT LIKE '%2004%' AND "Bibliographic Details"."Publication Date" NOT LIKE '%2005%' AND "Bibliographic Details"."Publication Date" NOT LIKE '%2006%' AND "Bibliographic Details"."Publication Date" NOT LIKE '%2007%' AND "Bibliographic Details"."Publication Date" NOT LIKE '%2008%' AND "Bibliographic Details"."Publication Date" NOT LIKE '%2009%' AND "Bibliographic Details"."Publication Date" NOT LIKE '%2010%' AND "Bibliographic Details"."Publication Date" NOT LIKE '%2011%' AND "Bibliographic Details"."Publication Date" NOT LIKE '%2012%' AND "Bibliographic Details"."Publication Date" NOT LIKE '%2013%' AND "Bibliographic Details"."Publication Date" NOT LIKE '%2014%' AND "Bibliographic Details"."Publication Date" NOT LIKE '%2015%' AND "Bibliographic Details"."Publication Date" NOT LIKE '%2016%' AND "Bibliographic Details"."Publication Date" NOT LIKE '%2017%' AND "Bibliographic Details"."Publication Date" NOT LIKE '%2018%' AND "Bibliographic Details"."Publication Date" NOT LIKE '%2019%' AND "Bibliographic Details"."Publication Date" NOT LIKE '%2020%') THEN '<=30 YEARS' ELSE '>30 YEARS' END
Filter for Publication Date before 1923: (Filters are way simpler than writing this in SQL.)
("Bibliographic Details"."Publication Date" LIKE '%1922%' OR "Bibliographic Details"."Publication Date" LIKE '%1921%' OR "Bibliographic Details"."Publication Date" LIKE '%1920%' OR "Bibliographic Details"."Publication Date" LIKE '%1919%' OR "Bibliographic Details"."Publication Date" LIKE '%1918%' OR "Bibliographic Details"."Publication Date" LIKE '%1917%' OR "Bibliographic Details"."Publication Date" LIKE '%1916%' OR "Bibliographic Details"."Publication Date" LIKE '%1915%' OR "Bibliographic Details"."Publication Date" LIKE '%1914%' OR "Bibliographic Details"."Publication Date" LIKE '%1913%' OR "Bibliographic Details"."Publication Date" LIKE '%1912%' OR "Bibliographic Details"."Publication Date" LIKE '%1911%' OR "Bibliographic Details"."Publication Date" LIKE '%1910%' OR "Bibliographic Details"."Publication Date" LIKE '%1909%' OR "Bibliographic Details"."Publication Date" LIKE '%1908%' OR "Bibliographic Details"."Publication Date" LIKE '%1907%' OR "Bibliographic Details"."Publication Date" LIKE '%1906%' OR "Bibliographic Details"."Publication Date" LIKE '%1905%' OR "Bibliographic Details"."Publication Date" LIKE '%1904%' OR "Bibliographic Details"."Publication Date" LIKE '%1903%' OR "Bibliographic Details"."Publication Date" LIKE '%1902%' OR "Bibliographic Details"."Publication Date" LIKE '%1901%' OR "Bibliographic Details"."Publication Date" LIKE '%1900%' OR "Bibliographic Details"."Publication Date" LIKE '%1899%' OR "Bibliographic Details"."Publication Date" LIKE '%1898%' OR "Bibliographic Details"."Publication Date" LIKE '%1897%' OR "Bibliographic Details"."Publication Date" LIKE '%1896%' OR "Bibliographic Details"."Publication Date" LIKE '%1895%' OR "Bibliographic Details"."Publication Date" LIKE '%1894%' OR "Bibliographic Details"."Publication Date" LIKE '%1893%' OR "Bibliographic Details"."Publication Date" LIKE '%1892%' OR "Bibliographic Details"."Publication Date" LIKE '%1891%' OR "Bibliographic Details"."Publication Date" LIKE '%1890%' OR "Bibliographic Details"."Publication Date" LIKE '%1889%' OR "Bibliographic Details"."Publication Date" LIKE '%1888%' OR "Bibliographic Details"."Publication Date" LIKE '%1887%' OR "Bibliographic Details"."Publication Date" LIKE '%1886%' OR "Bibliographic Details"."Publication Date" LIKE '%1885%' OR "Bibliographic Details"."Publication Date" LIKE '%1884%' OR "Bibliographic Details"."Publication Date" LIKE '%1883%' OR "Bibliographic Details"."Publication Date" LIKE '%1882%' OR "Bibliographic Details"."Publication Date" LIKE '%1881%' OR "Bibliographic Details"."Publication Date" LIKE '%1880%' OR "Bibliographic Details"."Publication Date" LIKE '%1879%' OR "Bibliographic Details"."Publication Date" LIKE '%1878%' OR "Bibliographic Details"."Publication Date" LIKE '%1877%' OR "Bibliographic Details"."Publication Date" LIKE '%1876%' OR "Bibliographic Details"."Publication Date" LIKE '%1875%' OR "Bibliographic Details"."Publication Date" LIKE '%1874%' OR "Bibliographic Details"."Publication Date" LIKE '%1873%' OR "Bibliographic Details"."Publication Date" LIKE '%1872%' OR "Bibliographic Details"."Publication Date" LIKE '%1871%' OR "Bibliographic Details"."Publication Date" LIKE '%1870%' OR "Bibliographic Details"."Publication Date" LIKE '%1869%' OR "Bibliographic Details"."Publication Date" LIKE '%1868%' OR "Bibliographic Details"."Publication Date" LIKE '%1867%' OR "Bibliographic Details"."Publication Date" LIKE '%1866%' OR "Bibliographic Details"."Publication Date" LIKE '%1865%' OR "Bibliographic Details"."Publication Date" LIKE '%1864%' OR "Bibliographic Details"."Publication Date" LIKE '%1863%' OR "Bibliographic Details"."Publication Date" LIKE '%1862%' OR "Bibliographic Details"."Publication Date" LIKE '%1861%' OR "Bibliographic Details"."Publication Date" LIKE '%1860%' OR "Bibliographic Details"."Publication Date" LIKE '%1859%' OR "Bibliographic Details"."Publication Date" LIKE '%1858%' OR "Bibliographic Details"."Publication Date" LIKE '%1857%' OR "Bibliographic Details"."Publication Date" LIKE '%1856%' OR "Bibliographic Details"."Publication Date" LIKE '%1855%' OR "Bibliographic Details"."Publication Date" LIKE '%1854%' OR "Bibliographic Details"."Publication Date" LIKE '%1853%' OR "Bibliographic Details"."Publication Date" LIKE '%1852%' OR "Bibliographic Details"."Publication Date" LIKE '%1851%' OR "Bibliographic Details"."Publication Date" LIKE '%1850%' OR "Bibliographic Details"."Publication Date" LIKE '%1849%' OR "Bibliographic Details"."Publication Date" LIKE '%1848%' OR "Bibliographic Details"."Publication Date" LIKE '%1847%' OR "Bibliographic Details"."Publication Date" LIKE '%1846%' OR "Bibliographic Details"."Publication Date" LIKE '%1845%' OR "Bibliographic Details"."Publication Date" LIKE '%1844%' OR "Bibliographic Details"."Publication Date" LIKE '%1843%' OR "Bibliographic Details"."Publication Date" LIKE '%1842%' OR "Bibliographic Details"."Publication Date" LIKE '%1841%' OR "Bibliographic Details"."Publication Date" LIKE '%1840%' OR "Bibliographic Details"."Publication Date" LIKE '%1839%' OR "Bibliographic Details"."Publication Date" LIKE '%1838%' OR "Bibliographic Details"."Publication Date" LIKE '%1837%' OR "Bibliographic Details"."Publication Date" LIKE '%1836%' OR "Bibliographic Details"."Publication Date" LIKE '%1835%' OR "Bibliographic Details"."Publication Date" LIKE '%1834%' OR "Bibliographic Details"."Publication Date" LIKE '%1833%' OR "Bibliographic Details"."Publication Date" LIKE '%1832%' OR "Bibliographic Details"."Publication Date" LIKE '%1831%' OR "Bibliographic Details"."Publication Date" LIKE '%1830%' OR "Bibliographic Details"."Publication Date" LIKE '%1829%' OR "Bibliographic Details"."Publication Date" LIKE '%1828%' OR "Bibliographic Details"."Publication Date" LIKE '%1827%' OR "Bibliographic Details"."Publication Date" LIKE '%1826%' OR "Bibliographic Details"."Publication Date" LIKE '%1825%' OR "Bibliographic Details"."Publication Date" LIKE '%1824%' OR "Bibliographic Details"."Publication Date" LIKE '%1823%' OR "Bibliographic Details"."Publication Date" LIKE '%1822%' OR "Bibliographic Details"."Publication Date" LIKE '%1821%' OR "Bibliographic Details"."Publication Date" LIKE '%1820%' OR "Bibliographic Details"."Publication Date" LIKE '%1819%' OR "Bibliographic Details"."Publication Date" LIKE '%1818%' OR "Bibliographic Details"."Publication Date" LIKE '%1817%' OR "Bibliographic Details"."Publication Date" LIKE '%1816%' OR "Bibliographic Details"."Publication Date" LIKE '%1815%' OR "Bibliographic Details"."Publication Date" LIKE '%1814%' OR "Bibliographic Details"."Publication Date" LIKE '%1813%' OR "Bibliographic Details"."Publication Date" LIKE '%1812%' OR "Bibliographic Details"."Publication Date" LIKE '%1811%' OR "Bibliographic Details"."Publication Date" LIKE '%1810%' OR "Bibliographic Details"."Publication Date" LIKE '%1809%' OR "Bibliographic Details"."Publication Date" LIKE '%1808%' OR "Bibliographic Details"."Publication Date" LIKE '%1807%' OR "Bibliographic Details"."Publication Date" LIKE '%1806%' OR "Bibliographic Details"."Publication Date" LIKE '%1805%' OR "Bibliographic Details"."Publication Date" LIKE '%1804%' OR "Bibliographic Details"."Publication Date" LIKE '%1803%' OR "Bibliographic Details"."Publication Date" LIKE '%1802%' OR "Bibliographic Details"."Publication Date" LIKE '%1801%' OR "Bibliographic Details"."Publication Date" LIKE '%1800%' OR "Bibliographic Details"."Publication Date" LIKE '%1799%' OR "Bibliographic Details"."Publication Date" LIKE '%1798%' OR "Bibliographic Details"."Publication Date" LIKE '%1797%' OR "Bibliographic Details"."Publication Date" LIKE '%1796%' OR "Bibliographic Details"."Publication Date" LIKE '%1795%' OR "Bibliographic Details"."Publication Date" LIKE '%1794%' OR "Bibliographic Details"."Publication Date" LIKE '%1793%' OR "Bibliographic Details"."Publication Date" LIKE '%1792%' OR "Bibliographic Details"."Publication Date" LIKE '%1791%' OR "Bibliographic Details"."Publication Date" LIKE '%1790%' OR "Bibliographic Details"."Publication Date" LIKE '%1789%' OR "Bibliographic Details"."Publication Date" LIKE '%1788%' OR "Bibliographic Details"."Publication Date" LIKE '%1787%' OR "Bibliographic Details"."Publication Date" LIKE '%1786%' OR "Bibliographic Details"."Publication Date" LIKE '%1785%' OR "Bibliographic Details"."Publication Date" LIKE '%1784%' OR "Bibliographic Details"."Publication Date" LIKE '%1783%' OR "Bibliographic Details"."Publication Date" LIKE '%1782%' OR "Bibliographic Details"."Publication Date" LIKE '%1781%' OR "Bibliographic Details"."Publication Date" LIKE '%1780%' OR "Bibliographic Details"."Publication Date" LIKE '%1779%' OR "Bibliographic Details"."Publication Date" LIKE '%1778%' OR "Bibliographic Details"."Publication Date" LIKE '%1777%' OR "Bibliographic Details"."Publication Date" LIKE '%1776%' OR "Bibliographic Details"."Publication Date" LIKE '%1775%' OR "Bibliographic Details"."Publication Date" LIKE '%1774%' OR "Bibliographic Details"."Publication Date" LIKE '%1773%' OR "Bibliographic Details"."Publication Date" LIKE '%1772%' OR "Bibliographic Details"."Publication Date" LIKE '%1771%' OR "Bibliographic Details"."Publication Date" LIKE '%1770%' OR "Bibliographic Details"."Publication Date" LIKE '%1769%' OR "Bibliographic Details"."Publication Date" LIKE '%1768%' OR "Bibliographic Details"."Publication Date" LIKE '%1767%' OR "Bibliographic Details"."Publication Date" LIKE '%1766%' OR "Bibliographic Details"."Publication Date" LIKE '%1765%' OR "Bibliographic Details"."Publication Date" LIKE '%1764%' OR "Bibliographic Details"."Publication Date" LIKE '%1763%' OR "Bibliographic Details"."Publication Date" LIKE '%1762%' OR "Bibliographic Details"."Publication Date" LIKE '%1761%' OR "Bibliographic Details"."Publication Date" LIKE '%1760%' OR "Bibliographic Details"."Publication Date" LIKE '%1759%' OR "Bibliographic Details"."Publication Date" LIKE '%1758%' OR "Bibliographic Details"."Publication Date" LIKE '%1757%' OR "Bibliographic Details"."Publication Date" LIKE '%1756%' OR "Bibliographic Details"."Publication Date" LIKE '%1755%' OR "Bibliographic Details"."Publication Date" LIKE '%1754%' OR "Bibliographic Details"."Publication Date" LIKE '%1753%' OR "Bibliographic Details"."Publication Date" LIKE '%1752%' OR "Bibliographic Details"."Publication Date" LIKE '%1751%' OR "Bibliographic Details"."Publication Date" LIKE '%1750%' OR "Bibliographic Details"."Publication Date" LIKE '%1749%' OR "Bibliographic Details"."Publication Date" LIKE '%1748%' OR "Bibliographic Details"."Publication Date" LIKE '%1747%' OR "Bibliographic Details"."Publication Date" LIKE '%1746%' OR "Bibliographic Details"."Publication Date" LIKE '%1745%' OR "Bibliographic Details"."Publication Date" LIKE '%1744%' OR "Bibliographic Details"."Publication Date" LIKE '%1743%' OR "Bibliographic Details"."Publication Date" LIKE '%1742%' OR "Bibliographic Details"."Publication Date" LIKE '%1741%' OR "Bibliographic Details"."Publication Date" LIKE '%1740%' OR "Bibliographic Details"."Publication Date" LIKE '%1739%' OR "Bibliographic Details"."Publication Date" LIKE '%1738%' OR "Bibliographic Details"."Publication Date" LIKE '%1737%' OR "Bibliographic Details"."Publication Date" LIKE '%1736%' OR "Bibliographic Details"."Publication Date" LIKE '%1735%' OR "Bibliographic Details"."Publication Date" LIKE '%1734%' OR "Bibliographic Details"."Publication Date" LIKE '%1733%' OR "Bibliographic Details"."Publication Date" LIKE '%1732%' OR "Bibliographic Details"."Publication Date" LIKE '%1731%' OR "Bibliographic Details"."Publication Date" LIKE '%1730%' OR "Bibliographic Details"."Publication Date" LIKE '%1729%' OR "Bibliographic Details"."Publication Date" LIKE '%1728%' OR "Bibliographic Details"."Publication Date" LIKE '%1727%' OR "Bibliographic Details"."Publication Date" LIKE '%1726%' OR "Bibliographic Details"."Publication Date" LIKE '%1725%' OR "Bibliographic Details"."Publication Date" LIKE '%1724%' OR "Bibliographic Details"."Publication Date" LIKE '%1723%' OR "Bibliographic Details"."Publication Date" LIKE '%1722%' OR "Bibliographic Details"."Publication Date" LIKE '%1721%' OR "Bibliographic Details"."Publication Date" LIKE '%1720%' OR "Bibliographic Details"."Publication Date" LIKE '%1719%' OR "Bibliographic Details"."Publication Date" LIKE '%1718%' OR "Bibliographic Details"."Publication Date" LIKE '%1717%' OR "Bibliographic Details"."Publication Date" LIKE '%1716%' OR "Bibliographic Details"."Publication Date" LIKE '%1715%' OR "Bibliographic Details"."Publication Date" LIKE '%1714%' OR "Bibliographic Details"."Publication Date" LIKE '%1713%' OR "Bibliographic Details"."Publication Date" LIKE '%1712%' OR "Bibliographic Details"."Publication Date" LIKE '%1711%' OR "Bibliographic Details"."Publication Date" LIKE '%1710%' OR "Bibliographic Details"."Publication Date" LIKE '%1709%' OR "Bibliographic Details"."Publication Date" LIKE '%1708%' OR "Bibliographic Details"."Publication Date" LIKE '%1707%' OR "Bibliographic Details"."Publication Date" LIKE '%1706%' OR "Bibliographic Details"."Publication Date" LIKE '%1705%' OR "Bibliographic Details"."Publication Date" LIKE '%1704%' OR "Bibliographic Details"."Publication Date" LIKE '%1703%' OR "Bibliographic Details"."Publication Date" LIKE '%1702%' OR "Bibliographic Details"."Publication Date" LIKE '%1701%' OR "Bibliographic Details"."Publication Date" LIKE '%1700%' OR "Bibliographic Details"."Publication Date" LIKE '%1699%' OR "Bibliographic Details"."Publication Date" LIKE '%1698%' OR "Bibliographic Details"."Publication Date" LIKE '%1697%' OR "Bibliographic Details"."Publication Date" LIKE '%1696%' OR "Bibliographic Details"."Publication Date" LIKE '%1695%' OR "Bibliographic Details"."Publication Date" LIKE '%1694%' OR "Bibliographic Details"."Publication Date" LIKE '%1693%' OR "Bibliographic Details"."Publication Date" LIKE '%1692%' OR "Bibliographic Details"."Publication Date" LIKE '%1691%' OR "Bibliographic Details"."Publication Date" LIKE '%1690%' OR "Bibliographic Details"."Publication Date" LIKE '%1689%' OR "Bibliographic Details"."Publication Date" LIKE '%1688%' OR "Bibliographic Details"."Publication Date" LIKE '%1687%' OR "Bibliographic Details"."Publication Date" LIKE '%1686%' OR "Bibliographic Details"."Publication Date" LIKE '%1685%' OR "Bibliographic Details"."Publication Date" LIKE '%1684%' OR "Bibliographic Details"."Publication Date" LIKE '%1683%' OR "Bibliographic Details"."Publication Date" LIKE '%1682%' OR "Bibliographic Details"."Publication Date" LIKE '%1681%' OR "Bibliographic Details"."Publication Date" LIKE '%1680%' OR "Bibliographic Details"."Publication Date" LIKE '%1679%' OR "Bibliographic Details"."Publication Date" LIKE '%1678%' OR "Bibliographic Details"."Publication Date" LIKE '%1677%' OR "Bibliographic Details"."Publication Date" LIKE '%1676%' OR "Bibliographic Details"."Publication Date" LIKE '%1675%' OR "Bibliographic Details"."Publication Date" LIKE '%1674%' OR "Bibliographic Details"."Publication Date" LIKE '%1673%' OR "Bibliographic Details"."Publication Date" LIKE '%1672%' OR "Bibliographic Details"."Publication Date" LIKE '%1671%' OR "Bibliographic Details"."Publication Date" LIKE '%1670%' OR "Bibliographic Details"."Publication Date" LIKE '%1669%' OR "Bibliographic Details"."Publication Date" LIKE '%1668%' OR "Bibliographic Details"."Publication Date" LIKE '%1667%' OR "Bibliographic Details"."Publication Date" LIKE '%1666%' OR "Bibliographic Details"."Publication Date" LIKE '%1665%' OR "Bibliographic Details"."Publication Date" LIKE '%1664%' OR "Bibliographic Details"."Publication Date" LIKE '%1663%' OR "Bibliographic Details"."Publication Date" LIKE '%1662%' OR "Bibliographic Details"."Publication Date" LIKE '%1661%' OR "Bibliographic Details"."Publication Date" LIKE '%1660%' OR "Bibliographic Details"."Publication Date" LIKE '%1659%' OR "Bibliographic Details"."Publication Date" LIKE '%1658%' OR "Bibliographic Details"."Publication Date" LIKE '%1657%' OR "Bibliographic Details"."Publication Date" LIKE '%1656%' OR "Bibliographic Details"."Publication Date" LIKE '%1655%' OR "Bibliographic Details"."Publication Date" LIKE '%1654%' OR "Bibliographic Details"."Publication Date" LIKE '%1653%' OR "Bibliographic Details"."Publication Date" LIKE '%1652%' OR "Bibliographic Details"."Publication Date" LIKE '%1651%' OR "Bibliographic Details"."Publication Date" LIKE '%1650%' OR "Bibliographic Details"."Publication Date" LIKE '%1649%' OR "Bibliographic Details"."Publication Date" LIKE '%1648%' OR "Bibliographic Details"."Publication Date" LIKE '%1647%' OR "Bibliographic Details"."Publication Date" LIKE '%1646%' OR "Bibliographic Details"."Publication Date" LIKE '%1645%' OR "Bibliographic Details"."Publication Date" LIKE '%1644%' OR "Bibliographic Details"."Publication Date" LIKE '%1643%' OR "Bibliographic Details"."Publication Date" LIKE '%1642%' OR "Bibliographic Details"."Publication Date" LIKE '%1641%' OR "Bibliographic Details"."Publication Date" LIKE '%1640%' OR "Bibliographic Details"."Publication Date" LIKE '%1639%' OR "Bibliographic Details"."Publication Date" LIKE '%1638%' OR "Bibliographic Details"."Publication Date" LIKE '%1637%' OR "Bibliographic Details"."Publication Date" LIKE '%1636%' OR "Bibliographic Details"."Publication Date" LIKE '%1635%' OR "Bibliographic Details"."Publication Date" LIKE '%1634%' OR "Bibliographic Details"."Publication Date" LIKE '%1633%' OR "Bibliographic Details"."Publication Date" LIKE '%1632%' OR "Bibliographic Details"."Publication Date" LIKE '%1631%' OR "Bibliographic Details"."Publication Date" LIKE '%1630%' OR "Bibliographic Details"."Publication Date" LIKE '%1629%' OR "Bibliographic Details"."Publication Date" LIKE '%1628%' OR "Bibliographic Details"."Publication Date" LIKE '%1627%' OR "Bibliographic Details"."Publication Date" LIKE '%1626%' OR "Bibliographic Details"."Publication Date" LIKE '%1625%' OR "Bibliographic Details"."Publication Date" LIKE '%1624%' OR "Bibliographic Details"."Publication Date" LIKE '%1623%' OR "Bibliographic Details"."Publication Date" LIKE '%1622%' OR "Bibliographic Details"."Publication Date" LIKE '%1621%' OR "Bibliographic Details"."Publication Date" LIKE '%1620%' OR "Bibliographic Details"."Publication Date" LIKE '%1619%' OR "Bibliographic Details"."Publication Date" LIKE '%1618%' OR "Bibliographic Details"."Publication Date" LIKE '%1617%' OR "Bibliographic Details"."Publication Date" LIKE '%1616%' OR "Bibliographic Details"."Publication Date" LIKE '%1615%' OR "Bibliographic Details"."Publication Date" LIKE '%1614%' OR "Bibliographic Details"."Publication Date" LIKE '%1613%' OR "Bibliographic Details"."Publication Date" LIKE '%1612%' OR "Bibliographic Details"."Publication Date" LIKE '%1611%' OR "Bibliographic Details"."Publication Date" LIKE '%1610%' OR "Bibliographic Details"."Publication Date" LIKE '%1609%' OR "Bibliographic Details"."Publication Date" LIKE '%1608%' OR "Bibliographic Details"."Publication Date" LIKE '%1607%' OR "Bibliographic Details"."Publication Date" LIKE '%1606%' OR "Bibliographic Details"."Publication Date" LIKE '%1605%' OR "Bibliographic Details"."Publication Date" LIKE '%1604%' OR "Bibliographic Details"."Publication Date" LIKE '%1603%' OR "Bibliographic Details"."Publication Date" LIKE '%1602%' OR "Bibliographic Details"."Publication Date" LIKE '%1601%' OR "Bibliographic Details"."Publication Date" LIKE '%1600%')