SELECT *

FROM stemcount

LEFT JOIN stemlocation USING (stemcount_id)

;