SELECT *
FROM stemlocation
LEFT JOIN stemcount USING (stemcount_id)
;