No main habitat but additional habitats present

select main_habit mhabitat, 
s1habtype,s2habtype,s3habtype habitat,
st_intersection(h.geom,s.geom) geom from 
(select geom,lnr_name from local_reserves where lnr_name like 'Hengist%') s,
ph_v2_1 h 
where st_intersects(h.geom,s.geom)

select geom,lnr_name from local_reserves where lnr_name like 'Hengist%'