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 '%/Siemens, Halske & Co/%') ORDER BY date, publication, title, subtitle, id
No articles matching: Subject contains /Siemens, Halske & Co/;