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 '%/H. B. Camp Pottery/%') ORDER BY date, publication, title, subtitle, id..