List articles:

Build your search criteria. The article must match all the values specified.
Click Search when complete:
Select article types: Newspaper   Trade Journal   Book  
Date:
Year between:   and 
Keywords:
Publication:
Click Search when complete:
SELECT LENGTH(body) as chars, id, type, subject, title, subtitle, researcher_notes, publication, date, YEAR(date) as year, city, state, status FROM publication WHERE (subject LIKE '%/G. F. Brunt Porcelain Company/%') ORDER BY date, publication, title, subtitle, id. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .